class TodoDB:
@staticmethod
async def get_todos(db):
query = """
SELECT id, user_id, text
FROM todos;
"""
results = await db.prepare(query).all()
return results.results
@app.get("/todos")
async def get_todos(request: Request):
results = await TodoDB.get_todos(request.scope["env"].DB)
return Response.json(results)
class TodoDB:
@staticmethod
async def get_todos(db):
query = """
SELECT id, user_id, text
FROM todos;
"""
results = await db.prepare(query).all()
return results.results
@app.get("/todos")
async def get_todos(request: Request):
results = await TodoDB.get_todos(request.scope["env"].DB)
return Response.json(results)