Esempi in Python per select

Esempio n. 1

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

Esempio n. 2

File: main.py Progetto: mrchoke/ui-api-datatype-exmaple

async def read_notes(showCompleted: Optional[bool] = False):
    '''Get Note'''
    query = notes.select()
    if not showCompleted:
        query = query.where(notes.c.completed == False)
    return await database.fetch_all(query)

Esempio n. 3

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

Esempio n. 4

File: main.py Progetto: tsadimas/fastapi_lab_project

async def read_notes(token: str = Depends(oauth2_scheme)):
    query = notes.select()
    return await database.fetch_all(query)