from sqlalchemy import text


def find_user(cursor, user_id):
    cursor.execute("SELECT * FROM users WHERE id = %s", (user_id,))
    return cursor.fetchone()


def find_by_name(connection, name):
    return connection.execute(text("SELECT * FROM users WHERE name = :name"), {"name": name})


def count(cursor):
    cursor.execute("SELECT count(*) "
                   "FROM users")
    return cursor.fetchone()
