def get_user_by_token(self, token): """ Get user object from the database, based on the his token. :param token: passed token as a dictionary object. """ user_id = token['user_id'] try: user_row = self.db_manager.execute_sql(SQL_USER_GET, (user_id, )).fetchone() if user_row: user_data = convert_user_raw_data_to_dict(user_row) else: user_data = {} except OperationalError as exc: logger.error(exc) user_data = {} return User(**user_data)
def get_user_by_token(self, token): """Get user object from the database, based on the his token. :param token: passed token as a dictionary object. """ user_id = token['user_id'] try: user_row = self.db_manager.execute_sql( SQL_USER_GET, (user_id, ) ).fetchone() if user_row: user_data = convert_user_raw_data_to_dict(user_row) else: user_data = {} except OperationalError as exc: logger.error(exc) user_data = {} return User(**user_data)
def get_user_by_username(self, username, with_id=False): """ Get user by his username from the database. :param username: username as a string. :param with_id: boolean flag, which means necessity to append to the result object primary key of database row or not. """ try: if with_id: sql = SQL_USER_GET_WITH_ID else: sql = SQL_USER_GET_BY_USERNAME user_row = self.db_manager.execute_sql(sql, (username, )).fetchone() # NOQA if user_row: user_data = convert_user_raw_data_to_dict(user_row, with_id) else: user_data = {} except OperationalError as exc: logger.error(exc) user_data = {} return User(**user_data)
def get_user_by_username(self, username, with_id=False): """ Get user by his username from the database. :param username: username as a string. :param with_id: boolean flag, which means necessity to append to the result object primary key of database row or not. """ try: if with_id: sql = SQL_USER_GET_WITH_ID else: sql = SQL_USER_GET_BY_USERNAME user_row = self.db_manager.execute_sql( sql, (username, )).fetchone() # NOQA if user_row: user_data = convert_user_raw_data_to_dict(user_row, with_id) else: user_data = {} except OperationalError as exc: logger.error(exc) user_data = {} return User(**user_data)