Rust axum + SQLite 試すメモ

[package]
name = "routes_example"
version = "0.1.0"
edition = "2024"

[dependencies]
axum = "0.7.5"
tokio = { version = "1.0", features = ["full"] }
sqlx = { version = "0.8", features = ["runtime-tokio-rustls", "sqlite", "chrono"] }
serde = { version = "1.0", features = ["derive"] }
serde_json = "1.0"
chrono = { version = "0.4", features = ["serde"] }

cargo build
cargo new

    let app = Router::new()
        .route("/", get(root))
        .route("/list", get(list_todos))
        .route("/create", post(create_todo))
        .route("/delete", post(delete_todo))
        .route("/update", post(update_todo))
        .with_state(app_state);

CREATE TABLE todos (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  title TEXT NOT NULL,
  content TEXT,
  created_at TEXT,
  updated_at TEXT
);