def add_effective_bdb(): if not column_exists('storefront_deploy', 'effective_bdb'): print 'SCHEMA UPDATE: Adding missing column: storefront_deploy.effective_bdb' from django.db import connection, transaction cursor = connection.cursor() sql = 'ALTER TABLE `storefront_deploy` ADD COLUMN `effective_bdb` integer NOT NULL DEFAULT 0' cursor.execute(sql) transaction.commit_unless_managed()
def add_account_default_analyzer(): if not column_exists('storefront_account', 'default_analyzer_id'): print 'SCHEMA UPDATE: Adding missing column: storefront_account.default_analyzer' from django.db import connection, transaction cursor = connection.cursor() sql = 'ALTER TABLE `storefront_account` ADD COLUMN `default_analyzer_id` integer NULL' cursor.execute(sql) sql = 'ALTER TABLE `storefront_account` ADD CONSTRAINT `default_analyzer_id_refs_id_44eb0c5b` FOREIGN KEY (`default_analyzer_id`) REFERENCES `storefront_analyzer` (`id`)' cursor.execute(sql) transaction.commit_unless_managed()
def add_change_password(): if not column_exists('storefront_pfuser', 'change_password'): print 'SCHEMA UPDATE: Adding missing column: storefront_pfuser.change_password' from django.db import connection, transaction cursor = connection.cursor() sql = 'ALTER TABLE `storefront_pfuser` ADD COLUMN `change_password` tinyint NULL' cursor.execute(sql) print 'DATA UPDATE' sql = 'UPDATE storefront_pfuser set change_password=0' cursor.execute(sql) sql = 'ALTER TABLE `storefront_pfuser` MODIFY COLUMN `change_password` tinyint NOT NULL' cursor.execute(sql) transaction.commit_unless_managed()
def update_custom_subscription(): if not column_exists('storefront_accountpayinginformation', 'monthly_amount'): print 'SCHEMA UPDATE: Upgrading table: storefront_accountpayinginformation' from django.db import connection, transaction cursor = connection.cursor() sql = 'ALTER TABLE `storefront_accountpayinginformation` MODIFY `first_name` varchar(50) NULL' cursor.execute(sql) sql = 'ALTER TABLE `storefront_accountpayinginformation` MODIFY `last_name` varchar(50) NULL' cursor.execute(sql) sql = 'ALTER TABLE `storefront_accountpayinginformation` MODIFY `contact_email` varchar(255) NULL' cursor.execute(sql) sql = 'ALTER TABLE `storefront_accountpayinginformation` MODIFY `credit_card_last_digits` varchar(3) NULL' cursor.execute(sql) sql = 'ALTER TABLE `storefront_accountpayinginformation` ADD COLUMN `subscription_status` varchar(30) NULL' cursor.execute(sql) sql = 'ALTER TABLE `storefront_accountpayinginformation` ADD COLUMN `subscription_type` varchar(30) NULL' cursor.execute(sql) sql = 'ALTER TABLE `storefront_accountpayinginformation` ADD COLUMN `monthly_amount` integer NULL' cursor.execute(sql) transaction.commit_unless_managed()