Python Migration Beispiele

Beispiel #1

from dmigrations.mysql import migrations as m

migration = m.Migration(sql_up="INSERT INTO mock VALUES (9, 2)", sql_down="")

Beispiel #2

Datei: 001_django_contrib_admin_models.py Projekt: Hitoki/ieee

from dmigrations.mysql import migrations as m
import datetime
migration = m.Migration(sql_up=[
    """
    CREATE TABLE `django_admin_log` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `action_time` datetime NOT NULL,
        `user_id` integer NOT NULL,
        `content_type_id` integer NULL,
        `object_id` longtext NULL,
        `object_repr` varchar(200) NOT NULL,
        `action_flag` smallint UNSIGNED NOT NULL,
        `change_message` longtext NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    -- The following references should be added but depend on non-existent tables:
""", """
    -- ALTER TABLE `django_admin_log` ADD CONSTRAINT user_id_refs_id_c8665aa FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`);
""", """
    -- ALTER TABLE `django_admin_log` ADD CONSTRAINT content_type_id_refs_id_288599e6 FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`);
"""
],
                        sql_down=["""
    DROP TABLE `django_admin_log`;
"""])

Beispiel #3

Datei: 003_django_contrib_contenttypes_models.py Projekt: Hitoki/ieee

from dmigrations.mysql import migrations as m
import datetime
migration = m.Migration(
    sql_up=[
        """
    CREATE TABLE `django_content_type` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `name` varchar(100) NOT NULL,
        `app_label` varchar(100) NOT NULL,
        `model` varchar(100) NOT NULL,
        UNIQUE (`app_label`, `model`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
"""
    ],
    sql_down=["""
    DROP TABLE `django_content_type`;
"""])

Beispiel #4

Datei: 002_django_contrib_auth_models.py Projekt: Hitoki/ieee

migration = m.Migration(sql_up=["""
    CREATE TABLE `auth_permission` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `name` varchar(50) NOT NULL,
        `content_type_id` integer NOT NULL,
        `codename` varchar(100) NOT NULL,
        UNIQUE (`content_type_id`, `codename`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    CREATE TABLE `auth_group` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `name` varchar(80) NOT NULL UNIQUE
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    CREATE TABLE `auth_user` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `username` varchar(30) NOT NULL UNIQUE,
        `first_name` varchar(30) NOT NULL,
        `last_name` varchar(30) NOT NULL,
        `email` varchar(75) NOT NULL,
        `password` varchar(128) NOT NULL,
        `is_staff` bool NOT NULL,
        `is_active` bool NOT NULL,
        `is_superuser` bool NOT NULL,
        `last_login` datetime NOT NULL,
        `date_joined` datetime NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    CREATE TABLE `auth_message` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `user_id` integer NOT NULL,
        `message` longtext NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    ALTER TABLE `auth_message` ADD CONSTRAINT user_id_refs_id_650f49a6 FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`);
""", """
    CREATE TABLE `auth_group_permissions` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `group_id` integer NOT NULL,
        `permission_id` integer NOT NULL,
        UNIQUE (`group_id`, `permission_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    ALTER TABLE `auth_group_permissions` ADD CONSTRAINT group_id_refs_id_3cea63fe FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`);
""", """
    ALTER TABLE `auth_group_permissions` ADD CONSTRAINT permission_id_refs_id_5886d21f FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`);
""", """
    CREATE TABLE `auth_user_groups` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `user_id` integer NOT NULL,
        `group_id` integer NOT NULL,
        UNIQUE (`user_id`, `group_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    ALTER TABLE `auth_user_groups` ADD CONSTRAINT user_id_refs_id_7ceef80f FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`);
""", """
    ALTER TABLE `auth_user_groups` ADD CONSTRAINT group_id_refs_id_f116770 FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`);
""", """
    CREATE TABLE `auth_user_user_permissions` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `user_id` integer NOT NULL,
        `permission_id` integer NOT NULL,
        UNIQUE (`user_id`, `permission_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    ALTER TABLE `auth_user_user_permissions` ADD CONSTRAINT user_id_refs_id_dfbab7d FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`);
""", """
    ALTER TABLE `auth_user_user_permissions` ADD CONSTRAINT permission_id_refs_id_67e79cb FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`);
""", """
    -- The following references should be added but depend on non-existent tables:
""", """
    -- ALTER TABLE `auth_permission` ADD CONSTRAINT content_type_id_refs_id_728de91f FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`);
"""], sql_down=["""
    DROP TABLE `auth_user_user_permissions`;
""", """
    DROP TABLE `auth_user_groups`;
""", """
    DROP TABLE `auth_group_permissions`;
""", """
    DROP TABLE `auth_message`;
""", """
    DROP TABLE `auth_user`;
""", """
    DROP TABLE `auth_group`;
""", """
    DROP TABLE `auth_permission`;
"""])

