async def get_all_movies():
query = movies.select()
return await database.fetch_all(query=query)
async def get_movie(id):
query = movies.select(movies.c.id == id)
return await database.fetch_one(query=query)
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)
