def find_by_user_id(session, user_id):
row = _fetch_by_user_id(session, user_id)
if not row:
return None
if row.voicemail_id is None or row.voicemail_id == 0:
return None
return db_converter.to_model(row)
def get_by_user_id(session, user_id):
row = _fetch_by_user_id(session, user_id)
if not row:
raise ElementNotExistsError('User', id=user_id)
if row.voicemail_id is None or row.voicemail_id == 0:
raise UserVoicemailNotExistsError.from_user_id(user_id)
return db_converter.to_model(row)
def get_by_user_id(session, user_id):
row = _fetch_by_user_id(session, user_id)
if not row:
raise errors.not_found('User', id=user_id)
if row.voicemail_id is None or row.voicemail_id == 0:
raise errors.not_found('UserVoicemail', user_id=user_id)
return db_converter.to_model(row)
def get_by_user_id(session, user_id):
row = _fetch_by_user_id(session, user_id)
if not row:
raise ElementNotExistsError('User', id=user_id)
if row.voicemail_id is None or row.voicemail_id == 0:
raise UserVoicemailNotExistsError.from_user_id(user_id)
return db_converter.to_model(row)
def find_by_voicemail_id(session, voicemail_id):
row = (session.query(UserSchema.id.label('user_id'),
UserSchema.voicemailid.label('voicemail_id'),
UserSchema.enablevoicemail).filter(
UserSchema.voicemailid == voicemail_id).first())
if not row:
return None
return db_converter.to_model(row)
def find_by_user_id(session, user_id):
row = _fetch_by_user_id(session, user_id)
if not row:
return None
if row.voicemail_id is None or row.voicemail_id == 0:
return None
return db_converter.to_model(row)
def find_by_voicemail_id(session, voicemail_id):
row = (session.query(UserSchema.id.label('user_id'),
UserSchema.voicemailid.label('voicemail_id'),
UserSchema.enablevoicemail)
.filter(UserSchema.voicemailid == voicemail_id)
.first())
if not row:
return None
return db_converter.to_model(row)
