View GitHub Repository phpPgAdmin6

Schedule Inspection
Subscribe

Code Duplication    Length = 4-4 lines in 2 locations

src/database/Postgres.php 2 locations

@@ 2862-2865 (lines=4) @@
2859 
                // Have to account for weird placing of length for with/without
2860 
                // time zone types
2861 
                case 'timestamp with time zone':
2862 
                case 'timestamp without time zone':
2863 
                    $qual = substr($type, 9);
2864 
                    $sql  = "ALTER TABLE \"{$f_schema}\".\"{$table}\" ADD COLUMN \"{$column}\" timestamp({$length}){$qual}";
2865 
                    break;
2866 
                case 'time with time zone':
2867 
                case 'time without time zone':
2868 
                    $qual = substr($type, 4);
@@ 2867-2870 (lines=4) @@
2864 
                    $sql  = "ALTER TABLE \"{$f_schema}\".\"{$table}\" ADD COLUMN \"{$column}\" timestamp({$length}){$qual}";
2865 
                    break;
2866 
                case 'time with time zone':
2867 
                case 'time without time zone':
2868 
                    $qual = substr($type, 4);
2869 
                    $sql  = "ALTER TABLE \"{$f_schema}\".\"{$table}\" ADD COLUMN \"{$column}\" time({$length}){$qual}";
2870 
                    break;
2871 
                default:
2872 
                    $sql = "ALTER TABLE \"{$f_schema}\".\"{$table}\" ADD COLUMN \"{$column}\" {$type}({$length})";
2873 
            }