Python update Examples

Example #1

File: crud.py Project: sthagen/python-fastapi-notary

async def put(id: int, payload: NoteSchema):
    query = (notes.update().where(id == notes.c.id).values(
        tag=payload.tag,
        topic=payload.topic,
        summary=payload.summary,
        digest=payload.digest,
        source_url=payload.source_url,
        target_url=payload.target_url,
        time_ref=payload.time_ref).returning(notes.c.id))
    return await database.execute(query=query)

Example #2

async def put(id: int, payload: NoteSchema):
    query = (notes.update().where(id == notes.c.id).values(
        title=payload.title,
        description=payload.description).returning(notes.c.id))
    return await database.execute(query=query)