View GitHub Repository phpPgAdmin6

Schedule Inspection
Subscribe

Code Duplication    Length = 4-4 lines in 2 locations

src/database/Postgres.php 2 locations

@@ 2920-2923 (lines=4) @@
2917 
                // Have to account for weird placing of length for with/without
2918 
                // time zone types
2919 
                case 'timestamp with time zone':
2920 
                case 'timestamp without time zone':
2921 
                    $qual = substr($type, 9);
2922 
                    $sql = "ALTER TABLE \"{$f_schema}\".\"{$table}\" ADD COLUMN \"{$column}\" timestamp({$length}){$qual}";
2923 
                    break;
2924 
                case 'time with time zone':
2925 
                case 'time without time zone':
2926 
                    $qual = substr($type, 4);
@@ 2925-2928 (lines=4) @@
2922 
                    $sql = "ALTER TABLE \"{$f_schema}\".\"{$table}\" ADD COLUMN \"{$column}\" timestamp({$length}){$qual}";
2923 
                    break;
2924 
                case 'time with time zone':
2925 
                case 'time without time zone':
2926 
                    $qual = substr($type, 4);
2927 
                    $sql = "ALTER TABLE \"{$f_schema}\".\"{$table}\" ADD COLUMN \"{$column}\" time({$length}){$qual}";
2928 
                    break;
2929 
                default:
2930 
                    $sql = "ALTER TABLE \"{$f_schema}\".\"{$table}\" ADD COLUMN \"{$column}\" {$type}({$length})";
2931 
            }