if not todo:
return request.Response(404, json={})
todo = {"id": todo[0], "todo": todo[1]}
db.close()
return request.Response(json=todo)
def delete_todo(request):
db = db_connect()
cur = db.cursor()
id = int(request.match_dict['id'])
cur.execute("""DELETE FROM todos WHERE id = ?""", (id,))
if not cur.rowcount:
return request.Response(404, json={})
db.commit()
db.close()
return request.Response(json={})
if __name__ == '__main__':
maybe_create_schema()
app = Application()
router = app.get_router()
router.add_route('/todos', list_todos, method='GET')
router.add_route('/todos/{id}', show_todo, method='GET')
router.add_route('/todos/{id}', delete_todo, method='DELETE')
router.add_route('/todos', add_todo, method='POST')
app.serve()
