def find_all_by_user_id(session, user_id): rows = (session.query(UserLineSchema) .filter(UserLineSchema.user_id == user_id) .all()) if not rows: return [] return [db_converter.to_model(row) for row in rows]
def find_all_by_line_id(session, line_id): rows = (session.query(UserLineSchema).filter( UserLineSchema.line_id == line_id).filter( UserLineSchema.user_id != None).all()) if not rows: return [] return [db_converter.to_model(row) for row in rows]
def find_by_user_id_and_line_id(session, user_id, line_id): row = (session.query(UserLineSchema).filter( UserLineSchema.user_id == user_id).filter( UserLineSchema.line_id == line_id).first()) if not row: return None return db_converter.to_model(row)
def find_by_user_id_and_line_id(session, user_id, line_id): row = (session.query(UserLineSchema) .filter(UserLineSchema.user_id == user_id) .filter(UserLineSchema.line_id == line_id) .first()) if not row: return None return db_converter.to_model(row)
def find_main_user_line(session, line_id): row = (session.query(UserLineSchema).filter( UserLineSchema.main_user == True).filter( UserLineSchema.line_id == line_id).filter( UserLineSchema.user_id != None).first()) if not row: return None return db_converter.to_model(row)
def find_main_user_line(session, line_id): row = (session.query(UserLineSchema) .filter(UserLineSchema.main_user == True) .filter(UserLineSchema.line_id == line_id) .filter(UserLineSchema.user_id != None) .first()) if not row: return None return db_converter.to_model(row)
def find_all_by_user_id(session, user_id): rows = (session.query(UserLineSchema).filter( UserLineSchema.user_id == user_id).all()) if not rows: return [] tmp = [] for row in rows: tmp.append(db_converter.to_model(row)) return tmp