def forwards(self, orm): if db.backend_name != 'sqlite3': db.drop_foreign_key(u'certificados_revogacao', 'emissao_id') db.rename_column(u'certificados_revogacao', 'emissao_id', 'emission_id') db.rename_column(u'certificados_revogacao', 'revogacao_motivo', 'revoke_reason') if db.backend_name != 'sqlite3': db.alter_column(u'certificados_revogacao', 'emission_id', models.ForeignKey(to=orm['certificados.Emissao']))
def forwards(self, orm): using_mysql = db.backend_name == 'mysql' db.rename_table('easy_thumbnails_storagenew', 'easy_thumbnails_storage') if using_mysql: try: db.drop_foreign_key('easy_thumbnails_source', 'storage_new_id') except ValueError, e: # e.g MyISAM tables don't support foreign key constraints print "Could not remove foreign key contraint: %s" % e
def forwards(self, orm): db.drop_foreign_key('main_video', 'series_id') # Renaming model 'Series' -> 'Collection' db.rename_table('main_series', 'main_collection') # Deleting field 'Video.series' db.rename_column('main_video', 'series_id', 'collection_id') db.alter_column('main_video', 'collection_id', models.ForeignKey(to=orm['main.Collection']))
def forwards(self, orm): db.rename_table('multilingual_initiatives_initiativetranslation', 'multilingual_initiatives_initiative_translation') try: db.drop_foreign_key('multilingual_initiatives_initiative_translation', 'initiative_id') except: pass db.rename_column('multilingual_initiatives_initiative_translation', 'initiative_id', 'master_id') db.rename_column('multilingual_initiatives_initiative_translation', 'language', 'language_code') db.alter_column('multilingual_initiatives_initiative_translation', 'master_id', models.ForeignKey(to=orm['multilingual_initiatives.Initiative'])) # Adding unique constraint on 'InitiativeTranslation', fields ['language_code', 'master'] db.create_unique(u'multilingual_initiatives_initiative_translation', ['language_code', 'master_id'])
def forwards(self, orm): db.rename_table('eway_ewaytransaction', 'eway_transaction') db.rename_table('eway_ewayresponsecode', 'eway_responsecode') db.rename_table('eway_ewayresponsecode_transactions', 'eway_responsecode_transactions') if db.backend_name == 'mysql': db.drop_foreign_key('eway_responsecode_transactions', 'ewayresponsecode_id') db.drop_foreign_key('eway_responsecode_transactions', 'ewaytransaction_id') db.rename_column('eway_responsecode_transactions', 'ewayresponsecode_id', 'responsecode_id') db.rename_column('eway_responsecode_transactions', 'ewaytransaction_id', 'transaction_id') if db.backend_name == 'mysql': db.alter_column('eway_responsecode_transactions', 'responsecode_id', models.ForeignKey(null=False, to=orm['eway.responsecode'])) db.alter_column('eway_responsecode_transactions', 'transaction_id', models.ForeignKey(null=False, to=orm['eway.transaction']))
def forwards(self, orm): using_mysql = db.backend_name == 'mysql' db.rename_table('easy_thumbnails_storagenew', 'easy_thumbnails_storage') if using_mysql: db.drop_foreign_key('easy_thumbnails_source', 'storage_new_id') db.rename_column('easy_thumbnails_source', 'storage_new_id', 'storage_id') if using_mysql: db.execute('ALTER TABLE easy_thumbnails_source ADD CONSTRAINT ' 'sourcestorage_id_fk_to_storage FOREIGN KEY (storage_id) ' 'REFERENCES easy_thumbnails_storage(id)') if using_mysql: db.drop_foreign_key('easy_thumbnails_thumbnail', 'storage_new_id') db.rename_column('easy_thumbnails_thumbnail', 'storage_new_id', 'storage_id') if using_mysql: db.execute('ALTER TABLE easy_thumbnails_thumbnail ADD CONSTRAINT ' 'thumbnailstorage_id_fk_to_storage FOREIGN KEY (storage_id) ' 'REFERENCES easy_thumbnails_storage(id)')
def forwards(self, orm): rename_tables_old_to_new(db) # SQLite3 and MySQL NOTE: Altering FK constraints are broken this # backend, but, its OK to just rename the columns here, because # constraints are disabled anyway. if connection.vendor not in ('sqlite', ): db.drop_foreign_key('aldryn_newsblog_latestentriesplugin', 'namespace_id') db.rename_column('aldryn_newsblog_latestentriesplugin', 'namespace_id', 'app_config_id') if connection.vendor not in ('sqlite', 'mysql', ): db.alter_column('aldryn_newsblog_latestentriesplugin', 'app_config_id', models.ForeignKey(orm['aldryn_newsblog.NewsBlogConfig'])) if connection.vendor not in ('sqlite', ): db.drop_foreign_key('aldryn_newsblog_article', 'namespace_id') db.rename_column('aldryn_newsblog_article', 'namespace_id', 'app_config_id') if connection.vendor not in ('sqlite', 'mysql', ): db.alter_column('aldryn_newsblog_article', 'app_config_id', models.ForeignKey(orm['aldryn_newsblog.NewsBlogConfig']))
def forwards(self, orm): # Changing field 'PublicKeyPair.fingerprint' db.alter_column('userdata_publickeypair', 'fingerprint', self.gf('django.db.models.fields.CharField')(max_length=100, blank=True)) try: db.drop_foreign_key('userdata_publickeypair', 'user_id') except: pass # Renaming column for 'PublicKeyPair.user' to match new field type. db.rename_column('userdata_publickeypair', 'user_id', 'user') # Changing field 'PublicKeyPair.user' db.alter_column('userdata_publickeypair', 'user', self.gf('django.db.models.fields.CharField')(max_length=100)) try: # Removing index on 'PublicKeyPair', fields ['user'] db.delete_index('userdata_publickeypair', ['user_id']) except: pass
def forwards(self, orm): db.rename_table('multilingual_initiatives_initiativetranslation', 'multilingual_initiatives_initiative_translation') try: db.drop_foreign_key( 'multilingual_initiatives_initiative_translation', 'initiative_id') except: pass db.rename_column('multilingual_initiatives_initiative_translation', 'initiative_id', 'master_id') db.rename_column('multilingual_initiatives_initiative_translation', 'language', 'language_code') db.alter_column( 'multilingual_initiatives_initiative_translation', 'master_id', models.ForeignKey(to=orm['multilingual_initiatives.Initiative'])) # Adding unique constraint on 'InitiativeTranslation', fields ['language_code', 'master'] db.create_unique(u'multilingual_initiatives_initiative_translation', ['language_code', 'master_id'])
def forwards(self, orm): using_mysql = db.backend_name == "mysql" db.rename_table("easy_thumbnails_storagenew", "easy_thumbnails_storage") if using_mysql: try: db.drop_foreign_key("easy_thumbnails_source", "storage_new_id") except ValueError: e = sys.exc_info()[1] # Python 2.5 compatable "as e" # e.g MyISAM tables don't support foreign key constraints print("Could not remove foreign key contraint: %s" % e) db.rename_column("easy_thumbnails_source", "storage_new_id", "storage_id") if using_mysql: try: db.execute( "ALTER TABLE easy_thumbnails_source ADD CONSTRAINT " "sourcestorage_id_fk_to_storage FOREIGN KEY (storage_id) " "REFERENCES easy_thumbnails_storage(id)" ) except Exception: e = sys.exc_info()[1] # Python 2.5 compatable "as e" print("Could not add contraint: %s" % e) if using_mysql: try: db.drop_foreign_key("easy_thumbnails_thumbnail", "storage_new_id") except ValueError: e = sys.exc_info()[1] # Python 2.5 compatable "as e" # e.g MyISAM tables don't support foreign key constraints print("Could not remove foreign key contraint: %s" % e) db.rename_column("easy_thumbnails_thumbnail", "storage_new_id", "storage_id") if using_mysql: try: db.execute( "ALTER TABLE easy_thumbnails_thumbnail ADD CONSTRAINT " "thumbnailstorage_id_fk_to_storage FOREIGN KEY (storage_id) " "REFERENCES easy_thumbnails_storage(id)" ) except Exception: e = sys.exc_info()[1] # Python 2.5 compatable "as e" print("Could not add contraint: %s" % e)
def forwards(self, orm): # SQLite3 NOTE: Altering FK constraints are broken this backend, but, # its OK to just rename the columns here, because constraints are # disabled anyway. if connection.vendor != 'sqlite': db.drop_foreign_key('aldryn_newsblog_latestentriesplugin', 'namespace_id') db.rename_column('aldryn_newsblog_latestentriesplugin', 'namespace_id', 'app_config_id') if connection.vendor != 'sqlite': db.alter_column( 'aldryn_newsblog_latestentriesplugin', 'app_config_id', models.ForeignKey(orm['aldryn_newsblog.NewsBlogConfig'])) if connection.vendor != 'sqlite': db.drop_foreign_key('aldryn_newsblog_article', 'namespace_id') db.rename_column('aldryn_newsblog_article', 'namespace_id', 'app_config_id') if connection.vendor != 'sqlite': db.alter_column( 'aldryn_newsblog_article', 'app_config_id', models.ForeignKey(orm['aldryn_newsblog.NewsBlogConfig']))
def forwards(self, orm): # Changing field 'PublicKeyPair.fingerprint' db.alter_column( 'userdata_publickeypair', 'fingerprint', self.gf('django.db.models.fields.CharField')(max_length=100, blank=True)) try: db.drop_foreign_key('userdata_publickeypair', 'user_id') except: pass # Renaming column for 'PublicKeyPair.user' to match new field type. db.rename_column('userdata_publickeypair', 'user_id', 'user') # Changing field 'PublicKeyPair.user' db.alter_column( 'userdata_publickeypair', 'user', self.gf('django.db.models.fields.CharField')(max_length=100)) try: # Removing index on 'PublicKeyPair', fields ['user'] db.delete_index('userdata_publickeypair', ['user_id']) except: pass
def forwards(self, orm): using_mysql = db.backend_name == 'mysql' db.rename_table('easy_thumbnails_storagenew', 'easy_thumbnails_storage') if using_mysql: try: db.drop_foreign_key('easy_thumbnails_source', 'storage_new_id') except ValueError: e = sys.exc_info()[1] # Python 2.5 compatable "as e" # e.g MyISAM tables don't support foreign key constraints print("Could not remove foreign key contraint: %s" % e) db.rename_column('easy_thumbnails_source', 'storage_new_id', 'storage_id') if using_mysql: try: db.execute('ALTER TABLE easy_thumbnails_source ADD CONSTRAINT ' 'sourcestorage_id_fk_to_storage FOREIGN KEY (storage_id) ' 'REFERENCES easy_thumbnails_storage(id)') except Exception: e = sys.exc_info()[1] # Python 2.5 compatable "as e" print("Could not add contraint: %s" % e) if using_mysql: try: db.drop_foreign_key('easy_thumbnails_thumbnail', 'storage_new_id') except ValueError: e = sys.exc_info()[1] # Python 2.5 compatable "as e" # e.g MyISAM tables don't support foreign key constraints print("Could not remove foreign key contraint: %s" % e) db.rename_column('easy_thumbnails_thumbnail', 'storage_new_id', 'storage_id') if using_mysql: try: db.execute('ALTER TABLE easy_thumbnails_thumbnail ADD CONSTRAINT ' 'thumbnailstorage_id_fk_to_storage FOREIGN KEY (storage_id) ' 'REFERENCES easy_thumbnails_storage(id)') except Exception: e = sys.exc_info()[1] # Python 2.5 compatable "as e" print("Could not add contraint: %s" % e)
def forwards(self, orm): db.rename_table('hero_slider_slideritemtitle', 'hero_slider_slideritem_translation') try: db.drop_foreign_key('hero_slider_slideritem_translation', 'slider_item_id') except: pass db.rename_column('hero_slider_slideritem_translation', 'slider_item_id', 'master_id') db.rename_column('hero_slider_slideritem_translation', 'language', 'language_code') db.alter_column('hero_slider_slideritem_translation', 'master_id', models.ForeignKey(to=orm['hero_slider.SliderItem'])) # Adding unique constraint on 'SliderItemTranslation', fields ['language_code', 'master'] db.create_unique('hero_slider_slideritem_translation', ['language_code', 'master_id']) db.rename_table('hero_slider_slideritemcategorytitle', 'hero_slider_slideritemcategory_translation') try: db.drop_foreign_key('hero_slider_slideritemcategory_translation', 'slider_item_category_id') except: pass db.rename_column('hero_slider_slideritemcategory_translation', 'slider_item_category_id', 'master_id') db.rename_column('hero_slider_slideritemcategory_translation', 'language', 'language_code') db.alter_column('hero_slider_slideritemcategory_translation', 'master_id', models.ForeignKey(to=orm['hero_slider.SliderItemCategory'])) # Adding unique constraint on 'SliderItemCategoryTranslation', fields ['language_code', 'master'] db.create_unique('hero_slider_slideritemcategory_translation', ['language_code', 'master_id'])
def forwards(self, orm): # change tables and columns for Goal model db.rename_table('good_practice_examples_goaltranslation', 'good_practice_examples_goal_translation') try: db.drop_foreign_key('good_practice_examples_goal_translation', 'goal_id') except: pass db.rename_column('good_practice_examples_goal_translation', 'goal_id', 'master_id') db.rename_column('good_practice_examples_goal_translation', 'language', 'language_code') db.alter_column('good_practice_examples_goal_translation', 'master_id', models.ForeignKey(to=orm['good_practice_examples.Goal'])) # change tables and columns for Sector model db.rename_table('good_practice_examples_sectortranslation', 'good_practice_examples_sector_translation') try: db.drop_foreign_key('good_practice_examples_sector_translation', 'sector_id') except: pass db.rename_column('good_practice_examples_sector_translation', 'sector_id', 'master_id') db.rename_column('good_practice_examples_sector_translation', 'language', 'language_code') db.alter_column('good_practice_examples_sector_translation', 'master_id', models.ForeignKey(to=orm['good_practice_examples.sector'])) # change tables and columns for GoodPracticeExample model db.rename_table('good_practice_examples_goodpracticeexampletranslation', 'good_practice_examples_goodpracticeexample_translation') try: db.drop_foreign_key('good_practice_examples_goodpracticeexample_translation', 'good_practice_example_id') except: pass db.rename_column('good_practice_examples_goodpracticeexample_translation', 'good_practice_example_id', 'master_id') db.rename_column('good_practice_examples_goodpracticeexample_translation', 'language', 'language_code') db.alter_column('good_practice_examples_goodpracticeexample_translation', 'master_id', models.ForeignKey(to=orm['good_practice_examples.goodpracticeexample'])) # Adding unique constraint on 'SectorTranslation', fields ['language_code', 'master'] db.create_unique(u'good_practice_examples_sector_translation', ['language_code', 'master_id']) # Adding unique constraint on 'GoodPracticeExampleTranslation', fields ['language_code', 'master'] db.create_unique(u'good_practice_examples_goodpracticeexample_translation', ['language_code', 'master_id']) # Adding unique constraint on 'GoalTranslation', fields ['language_code', 'master'] db.create_unique(u'good_practice_examples_goal_translation', ['language_code', 'master_id'])
def forwards(self, orm): # change tables and columns for Goal model db.rename_table('good_practice_examples_goaltranslation', 'good_practice_examples_goal_translation') try: db.drop_foreign_key('good_practice_examples_goal_translation', 'goal_id') except: pass db.rename_column('good_practice_examples_goal_translation', 'goal_id', 'master_id') db.rename_column('good_practice_examples_goal_translation', 'language', 'language_code') db.alter_column( 'good_practice_examples_goal_translation', 'master_id', models.ForeignKey(to=orm['good_practice_examples.Goal'])) # change tables and columns for Sector model db.rename_table('good_practice_examples_sectortranslation', 'good_practice_examples_sector_translation') try: db.drop_foreign_key('good_practice_examples_sector_translation', 'sector_id') except: pass db.rename_column('good_practice_examples_sector_translation', 'sector_id', 'master_id') db.rename_column('good_practice_examples_sector_translation', 'language', 'language_code') db.alter_column( 'good_practice_examples_sector_translation', 'master_id', models.ForeignKey(to=orm['good_practice_examples.sector'])) # change tables and columns for GoodPracticeExample model db.rename_table( 'good_practice_examples_goodpracticeexampletranslation', 'good_practice_examples_goodpracticeexample_translation') try: db.drop_foreign_key( 'good_practice_examples_goodpracticeexample_translation', 'good_practice_example_id') except: pass db.rename_column( 'good_practice_examples_goodpracticeexample_translation', 'good_practice_example_id', 'master_id') db.rename_column( 'good_practice_examples_goodpracticeexample_translation', 'language', 'language_code') db.alter_column( 'good_practice_examples_goodpracticeexample_translation', 'master_id', models.ForeignKey( to=orm['good_practice_examples.goodpracticeexample'])) # Adding unique constraint on 'SectorTranslation', fields ['language_code', 'master'] db.create_unique(u'good_practice_examples_sector_translation', ['language_code', 'master_id']) # Adding unique constraint on 'GoodPracticeExampleTranslation', fields ['language_code', 'master'] db.create_unique( u'good_practice_examples_goodpracticeexample_translation', ['language_code', 'master_id']) # Adding unique constraint on 'GoalTranslation', fields ['language_code', 'master'] db.create_unique(u'good_practice_examples_goal_translation', ['language_code', 'master_id'])
def backwards(self, orm): db.drop_foreign_key('main_video', 'collection_id') db.rename_table('main_collection', 'main_series') db.rename_column('main_video', 'collection_id', 'series_id') db.alter_column('main_video', 'series_id', models.ForeignKey(to=orm['main.Series']))
# e.g MyISAM tables don't support foreign key constraints print "Could not remove foreign key contraint: %s" % e db.rename_column('easy_thumbnails_source', 'storage_new_id', 'storage_id') if using_mysql: try: db.execute( 'ALTER TABLE easy_thumbnails_source ADD CONSTRAINT ' 'sourcestorage_id_fk_to_storage FOREIGN KEY (storage_id) ' 'REFERENCES easy_thumbnails_storage(id)') except Exception, e: print "Could not add contraint: %s" % e if using_mysql: try: db.drop_foreign_key('easy_thumbnails_thumbnail', 'storage_new_id') except ValueError, e: # e.g MyISAM tables don't support foreign key constraints print "Could not remove foreign key contraint: %s" % e db.rename_column('easy_thumbnails_thumbnail', 'storage_new_id', 'storage_id') if using_mysql: try: db.execute( 'ALTER TABLE easy_thumbnails_thumbnail ADD CONSTRAINT ' 'thumbnailstorage_id_fk_to_storage FOREIGN KEY (storage_id) ' 'REFERENCES easy_thumbnails_storage(id)') except Exception, e: print "Could not add contraint: %s" % e def backwards(self, orm):
def forwards(self, orm): if db.backend_name != "sqlite3": db.drop_foreign_key('accounts_userprofile', 'country_new_id') db.rename_column('accounts_userprofile', 'country_new_id', 'country_id')
db.drop_foreign_key('easy_thumbnails_source', 'storage_new_id') except ValueError, e: # e.g MyISAM tables don't support foreign key constraints print "Could not remove foreign key contraint: %s" % e db.rename_column('easy_thumbnails_source', 'storage_new_id', 'storage_id') if using_mysql: try: db.execute('ALTER TABLE easy_thumbnails_source ADD CONSTRAINT ' 'sourcestorage_id_fk_to_storage FOREIGN KEY (storage_id) ' 'REFERENCES easy_thumbnails_storage(id)') except Exception, e: print "Could not add contraint: %s" % e if using_mysql: try: db.drop_foreign_key('easy_thumbnails_thumbnail', 'storage_new_id') except ValueError, e: # e.g MyISAM tables don't support foreign key constraints print "Could not remove foreign key contraint: %s" % e db.rename_column('easy_thumbnails_thumbnail', 'storage_new_id', 'storage_id') if using_mysql: try: db.execute('ALTER TABLE easy_thumbnails_thumbnail ADD CONSTRAINT ' 'thumbnailstorage_id_fk_to_storage FOREIGN KEY (storage_id) ' 'REFERENCES easy_thumbnails_storage(id)') except Exception, e: print "Could not add contraint: %s" % e def backwards(self, orm): db.rename_table('easy_thumbnails_storage', 'easy_thumbnails_storagenew')
def forwards(self, orm): if db.backend_name != "sqlite3": db.drop_foreign_key('accounts_shippingaddress', 'country_new_id') db.rename_column('accounts_shippingaddress', 'country_new_id', 'country_id')