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)
