Python Users.select примеры использования

Пример #1

async def get_by_username(username: str):
    query = Users.select().where(username == Users.c.username)
    return await database.fetch_one(query=query)

Пример #2

async def get_all():
    query = Users.select()
    return await database.fetch_all(query=query)

Пример #3

async def count_all():
    query = Users.select().count()
    return await database.fetch_one(query=query)

Пример #4

async def get_by_id(id: int):
    query = Users.select().where(id == Users.c.id)
    return await database.fetch_one(query=query)