def get_cell_by_position(page_table_id, x0, y0, x1, y1): return ( db.session.query(cell) .filter( db.and_(cell.page_table_id == page_table_id, cell.x0 == x0, cell.y0 == y0, cell.x1 == x1, cell.y1 == y1) ) .first() )
def get_page_table_by_position(page_id, top_pos, left_pos, right_pos, bottom_pos): return ( db.session.query(page_table) .filter( db.and_( page_table.page_id == page_id, page_table.top_pos == top_pos, page_table.left_pos == left_pos, page_table.right_pos == right_pos, page_table.bottom_pos == bottom_pos, ) ) .first() )
def delete_workflow_transaction(workflow_transaction_info): try: db.session.query(workflow_transaction).filter( db.and_( workflow_transaction.task_id_1 == workflow_transaction_info["task_id_1"], workflow_transaction.task_id_2 == workflow_transaction_info["task_id_2"], workflow_transaction.task_id_3 == workflow_transaction_info["task_id_3"], workflow_transaction.task_id_4 == workflow_transaction_info["task_id_4"], ) ).delete(synchronize_session="fetch") db.session.commit() except Exception as e: db.session.rollback() raise e
def get_workflow_transaction(workflow_transaction_info=None): if workflow_transaction_info == None: return db.session.query(workflow_transaction).all() else: return ( db.session.query(workflow_transaction) .filter( db.and_( workflow_transaction.task_id_1 == workflow_transaction_info["task_id_1"], workflow_transaction.task_id_2 == workflow_transaction_info["task_id_2"], workflow_transaction.task_id_3 == workflow_transaction_info["task_id_3"], workflow_transaction.task_id_4 == workflow_transaction_info["task_id_4"], ) ) .first() )
def get_page_table(book_id, page_id): return ( db.session.query(page_table).filter(db.and_(page_table.book_id == book_id, page_table.page_id == page_id)).all() )
def get_page(book_id, page_num): return db.session.query(page).filter(db.and_(page.book_id == book_id, page.page_num == str(page_num))).first()