await server.get("/status") { _ in
    .json(["status": "ok", "version": "1.0"])
}

struct UserResponse: Codable {
    let id: Int
    let name: String
    let email: String
}

await server.get("/users/:id") { request in
    let user = UserResponse(id: 1, name: "Alice", email: "alice@example.com")
    return .json(user)
}

struct CreateUser: Decodable {
    let name: String
    let email: String
    let password: String
}

await server.post("/users") { request in
    let input: CreateUser = try request.decodeJSON()
    // input.name, input.email, input.password are now available
    return .json(["id": 1], status: .created)
}

struct Todo: Codable {
    let id: Int
    let title: String
    let completed: Bool
}

struct CreateTodo: Decodable {
    let title: String
}

struct UpdateTodo: Decodable {
    let title: String?
    let completed: Bool?
}

await server.get("/todos") { _ in
    let todos = try await db.query("SELECT * FROM todos")
    return .json(todos.map { row in
        Todo(
            id: row["id"]?.intValue ?? 0,
            title: row["title"]?.textValue ?? "",
            completed: row["completed"]?.intValue == 1
        )
    })
}

await server.post("/todos") { request in
    let input: CreateTodo = try request.decodeJSON()
    try await db.execute(
        "INSERT INTO todos (title, completed) VALUES (?, 0)",
        parameters: [.text(input.title)]
    )
    return .json(["id": await db.lastInsertID], status: .created)
}

await server.patch("/todos/:id") { request in
    let id = request.parameters["id"]!
    let input: UpdateTodo = try request.decodeJSON()

    if let title = input.title {
        try await db.execute("UPDATE todos SET title = ? WHERE id = ?",
            parameters: [.text(title), .text(id)])
    }
    if let completed = input.completed {
        try await db.execute("UPDATE todos SET completed = ? WHERE id = ?",
            parameters: [.integer(completed ? 1 : 0), .text(id)])
    }

    return .json(["status": "updated"])
}

let encoder = JSONEncoder()
encoder.dateEncodingStrategy = .iso8601
encoder.outputFormatting = .prettyPrinted

return .json(user, encoder: encoder)