def update_tip_submission_status(session, tid, user_id, rtip_id,
submission_status_uuid,
submission_substatus_uuid):
rtip, itip = db_access_rtip(session, tid, user_id, rtip_id)
db_update_submission_status(session, tid, user_id, itip,
submission_status_uuid,
submission_substatus_uuid)
def db_set_itip_open_if_new(session, tid, user_id, itip):
new_status_id = session.query(models.SubmissionStatus.id) \
.filter(models.SubmissionStatus.tid == tid,
models.SubmissionStatus.system_usage == 'new').one()[0]
if new_status_id == itip.status:
open_status_id = session.query(models.SubmissionStatus.id) \
.filter(models.SubmissionStatus.tid == tid,
models.SubmissionStatus.system_usage == 'open').one()[0]
db_update_submission_status(session, tid, user_id, itip,
open_status_id, '')
def epilogue(self):
tenants = self.session_old.query(self.model_from['Tenant'])
for tenant in tenants:
initialize_submission_statuses(self.session_new, tenant.id)
self.session_new.flush()
for tenant in tenants:
itips = self.session_new.query(self.model_to['InternalTip'])\
.filter(self.model_to['InternalTip'].context_id == self.model_to['Context'].id,
self.model_to['Context'].tid == tenant.id)
for itip in itips:
open_status_id = self.session_new.query(self.model_to['SubmissionStatus'].id)\
.filter(self.model_to['SubmissionStatus'].tid == tenant.id,
self.model_to['SubmissionStatus'].system_usage == 'open').one()[0]
db_update_submission_status(self.session_new, tenant.id, u'',
itip, open_status_id, u'')