Beispiel #5

from dmigrations.mysql import migrations as m
import datetime
migration = m.Migration(sql_up=[
    """
    CREATE TABLE `blog_category` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `name` varchar(255) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    CREATE TABLE `blog_category_entries` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `category_id` integer NOT NULL,
        `entry_id` integer NOT NULL,
        UNIQUE (`category_id`, `entry_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    ALTER TABLE `blog_category_entries` ADD CONSTRAINT category_id_refs_id_8bfa9be FOREIGN KEY (`category_id`) REFERENCES `blog_category` (`id`);
""", """
    ALTER TABLE `blog_category_entries` ADD CONSTRAINT entry_id_refs_id_df19365 FOREIGN KEY (`entry_id`) REFERENCES `blog_entry` (`id`);
"""
],
                        sql_down=[
                            """
    DROP TABLE `blog_category_entries`;
""", """
    DROP TABLE `blog_category`;
"""
                        ])

Beispiel #6

Datei: 012_ieeetags_models.py Projekt: Hitoki/ieee

from dmigrations.mysql import migrations as m
import datetime
migration = m.Migration(
    sql_up=[
        """
    CREATE TABLE `ieeetags_failedloginlog` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `username` varchar(30) NOT NULL,
        `ip` varchar(16) NOT NULL,
        `disabled` bool NOT NULL,
        `date_created` datetime NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
"""
    ],
    sql_down=["""
    DROP TABLE `ieeetags_failedloginlog`;
"""])

Beispiel #7

Datei: 006_dmigrations_models.py Projekt: Hitoki/ieee

from dmigrations.mysql import migrations as m
import datetime
migration = m.Migration(sql_up=[], sql_down=[])

Beispiel #8

from dmigrations.mysql import migrations as m
import datetime
migration = m.Migration(sql_up=["""
    CREATE TABLE `blog_entry` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `title` varchar(255) NOT NULL,
        `body` longtext NOT NULL,
        `created` datetime NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
"""], sql_down=["""
    DROP TABLE `blog_entry`;
"""])

Beispiel #9

Datei: 019_ieeetags_models.py Projekt: Hitoki/ieee

from dmigrations.mysql import migrations as m
import datetime
migration = m.Migration(
    sql_up=[
        """
    CREATE TABLE `ieeetags_urlcheckerlog` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `date_started` datetime NOT NULL,
        `date_ended` datetime,
        `date_updated` datetime NOT NULL,
        `status` varchar(1000) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
"""
    ],
    sql_down=["""
    DROP TABLE `ieeetags_urlcheckerlog`;
"""])

Beispiel #10

from dmigrations.mysql import migrations as m
import datetime
migration = m.Migration(sql_up=[
    """
    CREATE TABLE `django_session` (
        `session_key` varchar(40) NOT NULL PRIMARY KEY,
        `session_data` longtext NOT NULL,
        `expire_date` datetime NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
"""
],
                        sql_down=["""
    DROP TABLE `django_session`;
"""])

Beispiel #11

Datei: 007_ieeetags_models.py Projekt: Hitoki/ieee

