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():
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():
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 upgrade():
if not column_exists('task_status', 'statusPerson'):
op.execute("""
alter table task_status add column statusPerson INT(11)
""")
def clean_database():
if column_exists('estimation', 'exclusions'):
op.drop_column(
'estimation',
'exclusions',
)
def update_database_structure():
if not column_exists('task', 'notes'):
op.add_column('task', sa.Column('notes', sa.Text(), nullable=True))
