EVOLUTION-MANAGER

Edit File: postgresql.py

from django_evolution.tests.utils import (generate_constraint_name,
                                          generate_index_name)

add_field = {
    'AddNonNullNonCallableColumnModel': '\n'.join([
        'ALTER TABLE "tests_testmodel"'
        ' ADD COLUMN "added_field" integer NOT NULL DEFAULT 1;',

'ALTER TABLE "tests_testmodel"'
        ' ALTER COLUMN "added_field" DROP DEFAULT;',
    ]),

'AddNonNullCallableColumnModel': '\n'.join([
        'ALTER TABLE "tests_testmodel" ADD COLUMN "added_field" integer;',

'UPDATE "tests_testmodel"'
        ' SET "added_field" = "int_field" WHERE "added_field" IS NULL;',

'ALTER TABLE "tests_testmodel"'
        ' ALTER COLUMN "added_field" SET NOT NULL;',
    ]),

'AddNullColumnWithInitialColumnModel': '\n'.join([
        'ALTER TABLE "tests_testmodel"'
        ' ADD COLUMN "added_field" integer NULL DEFAULT 1;',

'ALTER TABLE "tests_testmodel"'
        ' ALTER COLUMN "added_field" DROP DEFAULT;',
    ]),

'AddStringColumnModel': '\n'.join([
        'ALTER TABLE "tests_testmodel"'
        ' ADD COLUMN "added_field" varchar(10) NOT NULL'
        ' DEFAULT \'abc\\\'s xyz\';',

'ALTER TABLE "tests_testmodel"'
        ' ALTER COLUMN "added_field" DROP DEFAULT;',
    ]),

'AddBlankStringColumnModel': '\n'.join([
        'ALTER TABLE "tests_testmodel"'
        ' ADD COLUMN "added_field" varchar(10) NOT NULL DEFAULT \'\';',

'ALTER TABLE "tests_testmodel"'
        ' ALTER COLUMN "added_field" DROP DEFAULT;',
    ]),

'AddDateColumnModel': '\n'.join([
        'ALTER TABLE "tests_testmodel"'
        ' ADD COLUMN "added_field" timestamp with'
        ' time zone NOT NULL DEFAULT 2007-12-13 16:42:00;',

'ALTER TABLE "tests_testmodel"'
        ' ALTER COLUMN "added_field" DROP DEFAULT;',
    ]),

'AddDefaultColumnModel': '\n'.join([
        'ALTER TABLE "tests_testmodel"'
        ' ADD COLUMN "added_field" integer NOT NULL DEFAULT 42;',

'ALTER TABLE "tests_testmodel"'
        ' ALTER COLUMN "added_field" DROP DEFAULT;',
    ]),

'AddMismatchInitialBoolColumnModel': '\n'.join([
        'ALTER TABLE "tests_testmodel"'
        ' ADD COLUMN "added_field" boolean NOT NULL DEFAULT False;',

'ALTER TABLE "tests_testmodel"'
        ' ALTER COLUMN "added_field" DROP DEFAULT;',
    ]),

'AddEmptyStringDefaultColumnModel': '\n'.join([
        'ALTER TABLE "tests_testmodel"'
        ' ADD COLUMN "added_field" varchar(20) NOT NULL DEFAULT \'\';',

'ALTER TABLE "tests_testmodel"'
        ' ALTER COLUMN "added_field" DROP DEFAULT;',
    ]),

'AddNullColumnModel': (
        'ALTER TABLE "tests_testmodel" ADD COLUMN "added_field" integer NULL;'
    ),

'NonDefaultColumnModel': (
        'ALTER TABLE "tests_testmodel"'
        ' ADD COLUMN "non-default_column" integer NULL;'
    ),

'AddColumnCustomTableModel': (
        'ALTER TABLE "custom_table_name"'
        ' ADD COLUMN "added_field" integer NULL;'
    ),

'AddIndexedColumnModel': '\n'.join([
        'ALTER TABLE "tests_testmodel" ADD COLUMN "add_field" integer NULL;',
        'CREATE INDEX "tests_testmodel_add_field"'
        ' ON "tests_testmodel" ("add_field");'
    ]),

'AddUniqueColumnModel': (
        'ALTER TABLE "tests_testmodel"'
        ' ADD COLUMN "added_field" integer NULL UNIQUE;'
    ),

'AddUniqueIndexedModel': (
        'ALTER TABLE "tests_testmodel"'
        ' ADD COLUMN "added_field" integer NULL UNIQUE;'
    ),

'AddForeignKeyModel': '\n'.join([
        'ALTER TABLE "tests_testmodel"'
        ' ADD COLUMN "added_field_id" integer NULL REFERENCES'
        ' "tests_addanchor1" ("id")  DEFERRABLE INITIALLY DEFERRED;',

'CREATE INDEX "tests_testmodel_added_field_id"'
        ' ON "tests_testmodel" ("added_field_id");'
    ]),

'AddManyToManyDatabaseTableModel': '\n'.join([
        'CREATE TABLE "tests_testmodel_added_field" (',
        '    "id" serial NOT NULL PRIMARY KEY,',
        '    "testmodel_id" integer NOT NULL,',
        '    "addanchor1_id" integer NOT NULL,',
        '    UNIQUE ("testmodel_id", "addanchor1_id")',
        ')',
        ';',

'ALTER TABLE "tests_testmodel_added_field"'
        ' ADD CONSTRAINT "%s" FOREIGN KEY ("addanchor1_id")'
        ' REFERENCES "tests_addanchor1" ("id")'
        ' DEFERRABLE INITIALLY DEFERRED;'
        % generate_constraint_name('addanchor1_id', 'id',
                                   'tests_testmodel_added_field',
                                   'tests_addanchor1'),

'ALTER TABLE "tests_testmodel_added_field"'
        ' ADD CONSTRAINT "%s" FOREIGN KEY ("testmodel_id")'
        ' REFERENCES "tests_testmodel" ("id")'
        ' DEFERRABLE INITIALLY DEFERRED;'
        % generate_constraint_name('testmodel_id', 'id',
                                   'tests_testmodel_added_field',
                                   'tests_testmodel'),
    ]),

'AddManyToManyNonDefaultDatabaseTableModel': '\n'.join([
        'CREATE TABLE "tests_testmodel_added_field" (',
        '    "id" serial NOT NULL PRIMARY KEY,',
        '    "testmodel_id" integer NOT NULL,',
        '    "addanchor2_id" integer NOT NULL,',
        '    UNIQUE ("testmodel_id", "addanchor2_id")',
        ')',
        ';',

'ALTER TABLE "tests_testmodel_added_field"'
        ' ADD CONSTRAINT "%s" FOREIGN KEY ("addanchor2_id")'
        ' REFERENCES "custom_add_anchor_table" ("id")'
        ' DEFERRABLE INITIALLY DEFERRED;'
        % generate_constraint_name('addanchor2_id', 'id',
                                   'tests_testmodel_added_field',
                                   'custom_add_anchor_table'),

'AddManyToManySelf': '\n'.join([
        'CREATE TABLE "tests_testmodel_added_field" (',
        '    "id" serial NOT NULL PRIMARY KEY,',
        '    "from_testmodel_id" integer NOT NULL,',
        '    "to_testmodel_id" integer NOT NULL,',
        '    UNIQUE ("from_testmodel_id", "to_testmodel_id")',
        ')',
        ';',

'ALTER TABLE "tests_testmodel_added_field"'
        ' ADD CONSTRAINT "%s" FOREIGN KEY ("from_testmodel_id")'
        ' REFERENCES "tests_testmodel" ("id")'
        ' DEFERRABLE INITIALLY DEFERRED;'
        % generate_constraint_name('from_testmodel_id', 'id',
                                   'tests_testmodel_added_field',
                                   'tests_testmodel'),

'ALTER TABLE "tests_testmodel_added_field"'
        ' ADD CONSTRAINT "%s" FOREIGN KEY ("to_testmodel_id")'
        ' REFERENCES "tests_testmodel" ("id")'
        ' DEFERRABLE INITIALLY DEFERRED;'
        % generate_constraint_name('to_testmodel_id', 'id',
                                   'tests_testmodel_added_field',
                                   'tests_testmodel'),
    ]),
}

delete_field = {
    'DefaultNamedColumnModel': (
        'ALTER TABLE "tests_testmodel" DROP COLUMN "int_field" CASCADE;'
    ),

'NonDefaultNamedColumnModel': (
        'ALTER TABLE "tests_testmodel"'
        ' DROP COLUMN "non-default_db_column" CASCADE;'
    ),

'ConstrainedColumnModel': (
        'ALTER TABLE "tests_testmodel" DROP COLUMN "int_field3" CASCADE;'
    ),

'DefaultManyToManyModel': (
        'DROP TABLE "tests_testmodel_m2m_field1";'
    ),

'NonDefaultManyToManyModel': (
        'DROP TABLE "non-default_m2m_table";'
    ),

'DeleteForeignKeyModel': (
        'ALTER TABLE "tests_testmodel" DROP COLUMN "fk_field1_id" CASCADE;'
    ),

'DeleteColumnCustomTableModel': (
        'ALTER TABLE "custom_table_name" DROP COLUMN "value" CASCADE;'
    ),
}

change_field = {
    "SetNotNullChangeModelWithConstant": '\n'.join([
        'UPDATE "tests_testmodel"'
        ' SET "char_field1" = \'abc\\\'s xyz\' WHERE "char_field1" IS NULL;',

'ALTER TABLE "tests_testmodel"'
        ' ALTER COLUMN "char_field1" SET NOT NULL;',
    ]),

"SetNotNullChangeModelWithCallable": '\n'.join([
        'UPDATE "tests_testmodel"'
        ' SET "char_field1" = "char_field" WHERE "char_field1" IS NULL;',

'ALTER TABLE "tests_testmodel"'
        ' ALTER COLUMN "char_field1" SET NOT NULL;',
    ]),

"SetNullChangeModel": (
        'ALTER TABLE "tests_testmodel"'
        ' ALTER COLUMN "char_field2" DROP NOT NULL;'
    ),

"NoOpChangeModel": '',

"IncreasingMaxLengthChangeModel": (
        'ALTER TABLE "tests_testmodel"'
        ' ALTER COLUMN "char_field" TYPE varchar(45)'
        ' USING CAST("char_field" as varchar(45));'
    ),

"DecreasingMaxLengthChangeModel": (
        'ALTER TABLE "tests_testmodel"'
        ' ALTER COLUMN "char_field" TYPE varchar(1)'
        ' USING CAST("char_field" as varchar(1));'
    ),

"DBColumnChangeModel": (
        'ALTER TABLE "tests_testmodel"'
        ' RENAME COLUMN "custom_db_column" TO "customised_db_column";'
    ),

"AddDBIndexChangeModel": (
        'CREATE INDEX "tests_testmodel_int_field2"'
        ' ON "tests_testmodel" ("int_field2");'
    ),

'AddDBIndexNoOpChangeModel': '',

"RemoveDBIndexChangeModel": (
        'DROP INDEX "tests_testmodel_int_field1";'
    ),

'RemoveDBIndexNoOpChangeModel': '',

"AddUniqueChangeModel": (
        'ALTER TABLE "tests_testmodel" ADD CONSTRAINT %s UNIQUE("int_field4");'
        % generate_index_name('tests_testmodel', 'int_field4',
                              default=False)
    ),

"RemoveUniqueChangeModel": (
        'ALTER TABLE "tests_testmodel"'
        ' DROP CONSTRAINT tests_testmodel_int_field3_key;'
    ),

"MultiAttrChangeModel": '\n'.join([
        'ALTER TABLE "tests_testmodel"'
        ' ALTER COLUMN "char_field2" DROP NOT NULL;',

'ALTER TABLE "tests_testmodel"'
        ' RENAME COLUMN "custom_db_column" TO "custom_db_column2";',

'ALTER TABLE "tests_testmodel"'
        ' ALTER COLUMN "char_field" TYPE varchar(35)'
        ' USING CAST("char_field" as varchar(35));',
    ]),

"MultiAttrSingleFieldChangeModel": '\n'.join([
        'ALTER TABLE "tests_testmodel"'
        ' ALTER COLUMN "char_field2" TYPE varchar(35)'
        ' USING CAST("char_field2" as varchar(35)),'
        ' ALTER COLUMN "char_field2" DROP NOT NULL;',
    ]),

"RedundantAttrsChangeModel": '\n'.join([
        'ALTER TABLE "tests_testmodel"'
        ' ALTER COLUMN "char_field2" DROP NOT NULL;',

'ALTER TABLE "tests_testmodel"'
        ' RENAME COLUMN "custom_db_column" TO "custom_db_column3";',

'ALTER TABLE "tests_testmodel"'
        ' ALTER COLUMN "char_field" TYPE varchar(35)'
        ' USING CAST("char_field" as varchar(35));',
    ]),

"M2MDBTableChangeModel": '\n'.join([
        'ALTER TABLE "change_field_non-default_m2m_table"'
        ' DROP CONSTRAINT "%s";'
        % generate_constraint_name('testmodel_id', 'my_id',
                                   'change_field_non-default_m2m_table',
                                   'tests_testmodel'),

'ALTER TABLE "change_field_non-default_m2m_table"'
        ' RENAME TO "custom_m2m_db_table_name";',

'ALTER TABLE "custom_m2m_db_table_name"'
        ' ADD CONSTRAINT "%s" FOREIGN KEY ("testmodel_id")'
        ' REFERENCES "tests_testmodel" ("my_id")'
        ' DEFERRABLE INITIALLY DEFERRED;'
        % generate_constraint_name('testmodel_id', 'my_id',
                                   'custom_m2m_db_table_name',
                                   'tests_testmodel'),
    ]),
}

delete_model = {
    'BasicModel': (
        'DROP TABLE "tests_basicmodel";'
    ),

'BasicWithM2MModel': '\n'.join([
        'DROP TABLE "tests_basicwithm2mmodel_m2m";',
        'DROP TABLE "tests_basicwithm2mmodel";'
    ]),

'CustomTableModel': (
        'DROP TABLE "custom_table_name";'
    ),

'CustomTableWithM2MModel': '\n'.join([
        'DROP TABLE "another_custom_table_name_m2m";',
        'DROP TABLE "another_custom_table_name";'
    ]),
}

rename_model = {
    'RenameModel': (
        'ALTER TABLE "tests_testmodel" RENAME TO "tests_destmodel";'
    ),
    'RenameModelSameTable': '',
    'RenameModelForeignKeys': (
        'ALTER TABLE "tests_testmodel" RENAME TO "tests_destmodel";'
    ),
    'RenameModelForeignKeysSameTable': '',
    'RenameModelManyToManyField': (
        'ALTER TABLE "tests_testmodel" RENAME TO "tests_destmodel";'
    ),
    'RenameModelManyToManyFieldSameTable': '',
}

delete_application = {
    'DeleteApplication': '\n'.join([
        'DROP TABLE "tests_testmodel_anchor_m2m";',
        'DROP TABLE "tests_testmodel";',
        'DROP TABLE "tests_appdeleteanchor1";',
        'DROP TABLE "app_delete_custom_add_anchor_table";',
        'DROP TABLE "app_delete_custom_table_name";',
    ]),

'DeleteApplicationWithoutDatabase': "",
}

rename_field = {
    'RenameColumnModel': (
        'ALTER TABLE "tests_testmodel"'
        ' RENAME COLUMN "int_field" TO "renamed_field";'
    ),

'RenameColumnWithTableNameModel': (
        'ALTER TABLE "tests_testmodel"'
        ' RENAME COLUMN "int_field" TO "renamed_field";'
    ),

'RenameForeignKeyColumnModel': (
        'ALTER TABLE "tests_testmodel"'
        ' RENAME COLUMN "fk_field_id" TO "renamed_field_id";'
    ),

'RenameNonDefaultColumnNameModel': (
        'ALTER TABLE "tests_testmodel"'
        ' RENAME COLUMN "custom_db_col_name" TO "renamed_field";'
    ),

'RenameNonDefaultColumnNameToNonDefaultNameModel': (
        'ALTER TABLE "tests_testmodel"'
        ' RENAME COLUMN "custom_db_col_name" TO "non-default_column_name";'
    ),

'RenameNonDefaultColumnNameToNonDefaultNameAndTableModel': (
        'ALTER TABLE "tests_testmodel"'
        ' RENAME COLUMN "custom_db_col_name" TO "non-default_column_name2";'
    ),

'RenameColumnCustomTableModel': (
        'ALTER TABLE "custom_rename_table_name"'
        ' RENAME COLUMN "value" TO "renamed_field";'
    ),

'RenameNonDefaultManyToManyTableModel': '\n'.join([
        'ALTER TABLE "non-default_db_table"'
        ' DROP CONSTRAINT "%s";'
        % generate_constraint_name('testmodel_id', 'id',
                                   'non-default_db_table',
                                   'tests_testmodel'),

'ALTER TABLE "non-default_db_table"'
        ' RENAME TO "tests_testmodel_renamed_field";',

'ALTER TABLE "tests_testmodel_renamed_field"'
        ' ADD CONSTRAINT "%s" FOREIGN KEY ("testmodel_id")'
        ' REFERENCES "tests_testmodel" ("id")'
        ' DEFERRABLE INITIALLY DEFERRED;'
        % generate_constraint_name('testmodel_id', 'id',
                                   'tests_testmodel_renamed_field',
                                   'tests_testmodel'),
    ]),

'RenamePrimaryKeyColumnModel': '\n'.join([
        'ALTER TABLE "non-default_db_table"' ' DROP CONSTRAINT "%s";'
        % generate_constraint_name('testmodel_id', 'id',
                                   'non-default_db_table',
                                   'tests_testmodel'),

'ALTER TABLE "tests_testmodel_m2m_field" DROP CONSTRAINT "%s";'
        % generate_constraint_name('testmodel_id', 'id',
                                   'tests_testmodel_m2m_field',
                                   'tests_testmodel'),

'ALTER TABLE "tests_testmodel" RENAME COLUMN "id" TO "my_pk_id";',

'ALTER TABLE "non-default_db_table"'
        ' ADD CONSTRAINT "%s" FOREIGN KEY ("testmodel_id")'
        ' REFERENCES "tests_testmodel" ("my_pk_id")'
        ' DEFERRABLE INITIALLY DEFERRED;'
        % generate_constraint_name('testmodel_id', 'my_pk_id',
                                   'non-default_db_table',
                                   'tests_testmodel'),

'ALTER TABLE "tests_testmodel_m2m_field"'
        ' ADD CONSTRAINT "%s" FOREIGN KEY ("testmodel_id")'
        ' REFERENCES "tests_testmodel" ("my_pk_id")'
        ' DEFERRABLE INITIALLY DEFERRED;'
        % generate_constraint_name('testmodel_id', 'my_pk_id',
                                   'tests_testmodel_m2m_field',
                                   'tests_testmodel'),
    ]),

'RenameManyToManyTableModel': '\n'.join([
        'ALTER TABLE "tests_testmodel_m2m_field" DROP CONSTRAINT "%s";'
        % generate_constraint_name('testmodel_id', 'id',
                                   'tests_testmodel_m2m_field',
                                   'tests_testmodel'),

'ALTER TABLE "tests_testmodel_m2m_field"'
        ' RENAME TO "tests_testmodel_renamed_field";',

'RenameManyToManyTableWithColumnNameModel': '\n'.join([
        'ALTER TABLE "tests_testmodel_m2m_field" DROP CONSTRAINT "%s";'
        % generate_constraint_name('testmodel_id', 'id',
                                   'tests_testmodel_m2m_field',
                                   'tests_testmodel'),

'ALTER TABLE "tests_testmodel_m2m_field"'
        ' RENAME TO "tests_testmodel_renamed_field";',

sql_mutation = {
    'AddFirstTwoFields': '\n'.join([
        'ALTER TABLE "tests_testmodel"'
        ' ADD COLUMN "added_field1" integer NULL;',

'ALTER TABLE "tests_testmodel"'
        ' ADD COLUMN "added_field2" integer NULL;'
    ]),

'AddThirdField': (
        'ALTER TABLE "tests_testmodel"'
        ' ADD COLUMN "added_field3" integer NULL;'
    ),

'SQLMutationOutput': '\n'.join([
        'ALTER TABLE "tests_testmodel"'
        ' ADD COLUMN "added_field1" integer NULL;',

'ALTER TABLE "tests_testmodel"'
        ' ADD COLUMN "added_field2" integer NULL;',

'ALTER TABLE "tests_testmodel"'
        ' ADD COLUMN "added_field3" integer NULL;',
    ]),
}

generics = {
    'DeleteColumnModel': (
        'ALTER TABLE "tests_testmodel" DROP COLUMN "char_field" CASCADE;'
    ),
}

inheritance = {
    'AddToChildModel': '\n'.join([
        'ALTER TABLE "tests_childmodel"'
        ' ADD COLUMN "added_field" integer  DEFAULT 42;',

'ALTER TABLE "tests_childmodel"'
        ' ALTER COLUMN "added_field" DROP DEFAULT;',

'ALTER TABLE "tests_childmodel"'
        ' ALTER COLUMN "added_field" SET NOT NULL;',
    ]),

'DeleteFromChildModel': (
        'ALTER TABLE "tests_childmodel" DROP COLUMN "int_field" CASCADE;'
    ),
}

unique_together = {
    'setting_from_empty': (
        'CREATE UNIQUE INDEX %s'
        ' ON tests_testmodel ("int_field1", "char_field1");'
        % generate_index_name('tests_testmodel',
                              ['int_field1', 'char_field1'],
                              default=False)
    ),

'replace_list': '\n'.join([
        'ALTER TABLE "tests_testmodel"'
        ' DROP CONSTRAINT tests_testmodel_int_field1_char_field1_key;',

'CREATE UNIQUE INDEX %s'
        ' ON tests_testmodel ("int_field2", "char_field2");'
        % generate_index_name('tests_testmodel',
                              ['int_field2', 'char_field2'],
                              default=False),
    ]),

'append_list': (
        'CREATE UNIQUE INDEX %s'
        ' ON tests_testmodel ("int_field2", "char_field2");'
        % generate_index_name('tests_testmodel',
                              ['int_field2', 'char_field2'],
                              default=False)
    ),

'removing': (
        'ALTER TABLE "tests_testmodel"'
        ' DROP CONSTRAINT tests_testmodel_int_field1_char_field1_key;'
    ),

'set_remove': (
        'CREATE UNIQUE INDEX %s'
        ' ON tests_testmodel ("int_field1", "char_field1");'
        % generate_index_name('tests_testmodel',
                              ['int_field1', 'char_field1'],
                              default=False)
    ),

'ignore_missing_indexes': (
        'CREATE UNIQUE INDEX %s'
        ' ON tests_testmodel ("char_field1", "char_field2");'
        % generate_index_name('tests_testmodel',
                              ['char_field1', 'char_field2'],
                              default=False)
    ),

'upgrade_from_v1_sig': (
        'CREATE UNIQUE INDEX %s'
        ' ON tests_testmodel ("int_field1", "char_field1");'
        % generate_index_name('tests_testmodel',
                              ['int_field1', 'char_field1'],
                              default=False)
    ),
}

index_together = {
    'setting_from_empty': '\n'.join([
        'CREATE INDEX "%s"'
        ' ON "tests_testmodel" ("int_field1", "char_field1");'
        % generate_index_name('tests_testmodel', ['int_field1', 'char_field1'])
    ]),

'replace_list': '\n'.join([
        'DROP INDEX "%s";'
        % generate_index_name('tests_testmodel',
                              ['int_field1', 'char_field1']),

'CREATE INDEX "%s"'
        ' ON "tests_testmodel" ("int_field2", "char_field2");'
        % generate_index_name('tests_testmodel',
                              ['int_field2', 'char_field2']),
    ]),

'append_list': '\n'.join([
        'CREATE INDEX "%s"'
        ' ON "tests_testmodel" ("int_field2", "char_field2");'
        % generate_index_name('tests_testmodel',
                              ['int_field2', 'char_field2']),
    ]),

'removing': '\n'.join([
        'DROP INDEX "%s";'
        % generate_index_name('tests_testmodel',
                              ['int_field1', 'char_field1']),
    ]),

'ignore_missing_indexes': (
        'CREATE INDEX "%s"'
        ' ON "tests_testmodel" ("char_field1", "char_field2");'
        % generate_index_name('tests_testmodel',
                              ['char_field1', 'char_field2'])
    ),
}

preprocessing = {
    'add_change_field': '\n'.join([
        'ALTER TABLE "tests_testmodel"'
        ' ADD COLUMN "added_field" varchar(50) NULL DEFAULT \'bar\';',

'ALTER TABLE "tests_testmodel"'
        ' ALTER COLUMN "added_field" DROP DEFAULT;',
    ]),

'add_change_rename_field': '\n'.join([
        'ALTER TABLE "tests_testmodel"'
        ' ADD COLUMN "renamed_field" varchar(50) NULL DEFAULT \'bar\';',

'ALTER TABLE "tests_testmodel"'
        ' ALTER COLUMN "renamed_field" DROP DEFAULT;',
    ]),

'add_delete_add_field': '\n'.join([
        'ALTER TABLE "tests_testmodel"'
        ' ADD COLUMN "added_field" integer NOT NULL DEFAULT 42;',

'ALTER TABLE "tests_testmodel"'
        ' ALTER COLUMN "added_field" DROP DEFAULT;',
    ]),

'add_delete_add_rename_field': '\n'.join([
        'ALTER TABLE "tests_testmodel"'
        ' ADD COLUMN "renamed_field" integer NOT NULL DEFAULT 42;',

'ALTER TABLE "tests_testmodel"'
        ' ALTER COLUMN "renamed_field" DROP DEFAULT;',
    ]),

'add_rename_change_field': '\n'.join([
        'ALTER TABLE "tests_testmodel"'
        ' ADD COLUMN "renamed_field" varchar(50) NULL DEFAULT \'bar\';',

'ALTER TABLE "tests_testmodel"'
        ' ALTER COLUMN "renamed_field" DROP DEFAULT;',
    ]),

'add_rename_change_rename_change_field': '\n'.join([
        'ALTER TABLE "tests_testmodel"'
        ' ADD COLUMN "renamed_field" varchar(50) NULL DEFAULT \'foo\';',

'ALTER TABLE "tests_testmodel"'
        ' ALTER COLUMN "renamed_field" DROP DEFAULT;',
    ]),

'add_rename_field_with_db_column': (
        'ALTER TABLE "tests_testmodel"'
        ' ADD COLUMN "added_field" varchar(50) NULL;'
    ),

'add_field_rename_model': '\n'.join([
        'ALTER TABLE "tests_testmodel"'
        ' ADD COLUMN "added_field_id" integer NULL REFERENCES'
        ' "tests_reffedpreprocmodel" ("id")  DEFERRABLE INITIALLY DEFERRED;',

'CREATE INDEX "tests_testmodel_added_field_id"'
        ' ON "tests_testmodel" ("added_field_id");'
    ]),

'add_rename_field_rename_model': '\n'.join([
        'ALTER TABLE "tests_testmodel"'
        ' ADD COLUMN "renamed_field_id" integer NULL REFERENCES'
        ' "tests_reffedpreprocmodel" ("id")  DEFERRABLE INITIALLY DEFERRED;',

'CREATE INDEX "tests_testmodel_renamed_field_id"'
        ' ON "tests_testmodel" ("renamed_field_id");'
    ]),

'add_sql_delete': '\n'.join([
        'ALTER TABLE "tests_testmodel"'
        ' ADD COLUMN "added_field" varchar(20) NOT NULL DEFAULT \'foo\';',

'ALTER TABLE "tests_testmodel"'
        ' ALTER COLUMN "added_field" DROP DEFAULT;',

'-- Comment --',

'ALTER TABLE "tests_testmodel" DROP COLUMN "added_field" CASCADE;',
    ]),

'change_rename_field': '\n'.join([
        'ALTER TABLE "tests_testmodel"'
        ' ALTER COLUMN "char_field" DROP NOT NULL;',

'ALTER TABLE "tests_testmodel"'
        ' RENAME COLUMN "char_field" TO "renamed_field";',
    ]),

'change_rename_change_rename_field': '\n'.join([
        'ALTER TABLE "tests_testmodel"'
        ' ALTER COLUMN "char_field" TYPE varchar(30)'
        ' USING CAST("char_field" as varchar(30)),'
        ' ALTER COLUMN "char_field" DROP NOT NULL;',

'ALTER TABLE "tests_testmodel"'
        ' RENAME COLUMN "char_field" TO "renamed_field";',
    ]),

'delete_char_field': (
        'ALTER TABLE "tests_testmodel" DROP COLUMN "char_field" CASCADE;'
    ),

'rename_add_field': '\n'.join([
        'ALTER TABLE "tests_testmodel"'
        ' RENAME COLUMN "char_field" TO "renamed_field";',

'ALTER TABLE "tests_testmodel"'
        ' ADD COLUMN "char_field" varchar(50) NULL;',
    ]),

'rename_change_rename_change_field': '\n'.join([
        'ALTER TABLE "tests_testmodel"'
        ' RENAME COLUMN "char_field" TO "renamed_field";',

'ALTER TABLE "tests_testmodel"'
        ' ALTER COLUMN "renamed_field" TYPE varchar(50)'
        ' USING CAST("renamed_field" as varchar(50)),'
        ' ALTER COLUMN "renamed_field" DROP NOT NULL;',
    ]),

'rename_rename_field': '\n'.join([
        'ALTER TABLE "tests_testmodel"'
        ' RENAME COLUMN "char_field" TO "renamed_field";',
    ]),

'rename_delete_model': (
        'DROP TABLE "tests_testmodel";'
    ),

'noop': '',
}