def get_all(cursor): sql = "SELECT id, username, email, hashed_password FROM users" ret = [] cursor.execute(sql) for row in cursor.fetchall(): loaded_user = User() loaded_user._id = row[0] loaded_user.username = row[1] loaded_user.email = row[2] loaded_user._hashed_password = row[3] ret.append(loaded_user) return ret
def find_by_email(cursor, email): sql = "SELECT id, username, email, hashed_password FROM users WHERE email=%s" cursor.execute(sql, (email, )) data = cursor.fetchone() if data: loaded_user = User() loaded_user._id = data[0] loaded_user.username = data[1] loaded_user.email = data[2] loaded_user._hashed_password = data[3] return loaded_user else: return None