Python update Exemples

Exemple #1

async def update_movie(id: int, payload: MovieIn):
    query = (movies.update().where(movies.c.id == id).values(**payload.dict()))
    return await database.execute(query=query)

Exemple #2

Fichier : db_manager.py Projet : spyro97/docker-microservices

async def update_movie(id: int, payload: MovieIn):
    query = (movies.update().where(movies.c.id == id).values(**payload.dict()))
    await database.execute(query=query)
    modified_movie = movies.select(movies.c.id == id)
    return await database.fetch_one(query=modified_movie)