def find_all_by_line_id(session, line_id): query = (session.query( UserLineSchema.line_id, UserLineSchema.extension_id).filter( UserLineSchema.line_id == line_id).filter( UserLineSchema.extension_id != None).distinct()) return [db_converter.to_model(row) for row in query]
def find_all_by_line_id(session, line_id): query = (session.query(UserLineSchema.line_id, UserLineSchema.extension_id) .filter(UserLineSchema.line_id == line_id) .filter(UserLineSchema.extension_id != None) .distinct()) return [db_converter.to_model(row) for row in query]
def find_by_extension_id(session, extension_id): user_line_row = (session.query(UserLineSchema).filter( UserLineSchema.extension_id == extension_id).first()) if not user_line_row: return None return db_converter.to_model(user_line_row)
def find_by_extension_id(session, extension_id): user_line_row = (session.query(UserLineSchema) .filter(UserLineSchema.extension_id == extension_id) .first()) if not user_line_row: return None return db_converter.to_model(user_line_row)
def find_all_line_extensions_by_line_id(session, line_id): query = (session.query(UserLine.line_id, Extension.id.label('extension_id')) .join(Dialaction, and_(Dialaction.action == 'user', cast(Dialaction.actionarg1, Integer) == UserLine.user_id, UserLine.main_line == True)) .join(Incall, and_(Dialaction.category == 'incall', cast(Dialaction.categoryval, Integer) == Incall.id)) .join(Extension, and_(Incall.exten == Extension.exten, Incall.context == Extension.context)) .filter(UserLine.line_id == line_id)) return [line_extension_db_converter.to_model(row) for row in query]
def find_all_line_extensions_by_line_id(session, line_id): query = (session.query( UserLine.line_id, Extension.id.label('extension_id')).join( Dialaction, and_(Dialaction.action == 'user', cast(Dialaction.actionarg1, Integer) == UserLine.user_id, UserLine.main_line == True)).join( Incall, and_(Dialaction.category == 'incall', cast(Dialaction.categoryval, Integer) == Incall.id)).join( Extension, and_(Incall.exten == Extension.exten, Incall.context == Extension.context)). filter(UserLine.line_id == line_id)) return [line_extension_db_converter.to_model(row) for row in query]
def find_line_extension_by_extension_id(session, extension_id): query = (session.query(UserLine.line_id, Extension.id.label('extension_id')) .join(Dialaction, and_(Dialaction.action == 'user', cast(Dialaction.actionarg1, Integer) == UserLine.user_id, UserLine.main_line == True)) .join(Incall, and_(Dialaction.category == 'incall', cast(Dialaction.categoryval, Integer) == Incall.id)) .join(Extension, and_(Incall.exten == Extension.exten, Incall.context == Extension.context)) .filter(Extension.id == extension_id)) row = query.first() if not row: return None return line_extension_db_converter.to_model(row)
def find_line_extension_by_extension_id(session, extension_id): query = (session.query( UserLine.line_id, Extension.id.label('extension_id')).join( Dialaction, and_(Dialaction.action == 'user', cast(Dialaction.actionarg1, Integer) == UserLine.user_id, UserLine.main_line == True)).join( Incall, and_(Dialaction.category == 'incall', cast(Dialaction.categoryval, Integer) == Incall.id)).join( Extension, and_(Incall.exten == Extension.exten, Incall.context == Extension.context)). filter(Extension.id == extension_id)) row = query.first() if not row: return None return line_extension_db_converter.to_model(row)