migration = m.Migration(sql_up=[
    """
    CREATE TABLE `ieeetags_nodetype` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `name` varchar(50) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    CREATE TABLE `ieeetags_node` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `name` varchar(500) NOT NULL,
        `node_type_id` integer NOT NULL,
        `num_related_tags` integer NULL,
        `num_resources` integer NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    ALTER TABLE `ieeetags_node` ADD CONSTRAINT node_type_id_refs_id_652d089 FOREIGN KEY (`node_type_id`) REFERENCES `ieeetags_nodetype` (`id`);
""", """
    CREATE TABLE `ieeetags_society` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `name` varchar(500) NOT NULL,
        `abbreviation` varchar(20) NOT NULL,
        `url` varchar(1000) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    CREATE TABLE `ieeetags_resourcetype` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `name` varchar(50) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    CREATE TABLE `ieeetags_resource` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `resource_type_id` integer NOT NULL,
        `ieee_id` varchar(500) NULL,
        `name` varchar(500) NOT NULL,
        `description` varchar(5000) NOT NULL,
        `url` varchar(1000) NOT NULL,
        `year` integer NULL,
        `standard_status` varchar(100) NOT NULL,
        `priority_to_tag` bool NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    ALTER TABLE `ieeetags_resource` ADD CONSTRAINT resource_type_id_refs_id_21a19251 FOREIGN KEY (`resource_type_id`) REFERENCES `ieeetags_resourcetype` (`id`);
""", """
    CREATE TABLE `ieeetags_filter` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `name` varchar(50) NOT NULL,
        `value` varchar(500) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    CREATE TABLE `ieeetags_permission` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `user_id` integer NOT NULL,
        `object_type_id` integer NOT NULL,
        `object_id` integer UNSIGNED NOT NULL,
        `permission_type` varchar(1000) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    CREATE TABLE `ieeetags_profile` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `user_id` integer NOT NULL UNIQUE,
        `role` varchar(1000) NOT NULL,
        `reset_key` varchar(1000) NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    CREATE TABLE `ieeetags_node_parents` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `from_node_id` integer NOT NULL,
        `to_node_id` integer NOT NULL,
        UNIQUE (`from_node_id`, `to_node_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    ALTER TABLE `ieeetags_node_parents` ADD CONSTRAINT from_node_id_refs_id_304469d3 FOREIGN KEY (`from_node_id`) REFERENCES `ieeetags_node` (`id`);
""", """
    ALTER TABLE `ieeetags_node_parents` ADD CONSTRAINT to_node_id_refs_id_304469d3 FOREIGN KEY (`to_node_id`) REFERENCES `ieeetags_node` (`id`);
""", """
    CREATE TABLE `ieeetags_node_societies` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `node_id` integer NOT NULL,
        `society_id` integer NOT NULL,
        UNIQUE (`node_id`, `society_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    ALTER TABLE `ieeetags_node_societies` ADD CONSTRAINT node_id_refs_id_151b8f74 FOREIGN KEY (`node_id`) REFERENCES `ieeetags_node` (`id`);
""", """
    ALTER TABLE `ieeetags_node_societies` ADD CONSTRAINT society_id_refs_id_4283f3d1 FOREIGN KEY (`society_id`) REFERENCES `ieeetags_society` (`id`);
""", """
    CREATE TABLE `ieeetags_node_filters` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `node_id` integer NOT NULL,
        `filter_id` integer NOT NULL,
        UNIQUE (`node_id`, `filter_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    ALTER TABLE `ieeetags_node_filters` ADD CONSTRAINT node_id_refs_id_2d5d995f FOREIGN KEY (`node_id`) REFERENCES `ieeetags_node` (`id`);
""", """
    ALTER TABLE `ieeetags_node_filters` ADD CONSTRAINT filter_id_refs_id_1340c915 FOREIGN KEY (`filter_id`) REFERENCES `ieeetags_filter` (`id`);
""", """
    CREATE TABLE `ieeetags_node_related_tags` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `from_node_id` integer NOT NULL,
        `to_node_id` integer NOT NULL,
        UNIQUE (`from_node_id`, `to_node_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    ALTER TABLE `ieeetags_node_related_tags` ADD CONSTRAINT from_node_id_refs_id_3cec9c56 FOREIGN KEY (`from_node_id`) REFERENCES `ieeetags_node` (`id`);
""", """
    ALTER TABLE `ieeetags_node_related_tags` ADD CONSTRAINT to_node_id_refs_id_3cec9c56 FOREIGN KEY (`to_node_id`) REFERENCES `ieeetags_node` (`id`);
""", """
    CREATE TABLE `ieeetags_society_users` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `society_id` integer NOT NULL,
        `user_id` integer NOT NULL,
        UNIQUE (`society_id`, `user_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    ALTER TABLE `ieeetags_society_users` ADD CONSTRAINT society_id_refs_id_e1d6f1c FOREIGN KEY (`society_id`) REFERENCES `ieeetags_society` (`id`);
""", """
    ALTER TABLE `ieeetags_society_users` ADD CONSTRAINT user_id_refs_id_69d6ab23 FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`);
""", """
    CREATE TABLE `ieeetags_resource_nodes` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `resource_id` integer NOT NULL,
        `node_id` integer NOT NULL,
        UNIQUE (`resource_id`, `node_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    ALTER TABLE `ieeetags_resource_nodes` ADD CONSTRAINT resource_id_refs_id_3c53589 FOREIGN KEY (`resource_id`) REFERENCES `ieeetags_resource` (`id`);
""", """
    ALTER TABLE `ieeetags_resource_nodes` ADD CONSTRAINT node_id_refs_id_4d52045f FOREIGN KEY (`node_id`) REFERENCES `ieeetags_node` (`id`);
""", """
    CREATE TABLE `ieeetags_resource_societies` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `resource_id` integer NOT NULL,
        `society_id` integer NOT NULL,
        UNIQUE (`resource_id`, `society_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
""", """
    ALTER TABLE `ieeetags_resource_societies` ADD CONSTRAINT resource_id_refs_id_2e9a7be4 FOREIGN KEY (`resource_id`) REFERENCES `ieeetags_resource` (`id`);
""", """
    ALTER TABLE `ieeetags_resource_societies` ADD CONSTRAINT society_id_refs_id_5593f5d1 FOREIGN KEY (`society_id`) REFERENCES `ieeetags_society` (`id`);
""", """
    -- The following references should be added but depend on non-existent tables:
""", """
    -- ALTER TABLE `ieeetags_permission` ADD CONSTRAINT user_id_refs_id_51c9aa44 FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`);
""", """
    -- ALTER TABLE `ieeetags_profile` ADD CONSTRAINT user_id_refs_id_5285cb49 FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`);
""", """
    -- ALTER TABLE `ieeetags_permission` ADD CONSTRAINT object_type_id_refs_id_618b7840 FOREIGN KEY (`object_type_id`) REFERENCES `django_content_type` (`id`);
"""
],
                        sql_down=[
                            """
    DROP TABLE `ieeetags_resource_societies`;
""", """
    DROP TABLE `ieeetags_resource_nodes`;
""", """
    DROP TABLE `ieeetags_society_users`;
""", """
    DROP TABLE `ieeetags_node_related_tags`;
""", """
    DROP TABLE `ieeetags_node_filters`;
""", """
    DROP TABLE `ieeetags_node_societies`;
""", """
    DROP TABLE `ieeetags_node_parents`;
""", """
    DROP TABLE `ieeetags_profile`;
""", """
    DROP TABLE `ieeetags_permission`;
""", """
    DROP TABLE `ieeetags_filter`;
""", """
    DROP TABLE `ieeetags_resource`;
""", """
    DROP TABLE `ieeetags_resourcetype`;
""", """
    DROP TABLE `ieeetags_society`;
""", """
    DROP TABLE `ieeetags_node`;
""", """
    DROP TABLE `ieeetags_nodetype`;
"""
                        ])

Beispiel #12

from dmigrations.mysql import migrations as m

migration = m.Migration(sql_up="INSERT INTO mock VALUES (1)",
                        sql_down="DELETE FROM mock WHERE id=1")

Beispiel #13

Datei: 005_django_contrib_sites_models.py Projekt: Hitoki/ieee

from dmigrations.mysql import migrations as m
import datetime

migration = m.Migration(sql_up=[
    """
    CREATE TABLE `django_site` (
        `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
        `domain` varchar(100) NOT NULL,
        `name` varchar(50) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    ;
"""
],
                        sql_down=["""
    DROP TABLE `django_site`;
"""])