def upgrade(): if not column_exists("customer", "fax"): op.add_column("customer", sa.Column("fax", sa.String(50), nullable=True)) if not column_exists("customer", "function"): op.add_column("customer", sa.Column("function", sa.String(255), nullable=True))
def upgrade(): # Devis op.add_column("estimation_line", sa.Column("tva", sa.Integer)) # Adding tva to the lines op.execute(""" update estimation_line as l join estimation as e on e.id=l.task_id set l.tva=e.tva; """) # Moving dicounts to a discount table for est in Estimation.query().all(): id_ = est.id op.execute(""" insert discount (description, amount, tva, task_id) select "Remise", discountHT, tva, id from estimation where estimation.id='%s' and estimation.discountHT!= 0 and estimation.discountHT is not null ; """% (id_)) # Factures op.add_column("invoice_line", sa.Column("tva", sa.Integer)) # Adding tva to the lines op.execute(""" update invoice_line as l join invoice as i on i.id=l.task_id set l.tva=i.tva; """) # Moving discounts to discount table for inv in Invoice.query().all(): id_ = inv.id op.execute(""" insert discount (description, amount, tva, task_id) select "Remise", discountHT, tva, id from invoice where invoice.id='%s' and invoice.discountHT!= 0 and invoice.discountHT is not null ; """% (id_)) # Avoirs add_column("cancelinvoice_line", sa.Column("tva", sa.Integer)) if column_exists("cancelinvoice", "tva"): # If the column exists, there may be some cancelinvoices op.execute(""" update cancelinvoice_line as l join cancelinvoice as i on i.id=l.task_id set l.tva=i.tva; """)
def upgrade(): for table in "invoice", "cancelinvoice", "manualinv": if not column_exists(table, "financial_year"): op.add_column(table, sa.Column("financial_year", sa.Integer, nullable=False)) for type_ in (Invoice, CancelInvoice, ManualInvoice): for document in type_.query(): document.financial_year = document.taskDate.year DBSESSION.merge(document)
def update_database_structure(): op.add_column( "project", sa.Column( 'project_type_id', sa.Integer, sa.ForeignKey('project_type.id'), ) ) op.add_column("task_mention", sa.Column("help_text", sa.String(255))) op.alter_column( 'project', 'type', new_column_name='description', existing_type=sa.String(150), existing_nullable=True ) op.add_column( 'task', sa.Column( 'business_type_id', sa.Integer, sa.ForeignKey('business_type.id') ) ) op.add_column( 'task', sa.Column( 'business_id', sa.Integer, sa.ForeignKey('business.id') ) ) op.add_column( "task", sa.Column( "version", sa.Integer, ) ) op.add_column( 'task', sa.Column('legacy_number', sa.Boolean(), nullable=False) ) for tbl, column in ( ("task", "name"), ("task", "type_"), ("project", "client_id"), ("project", "name"), ("project", "creationDate"), ('project', "updateDate"), ('project', "dispatchType"), ): if column_exists(tbl, column): op.drop_column(tbl, column) op.execute("alter table task MODIFY `phase_id` int(11) DEFAULT NULL;") op.add_column('task', sa.Column('pdf_file_id', sa.Integer(), nullable=True)) op.create_foreign_key( op.f('fk_task_pdf_file_id'), 'task', 'file', ['pdf_file_id'], ['id'] ) op.add_column('task', sa.Column('notes', sa.Text(), nullable=True))
def clean_database(): """ Remove obsolete tables and columns """ disable_constraints() op.drop_table('cae_situation_change') op.drop_table('contract_history') op.drop_table('date_convention_cape_datas') op.drop_table('date_diagnostic_datas') op.drop_table('date_dpae_datas') op.drop_constraint('fk_user_datas_parcours_employee_quality_id', 'user_datas', type_='foreignkey') if column_exists('user_datas', 'sortie_motif_id'): try: op.drop_constraint('fk_user_datas_sortie_motif_id', 'user_datas', type_='foreignkey') except: pass op.drop_column('user_datas', 'sortie_motif_id',) if column_exists('user_datas', 'sortie_type_id'): try: op.drop_constraint('fk_user_datas_sortie_type_id', 'user_datas', type_='foreignkey') except: pass op.drop_column('user_datas', 'sortie_type_id',) for column in ( ('user_datas', 'parcours_contract_type',), ('user_datas', 'parcours_start_date',), ('user_datas', 'parcours_end_date',), ('user_datas', 'parcours_last_avenant',), ('user_datas', 'parcours_taux_horaire',), ('user_datas', 'parcours_taux_horaire_letters',), ('user_datas', 'parcours_num_hours',), ('user_datas', 'parcours_salary',), ('user_datas', 'parcours_salary_letters',), ('user_datas', 'parcours_employee_quality_id',), ('user_datas', 'sortie_date',), ('user_datas', 'sortie_motif_id',), ): if column_exists('user_datas', column): op.drop_column('user_datas', column) enable_constraints()
def upgrade(): from autonomie.models.task import Invoice, CancelInvoice, ManualInvoice from autonomie_base.models.base import DBSESSION for table in "invoice", "cancelinvoice", "manualinv": if not column_exists(table, "financial_year"): op.add_column( table, sa.Column("financial_year", sa.Integer, nullable=False)) for type_ in (Invoice, CancelInvoice, ManualInvoice): for document in type_.query(): document.financial_year = document.taskDate.year DBSESSION.merge(document)
def update_database_structure(): utils.add_column( "accounting_operation_upload", sa.Column("filetype", sa.String(50)) ) utils.add_column( "accounting_operation", sa.Column("date", sa.Date()) ) if utils.column_exists('accounting_operation', 'datetime'): op.drop_column('accounting_operation', 'datetime') op.alter_column( 'company', 'contribution', existing_type=sa.Integer, type_=sa.Float, existing_nullable=True, )
def update_database_structure(): if not column_exists('task', 'notes'): op.add_column('task', sa.Column('notes', sa.Text(), nullable=True))
def upgrade(): disable_constraints() for table in OLD_TABLES: if table_exists(table): op.drop_table(table) op.alter_column('accounts', 'active', existing_type=mysql.VARCHAR(length=1), nullable=False, existing_server_default=sa.text(u"'Y'")) op.alter_column('accounts', 'email', existing_type=mysql.VARCHAR(length=100), nullable=False) op.alter_column('accounts', 'firstname', existing_type=mysql.VARCHAR(length=50), nullable=False) op.alter_column('accounts', 'lastname', existing_type=mysql.VARCHAR(length=50), nullable=False) op.alter_column('company', 'active', existing_type=mysql.VARCHAR(length=1), nullable=False, existing_server_default=sa.text(u"'Y'")) op.alter_column('company', 'creationDate', existing_type=mysql.INTEGER(display_width=11), nullable=False) op.alter_column('company', 'name', existing_type=mysql.VARCHAR(length=150), nullable=False) op.alter_column('company', 'object', existing_type=mysql.VARCHAR(length=255), nullable=True) op.alter_column('company', 'phone', existing_type=mysql.VARCHAR(length=20), nullable=True) op.alter_column('company', 'updateDate', existing_type=mysql.INTEGER(display_width=11), nullable=False) op.alter_column('company_employee', 'account_id', existing_type=mysql.INTEGER(display_width=11), nullable=False) op.alter_column('company_employee', 'company_id', existing_type=mysql.INTEGER(display_width=11), nullable=False) op.alter_column('customer', 'address', existing_type=mysql.TEXT(), nullable=False) op.alter_column('customer', 'city', existing_type=mysql.VARCHAR(length=255), nullable=False) op.alter_column('customer', 'company_id', existing_type=mysql.INTEGER(display_width=11), nullable=True) op.alter_column('configurable_option', 'label', existing_type=mysql.VARCHAR(length=100), nullable=False) op.alter_column('customer', 'contactLastName', existing_type=mysql.VARCHAR(length=255), nullable=False) op.alter_column('customer', 'creationDate', existing_type=mysql.INTEGER(display_width=11), nullable=False) op.alter_column('customer', 'name', existing_type=mysql.VARCHAR(length=255), nullable=False) op.alter_column('customer', 'updateDate', existing_type=mysql.INTEGER(display_width=11), nullable=False) op.alter_column('customer', 'zipCode', existing_type=mysql.VARCHAR(length=20), nullable=False) op.alter_column('estimation', 'deposit', existing_type=mysql.INTEGER(display_width=11), nullable=True, existing_server_default=sa.text(u"'0'")) # Clean table for (table, column) in OLD_COLUMNS: if column_exists(table, column): op.drop_column(table, column) enable_constraints()
def upgrade(): if not column_exists('task_status', 'statusPerson'): op.execute(""" alter table task_status add column statusPerson INT(11) """)
def update_database_structure(): if not column_exists('task', 'legacy_number'): op.add_column('task', sa.Column('legacy_number', sa.Boolean(), nullable=False))
def clean_database(): """ Remove obsolete tables and columns """ disable_constraints() op.drop_table('cae_situation_change') op.drop_table('contract_history') op.drop_table('date_convention_cape_datas') op.drop_table('date_diagnostic_datas') op.drop_table('date_dpae_datas') op.drop_constraint('fk_user_datas_parcours_employee_quality_id', 'user_datas', type_='foreignkey') if column_exists('user_datas', 'sortie_motif_id'): try: op.drop_constraint('fk_user_datas_sortie_motif_id', 'user_datas', type_='foreignkey') except: pass op.drop_column( 'user_datas', 'sortie_motif_id', ) if column_exists('user_datas', 'sortie_type_id'): try: op.drop_constraint('fk_user_datas_sortie_type_id', 'user_datas', type_='foreignkey') except: pass op.drop_column( 'user_datas', 'sortie_type_id', ) for column in ( ( 'user_datas', 'parcours_contract_type', ), ( 'user_datas', 'parcours_start_date', ), ( 'user_datas', 'parcours_end_date', ), ( 'user_datas', 'parcours_last_avenant', ), ( 'user_datas', 'parcours_taux_horaire', ), ( 'user_datas', 'parcours_taux_horaire_letters', ), ( 'user_datas', 'parcours_num_hours', ), ( 'user_datas', 'parcours_salary', ), ( 'user_datas', 'parcours_salary_letters', ), ( 'user_datas', 'parcours_employee_quality_id', ), ( 'user_datas', 'sortie_date', ), ( 'user_datas', 'sortie_motif_id', ), ): if column_exists('user_datas', column): op.drop_column('user_datas', column) enable_constraints()
def clean_database(): if column_exists('estimation', 'exclusions'): op.drop_column('estimation', 'exclusions',)
def clean_database(): if column_exists('estimation', 'exclusions'): op.drop_column( 'estimation', 'exclusions', )