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)