def find_profile_by_userid(session, userid):
user = session.query(UserSchema).filter(UserSchema.id == userid).first()
if user is None:
raise ElementNotExistsError('user', id=userid)
if user.cti_profile_id is None:
return None
row = session.query(CtiProfileSchema).filter(CtiProfileSchema.id == user.cti_profile_id).first()
return cti_profile_db_converter.to_model(row)
def find_profile_by_userid(session, userid):
user = session.query(UserSchema).filter(UserSchema.id == userid).first()
if user is None:
raise errors.not_found('User', id=userid)
if user.cti_profile_id is None:
return None
row = session.query(CtiProfileSchema).filter(CtiProfileSchema.id == user.cti_profile_id).first()
return cti_profile_db_converter.to_model(row)
def get(session, profile_id):
row = session.query(CtiProfile).filter(CtiProfile.id == profile_id).first()
if row is None:
raise ElementNotExistsError('cti_profile')
return db_converter.to_model(row)
def find_all(session):
rows = session.query(CtiProfile).all()
return [db_converter.to_model(row) for row in rows]
def get(session, profile_id):
row = session.query(CtiProfile).filter(CtiProfile.id == profile_id).first()
if row is None:
raise errors.not_found('CtiProfile', id=profile_id)
return db_converter.to_model(row)
