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
