def upgrade():
context = op.get_context()
session = Session()
session.bind = context.bind
for tp in session.query(TimeEntry).filter_by(customer_request_id=None):
for trac in tp.project.tracs:
cr = session.execute('select value from "trac_%s".ticket_custom where name=\'customerrequest\' and ticket=%s' % (trac.trac_name, tp.ticket)).fetchone()
sql_cr = session.execute('select id from customer_requests where id=\'%s\'' % cr.value).fetchone()
tp.customer_request_id = sql_cr.id
print sql_cr.id
session.commit()
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.add_column('time_entries', sa.Column('tickettitle', sa.Unicode(), nullable=True))
context = op.get_context()
session = Session()
session.bind = context.bind
for tp in session.query(TimeEntry):
for trac in tp.project.tracs:
ticket = session.execute('select summary from "trac_%s".ticket where id=%s' % (trac.trac_name, tp.ticket)).fetchone()
tp.tickettitle = ticket.summary
session.commit()
def upgrade():
context = op.get_context()
session = Session()
session.bind = context.bind
session.execute(
"""ALTER TABLE applications DROP CONSTRAINT "applications_project_id_fkey", ADD CONSTRAINT "applications_project_id_fkey" foreign key (project_id) references projects(id) on update cascade;
ALTER TABLE customer_requests DROP CONSTRAINT "customer_requests_project_id_fkey", ADD CONSTRAINT "customer_requests_project_id_fkey" foreign key (project_id) references projects(id) on update cascade;
ALTER TABLE groups DROP CONSTRAINT "groups_project_id_fkey", ADD CONSTRAINT "groups_project_id_fkey" foreign key (project_id) references projects(id) on update cascade;
ALTER TABLE contracts ADD CONSTRAINT "contracts_project_id_fkey" foreign key (project_id) references projects(id) on update cascade;
ALTER TABLE kanban_projects DROP CONSTRAINT "kanban_projects_project_id_fkey", ADD CONSTRAINT "kanban_projects_project_id_fkey" foreign key (project_id) references projects(id) on update cascade on delete cascade;
ALTER TABLE favorite_projects DROP CONSTRAINT "favorite_projects_project_id_fkey", ADD CONSTRAINT "favorite_projects_project_id_fkey" foreign key (project_id) references projects(id) on update cascade;
ALTER TABLE time_entries DROP CONSTRAINT "time_entries_project_id_fkey", ADD CONSTRAINT "time_entries_project_id_fkey" foreign key (project_id) references projects(id) on update cascade;""")
session.commit()
def upgrade():
context = op.get_context()
session = Session()
session.bind = context.bind
for b in session.query(KanbanBoard):
if b.json:
columns = loads(b.json)
for n, column in enumerate(columns):
for m, task in enumerate(column['tasks']):
new_id = update_id(task['id'])
print task['id'], new_id
if new_id != task['id']:
columns[n]['tasks'][m]['id'] = new_id
b.json = dumps(columns)
session.commit()
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.add_column('time_entries', sa.Column('customer_request_id', sa.String(), nullable=True))
op.drop_column('time_entries', u'contract_id')
op.drop_column('customer_requests', u'placement')
context = op.get_context()
session = Session()
session.bind = context.bind
for tp in session.query(TimeEntry):
for trac in tp.project.tracs:
cr = session.execute('select value from "trac_%s".ticket_custom where name=\'customerrequest\' and ticket=%s' % (trac.trac_name, tp.ticket)).fetchone()
sql_cr = session.execute('select id from customer_requests where id=\'%s\'' % cr.value).fetchone()
tp.customer_request_id = sql_cr.id
session.commit()
