def backwards(self, orm): db.drop_primary_key("cmsplugin_snippetptrpublic") db.rename_column("cmsplugin_snippetptrpublic", "cmspluginpublic_ptr_id", "publiccmsplugin_ptr_id") db.create_primary_key("cmsplugin_snippetptrpublic", ("publiccmsplugin_ptr_id",)) db.rename_table("cmsplugin_snippetptr", "snippet_snippetptr") db.rename_table("cmsplugin_snippetptrpublic", "snippet_publicsnippetptr") db.alter_column('cmsplugin_snippetptr', 'public_id', orm['snippet.snippetptr:public'])
def forwards(self, orm): db.rename_table("text_text", "cmsplugin_text") db.rename_table("text_publictext", "cmsplugin_textpublic") db.alter_column('cmsplugin_text', 'public_id', orm['text.text:public']) db.drop_primary_key("cmsplugin_textpublic") db.rename_column("cmsplugin_textpublic", "publiccmsplugin_ptr_id", "cmspluginpublic_ptr_id") db.create_primary_key("cmsplugin_textpublic", ("cmspluginpublic_ptr_id",))
def backwards(self, orm): db.drop_primary_key("cmsplugin_googlemappublic") db.rename_column("cmsplugin_googlemappublic", "cmspluginpublic_ptr_id", "publiccmsplugin_ptr_id") db.create_primary_key("cmsplugin_googlemappublic", ("publiccmsplugin_ptr_id",)) db.rename_table("cmsplugin_googlemap", "googlemap_googlemap") db.rename_table("cmsplugin_googlemappublic", "googlemap_publicgooglemap") db.alter_column('cmsplugin_googlemap', 'public_id', orm['googlemap.googlemap:public'])
def backwards(self, orm): db.drop_primary_key("cmsplugin_flashpublic") db.rename_column("cmsplugin_flashpublic", "cmspluginpublic_ptr_id", "publiccmsplugin_ptr_id") db.create_primary_key("cmsplugin_flashpublic", ("publiccmsplugin_ptr_id",)) db.rename_table("cmsplugin_flash", "flash_flash") db.rename_table("cmsplugin_flashpublic", "flash_publicflash") db.alter_column('cmsplugin_flash', 'public_id', orm['flash.flash:public'])
def backwards(self, orm): db.drop_primary_key("cmsplugin_filepublic") db.rename_column("cmsplugin_filepublic", "cmspluginpublic_ptr_id", "publiccmsplugin_ptr_id") db.create_primary_key("cmsplugin_filepublic", ("publiccmsplugin_ptr_id",)) db.rename_table("cmsplugin_file", "file_file") db.rename_table("cmsplugin_filepublic", "file_publicfile") db.alter_column('cmsplugin_file', 'public_id', orm['file.file:public'])
def test_primary_key(self): """ Test the primary key operations """ # SQLite backend doesn't support this yet. if db.backend_name == "sqlite3": return db.create_table( "test_pk", [ ("id", models.IntegerField(primary_key=True)), ("new_pkey", models.IntegerField()), ("eggs", models.IntegerField(unique=True)), ], ) db.execute_deferred_sql() # Remove the default primary key, and make eggs it db.drop_primary_key("test_pk") db.create_primary_key("test_pk", "new_pkey") # Try inserting a now-valid row pair db.execute("INSERT INTO test_pk (id, new_pkey, eggs) VALUES (1, 2, 3)") db.execute("INSERT INTO test_pk (id, new_pkey, eggs) VALUES (1, 3, 4)") db.delete_table("test_pk")
def backwards(self, orm): db.drop_primary_key("cmsplugin_linkpublic") db.rename_column("cmsplugin_linkpublic", "cmspluginpublic_ptr_id", "publiccmsplugin_ptr_id") db.create_primary_key("cmsplugin_linkpublic", ("publiccmsplugin_ptr_id",)) db.rename_table("cmsplugin_link", "link_link") db.rename_table("cmsplugin_linkpublic", "link_publiclink") db.alter_column('cmsplugin_link', 'public_id', orm['link.link:public'])
def backwards(self, orm): db.drop_primary_key("cmsplugin_picturepublic") db.rename_column("cmsplugin_picturepublic", "cmspluginpublic_ptr_id", "publiccmsplugin_ptr_id") db.create_primary_key("cmsplugin_picturepublic", ("publiccmsplugin_ptr_id",)) db.rename_table("cmsplugin_picture", "picture_picture") db.rename_table("cmsplugin_picturepublic", "picture_publicpicture") db.alter_column('cmsplugin_picture', 'public_id', orm['picture.picture:public'])
def backwards(self, orm): db.delete_foreign_key('cmsplugin_googlemap' ,'public_id') db.drop_primary_key("cmsplugin_googlemappublic") db.rename_column("cmsplugin_googlemappublic", "cmspluginpublic_ptr_id", "publiccmsplugin_ptr_id") db.create_primary_key("cmsplugin_googlemappublic", ("publiccmsplugin_ptr_id",)) db.rename_table("cmsplugin_googlemap", "googlemap_googlemap") db.rename_table("cmsplugin_googlemappublic", "googlemap_publicgooglemap") db.alter_column('googlemap_googlemap', 'public_id', orm['googlemap.googlemap:public'])
def forwards(self, orm): db.create_index('cg_channel_featured_email', ['channel_id']) db.drop_primary_key('cg_channel_featured_email') # Adding field 'FeaturedEmail.id' db.add_column('cg_channel_featured_email', 'id', orm['featured.featuredemail:id'])
def forwards(self, orm): db.create_index('cg_channel_rating', ['user_id']) db.create_index('cg_channel_rating', ['channel_id']) db.drop_primary_key('cg_channel_rating') # Adding field 'Rating.id' db.add_column('cg_channel_rating', 'id', orm['ratings.rating:id'])
def forwards(self, orm): db.create_index('cg_channel_added', ['channel_id']) db.create_index('cg_channel_added', ['user_id']) db.drop_primary_key('cg_channel_added') # Adding field 'AddedChannel.id' db.add_column('cg_channel_added', 'id', orm['channels.addedchannel:id'])
def backwards(self, orm): db.delete_foreign_key('cmsplugin_link', 'public_id') db.drop_primary_key("cmsplugin_linkpublic") db.rename_column("cmsplugin_linkpublic", "cmspluginpublic_ptr_id", "publiccmsplugin_ptr_id") db.create_primary_key("cmsplugin_linkpublic", ("publiccmsplugin_ptr_id", )) db.rename_table("cmsplugin_link", "link_link") db.rename_table("cmsplugin_linkpublic", "link_publiclink") db.alter_column('link_link', 'public_id', orm['link.link:public'])
def backwards(self, orm): db.delete_foreign_key('cmsplugin_text' ,'public_id') db.drop_primary_key("cmsplugin_textpublic") db.rename_column("cmsplugin_textpublic", "cmspluginpublic_ptr_id", "publiccmsplugin_ptr_id") db.create_primary_key("cmsplugin_textpublic", ("publiccmsplugin_ptr_id",)) db.foreign_key_sql('cmsplugin_text' ,'public_id', 'cmsplugin_textpublic', "publiccmsplugin_ptr_id") db.rename_table("cmsplugin_text", "text_text") db.rename_table("cmsplugin_textpublic", "text_publictext") db.alter_column('cmsplugin_text', 'public_id', orm['text.text:public'])
def backwards(self, orm): try: db.delete_foreign_key('cmsplugin_flash' ,'public_id') except: pass db.drop_primary_key("cmsplugin_flashpublic") db.rename_column("cmsplugin_flashpublic", "cmspluginpublic_ptr_id", "publiccmsplugin_ptr_id") db.create_primary_key("cmsplugin_flashpublic", ("publiccmsplugin_ptr_id",)) db.rename_table("cmsplugin_flash", "flash_flash") db.rename_table("cmsplugin_flashpublic", "flash_publicflash") db.alter_column('flash_flash', 'public_id', orm['flash.flash:public'])
def backwards(self, orm): try: db.delete_foreign_key("cmsplugin_file", "public_id") except: pass db.drop_primary_key("cmsplugin_filepublic") db.rename_column("cmsplugin_filepublic", "cmspluginpublic_ptr_id", "publiccmsplugin_ptr_id") db.create_primary_key("cmsplugin_filepublic", ("publiccmsplugin_ptr_id",)) db.rename_table("cmsplugin_file", "file_file") db.rename_table("cmsplugin_filepublic", "file_publicfile") db.alter_column("file_file", "public_id", orm["file.file:public"])
def backwards(self, orm): db.delete_foreign_key('cmsplugin_snippetptr', 'public_id') db.drop_primary_key("cmsplugin_snippetptrpublic") db.rename_column("cmsplugin_snippetptrpublic", "cmspluginpublic_ptr_id", "publiccmsplugin_ptr_id") db.create_primary_key("cmsplugin_snippetptrpublic", ("publiccmsplugin_ptr_id", )) db.rename_table("cmsplugin_snippetptr", "snippet_snippetptr") db.rename_table("cmsplugin_snippetptrpublic", "snippet_publicsnippetptr") db.alter_column('snippet_snippetptr', 'public_id', orm['snippet.snippetptr:public'])
def forwards(self, orm): db.rename_table("text_text", "cmsplugin_text") db.rename_table("text_publictext", "cmsplugin_textpublic") db.rename_column("cmsplugin_textpublic", "publiccmsplugin_ptr_id", "cmspluginpublic_ptr_id") db.alter_column("cmsplugin_text", "public_id", orm["text.text:public"]) try: db.delete_foreign_key("cmsplugin_text", "public_id") except: pass db.drop_primary_key("cmsplugin_textpublic") db.create_primary_key("cmsplugin_textpublic", ("cmspluginpublic_ptr_id",)) db.foreign_key_sql("cmsplugin_text", "public_id", "cmsplugin_textpublic", "cmspluginpublic_ptr_id")
def forwards_publishable(self, orm): ''' creation of publishable objects TODO: sync publish_from ''' # move the data db.execute(''' INSERT INTO `core_publishable` (old_id, content_type_id, %(cols_to)s) SELECT a.id, ct.id, %(cols_from)s FROM `%(table)s` a, `django_content_type` ct WHERE ct.`app_label` = '%(app_label)s' AND ct.`model` = '%(model)s'; ''' % self.substitute ) # add link to parent db.add_column(self.table, 'publishable_ptr', models.IntegerField(null=True, blank=True)) # update the link db.execute(''' UPDATE `core_publishable` pub JOIN `%(table)s` art ON (art.`id` = pub.`old_id`) JOIN `django_content_type` ct ON (pub.`content_type_id` = ct.`id` AND ct.`app_label` = '%(app_label)s' AND ct.`model` = '%(model)s') SET art.`publishable_ptr` = pub.`id`; ''' % self.substitute ) # remove constraints from all models reffering to us self.alter_self_foreignkeys(orm) # drop primary key db.alter_column(self.table, 'id', models.IntegerField()) db.drop_primary_key(self.table) # replace it with a link to parent db.rename_column(self.table, 'publishable_ptr', 'publishable_ptr_id') db.alter_column(self.table, 'publishable_ptr_id', models.OneToOneField(orm['core.Publishable'], null=False, blank=False)) # move data, that were pointing to us self.move_self_foreignkeys(orm) # drop duplicate columns db.delete_column(self.table, 'id') for column in self.cols_from: db.delete_column(self.table, column)
def forwards(self, orm): db.rename_table("file_file", "cmsplugin_file") db.rename_table("file_publicfile", "cmsplugin_filepublic") db.alter_column('cmsplugin_file', 'public_id', orm['file.file:public']) try: db.delete_foreign_key('cmsplugin_file' ,'public_id') except: pass db.drop_primary_key("cmsplugin_filepublic") db.rename_column("cmsplugin_filepublic", "publiccmsplugin_ptr_id", "cmspluginpublic_ptr_id") db.create_primary_key("cmsplugin_filepublic", ("cmspluginpublic_ptr_id",)) db.foreign_key_sql('cmsplugin_file' ,'public_id', 'cmsplugin_filepublic', 'cmspluginpublic_ptr_id')
def forwards(self, orm): # we have to drop primary key, but it can't be AutoField db.alter_column("sample_spam", "id", models.IntegerField()) db.drop_primary_key("sample_spam") # Deleting field 'Spam.id' # TODO: # but we need to find any of our children # because they contain constraint to us db.delete_column("sample_spam", "id") # Adding field 'Spam.id' db.add_column("sample_spam", "id", models.AutoField(primary_key=True))
def forwards(self, orm): db.rename_table("snippet_snippetptr", "cmsplugin_snippetptr") db.rename_table("snippet_publicsnippetptr", "cmsplugin_snippetptrpublic") db.alter_column('cmsplugin_snippetptr', 'public_id', orm['snippet.snippetptr:public']) try: db.delete_foreign_key('cmsplugin_snippetptr' ,'public_id') except: pass db.drop_primary_key("cmsplugin_snippetptrpublic") db.rename_column("cmsplugin_snippetptrpublic", "publiccmsplugin_ptr_id", "cmspluginpublic_ptr_id") db.create_primary_key("cmsplugin_snippetptrpublic", ("cmspluginpublic_ptr_id",)) db.foreign_key_sql('cmsplugin_snippetptr' ,'public_id', 'cmsplugin_snippetptrpublic', 'cmspluginpublic_ptr_id')
def forwards(self, orm): db.rename_table("picture_picture", "cmsplugin_picture") db.rename_table("picture_publicpicture", "cmsplugin_picturepublic") db.rename_column("cmsplugin_picturepublic", "publiccmsplugin_ptr_id", "cmspluginpublic_ptr_id") db.alter_column('cmsplugin_picture', 'public_id', orm['picture.picture:public']) try: db.delete_foreign_key('cmsplugin_picture' ,'public_id') except: pass db.drop_primary_key("cmsplugin_picturepublic") db.create_primary_key("cmsplugin_picturepublic", ("cmspluginpublic_ptr_id",)) db.foreign_key_sql('cmsplugin_picture' ,'public_id', 'cmsplugin_picturepublic', 'cmspluginpublic_ptr_id')
def forwards(self, orm): db.rename_table("googlemap_googlemap", "cmsplugin_googlemap") db.rename_table("googlemap_publicgooglemap", "cmsplugin_googlemappublic") db.alter_column('cmsplugin_googlemap', 'public_id', orm['googlemap.googlemap:public']) try: db.delete_foreign_key('cmsplugin_googlemap' ,'public_id') except: pass db.drop_primary_key("cmsplugin_googlemappublic") db.rename_column("cmsplugin_googlemappublic", "publiccmsplugin_ptr_id", "cmspluginpublic_ptr_id") db.create_primary_key("cmsplugin_googlemappublic", ("cmspluginpublic_ptr_id",)) db.foreign_key_sql('cmsplugin_googlemap' ,'public_id', 'cmsplugin_googlemappublic', 'cmspluginpublic_ptr_id')
def forwards(self, orm): db.rename_table("text_text", "cmsplugin_text") db.rename_table("text_publictext", "cmsplugin_textpublic") db.rename_column("cmsplugin_textpublic", "publiccmsplugin_ptr_id", "cmspluginpublic_ptr_id") db.alter_column('cmsplugin_text', 'public_id', orm['text.text:public']) try: db.delete_foreign_key('cmsplugin_text' ,'public_id') except: pass db.drop_primary_key("cmsplugin_textpublic") db.create_primary_key("cmsplugin_textpublic", ("cmspluginpublic_ptr_id",)) db.foreign_key_sql('cmsplugin_text' ,'public_id', 'cmsplugin_textpublic', 'cmspluginpublic_ptr_id')
def forwards(self, orm): db.rename_table("link_link", "cmsplugin_link") db.rename_table("link_publiclink", "cmsplugin_linkpublic") db.alter_column('cmsplugin_link', 'public_id', orm['link.link:public']) try: db.delete_foreign_key('cmsplugin_link' ,'public_id') except: pass db.drop_primary_key("cmsplugin_linkpublic") db.rename_column("cmsplugin_linkpublic", "publiccmsplugin_ptr_id", "cmspluginpublic_ptr_id") db.create_primary_key("cmsplugin_linkpublic", ("cmspluginpublic_ptr_id",)) db.foreign_key_sql('cmsplugin_link' ,'public_id', 'cmsplugin_linkpublic', 'cmspluginpublic_ptr_id')
def test_primary_key(self): """ Test the primary key operations """ db.create_table("test_pk", [ ('id', models.IntegerField(primary_key=True)), ('new_pkey', models.IntegerField()), ('eggs', models.IntegerField(unique=True)), ]) db.execute_deferred_sql() db.start_transaction() # Remove the default primary key, and make eggs it db.drop_primary_key("test_pk") db.create_primary_key("test_pk", "new_pkey") # Try inserting a now-valid row pair db.execute("INSERT INTO test_pk (id, new_pkey, eggs) VALUES (1, 2, 3), (1, 3, 4)") db.rollback_transaction() db.delete_table("test_pk")
def test_primary_key(self): """ Test the primary key operations """ # SQLite backend doesn't support this yet. if db.backend_name == "sqlite3": return db.create_table("test_pk", [ ('id', models.IntegerField(primary_key=True)), ('new_pkey', models.IntegerField()), ('eggs', models.IntegerField(unique=True)), ]) db.execute_deferred_sql() # Remove the default primary key, and make eggs it db.drop_primary_key("test_pk") db.create_primary_key("test_pk", "new_pkey") # Try inserting a now-valid row pair db.execute("INSERT INTO test_pk (id, new_pkey, eggs) VALUES (1, 2, 3)") db.execute("INSERT INTO test_pk (id, new_pkey, eggs) VALUES (1, 3, 4)") db.delete_table("test_pk")
def forwards_publishable(self, orm): ''' creation of publishable objects TODO: sync publish_from ''' # move the data # db.execute(''' # INSERT INTO # `core_publishable` (old_id, content_type_id, %(cols_to)s) # SELECT # a.id, ct.id, %(cols_from)s # FROM # `%(table)s` a, `django_content_type` ct # WHERE # ct.`app_label` = '%(app_label)s' AND ct.`model` = '%(model)s'; # ''' % self.substitute # ) # add link to parent db.add_column(self.table, 'publishable_ptr', models.IntegerField(null=True, blank=True)) # update the link # db.execute(''' # UPDATE # `core_publishable` pub # JOIN `%(table)s` art ON (art.`id` = pub.`old_id`) # JOIN `django_content_type` ct ON (pub.`content_type_id` = ct.`id` AND ct.`app_label` = '%(app_label)s' AND ct.`model` = '%(model)s') # SET # art.`publishable_ptr` = pub.`id`; # ''' % self.substitute # ) # remove constraints from all models reffering to us # self.alter_self_foreignkeys(orm) # drop primary key db.alter_column(self.table, 'id', models.IntegerField()) db.drop_primary_key(self.table) # replace it with a link to parent db.rename_column(self.table, 'publishable_ptr', 'publishable_ptr_id') db.alter_column( self.table, 'publishable_ptr_id', models.ForeignKey(orm['core.Publishable'], unique=True)) db.create_primary_key(self.table, 'publishable_ptr_id') # make it a FK # db.execute( # 'ALTER TABLE `%s` ADD CONSTRAINT `publishable_ptr_id_refs_id_%s` FOREIGN KEY (`publishable_ptr_id`) REFERENCES `core_publishable` (`id`);' % ( # self.table, # abs(hash((self.table, 'core_publishable'))), # ) # ) # move data, that were pointing to us # self.move_self_foreignkeys(orm) # drop duplicate columns db.delete_column(self.table, 'id') for column in self.cols_from: db.delete_column(self.table, column)
def forwards_publishable(self, orm): ''' creation of publishable objects TODO: sync publish_from ''' # move the data # db.execute(''' # INSERT INTO # `core_publishable` (old_id, content_type_id, %(cols_to)s) # SELECT # a.id, ct.id, %(cols_from)s # FROM # `%(table)s` a, `django_content_type` ct # WHERE # ct.`app_label` = '%(app_label)s' AND ct.`model` = '%(model)s'; # ''' % self.substitute # ) # add link to parent db.add_column(self.table, 'publishable_ptr', models.IntegerField(null=True, blank=True)) # update the link # db.execute(''' # UPDATE # `core_publishable` pub # JOIN `%(table)s` art ON (art.`id` = pub.`old_id`) # JOIN `django_content_type` ct ON (pub.`content_type_id` = ct.`id` AND ct.`app_label` = '%(app_label)s' AND ct.`model` = '%(model)s') # SET # art.`publishable_ptr` = pub.`id`; # ''' % self.substitute # ) # remove constraints from all models reffering to us # self.alter_self_foreignkeys(orm) # drop primary key db.alter_column(self.table, 'id', models.IntegerField()) db.drop_primary_key(self.table) # replace it with a link to parent db.rename_column(self.table, 'publishable_ptr', 'publishable_ptr_id') db.alter_column(self.table, 'publishable_ptr_id', models.ForeignKey(orm['core.Publishable'], unique=True)) db.create_primary_key(self.table, 'publishable_ptr_id') # make it a FK # db.execute( # 'ALTER TABLE `%s` ADD CONSTRAINT `publishable_ptr_id_refs_id_%s` FOREIGN KEY (`publishable_ptr_id`) REFERENCES `core_publishable` (`id`);' % ( # self.table, # abs(hash((self.table, 'core_publishable'))), # ) # ) # move data, that were pointing to us # self.move_self_foreignkeys(orm) # drop duplicate columns db.delete_column(self.table, 'id') for column in self.cols_from: db.delete_column(self.table, column)
def forwards(self, orm): db.drop_primary_key('cg_tag_map') # Adding field 'TagMap.id' db.add_column('cg_tag_map', 'id', orm['labels.tagmap:id'])