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 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_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)