def get_next_task_number():
seq = db.Sequence('task_number_seq')
key = "T-{0}".format(str(db.session.connection().execute(seq)).zfill(6))
return key
def get_next_procedure_number():
seq = db.Sequence('procedure_number_seq')
key = "DOC-{0}".format(str(db.session.connection().execute(seq)).zfill(6))
return key
def get_next_eco_key():
seq = db.Sequence('eco_key_seq')
key = "ECO-{0}".format(str(db.session.connection().execute(seq)).zfill(6))
return key
def get_next_specification_number():
seq = db.Sequence('specification_number_seq')
key = "PRI-{0}".format(str(db.session.connection().execute(seq)).zfill(5))
return key