todo-app-api

mattnさんの記事 （技術アウトプットに自作TODOアプリ） を読んで，TODOアプリを作ってみた．

Tech Stack

• Rust (programming language)
• Actix Web (api framework)
• mold (a fast linker)
• Diesel (or mapper)
• MySQL (rdbms)

API (CRUD)

• GET /
  • args: None
  • returns: index page
• GET /tasks
  • args: None
  • returns: Vec<Task>
• POST /tasks
  • args: NewTask
  • returns: Task
• PUT /tasks/{id}
  • args: id, NewTask
  • returns: Task
• DELETE /tasks/{id}
  • args: id
  • returns: None

// src/models.rs
struct Task {
  id: i32,
  title: String,
  description: Option<String>,
  due_date: Option<chrono::NaiveDateTime>,
  is_done: bool,
}
struct NewTask {
  title: String,
  description: Option<String>,
  due_date: Option<chrono::NaiveDateTime>,
  is_done: bool,
}

LOG

# compile mold linker (aproox. 30 min.)
git clone --branch stable https://github.com/rui314/mold.git
cd mold
./install-build-deps.sh
cmake -DCMAKE_BUILD_TYPE=Release -DCMAKE_CXX_COMPILER=c++ -B build
cmake --build build -j$(nproc)
sudo cmake --build build --target install

cargo new todo-app-api
rustc --version
rustup toolchain list
rustup toolchain add 1.80.0  # diesel_cli requires rustc 1.78.0 or newer
# edit rust-toolchain.toml
# edit Cargo.toml
cargo install cargo-watch
# mold -run ...
# cargo watch -x ...
# cargo run
mold -run cargo watch -x run
mold -run cargo run --bin get_tasks
# test
curl -X GET http://localhost:8080/
# also, use Postman
cargo clean

sudo apt update
sudo apt install libmysqlclient-dev
sudo mysql -u root
mysql> select user, host, plugin from mysql.user;
mysql> update mysql.user set plugin = 'caching_sha2_password' where user = 'root';
mysql> FLUSH PRIVILEGES;
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password';
mysql> FLUSH PRIVILEGES;
mysql> quit;

# mysql -u <user> -p<password>
mysql -u root -ppassword
mysql> show databases;
mysql> show tables from todoapp_db;
mysql> show columns from tasks from todoapp_db;
mysql> use todoapp_db;
mysql> select * from tasks;
mysql> truncate table tasks; # reset

cargo install diesel_cli --no-default-features --features mysql
# edit .env (DATABASE_URL)
diesel setup
diesel migration generate create_tasks_table
# edit up.sql and down.sql
diesel migration run  # generate src/schema.rs
diesel print-schema
diesel migration redo

References

• official
  • https://github.com/rui314/mold
  • https://github.com/actix/actix-web
  • https://github.com/diesel-rs/diesel
    • CLI: https://github.com/diesel-rs/diesel/tree/master/diesel_cli
    • diesel + mysql sample (CRUD): https://github.com/diesel-rs/diesel/tree/2.2.x/examples/mysql/getting_started_step_3/src/bin
  • https://actix.rs/docs/getting-started
  • https://docs.rs/actix-web/latest/actix_web/
  • https://docs.rs/actix-cors/latest/actix_cors/
  • https://docs.rs/diesel/latest/diesel/
    • Create: https://docs.rs/diesel/latest/diesel/fn.insert_into.html
    • Read (one): https://docs.rs/diesel/latest/diesel/query_dsl/trait.QueryDsl.html#method.select
    • Read (all): https://docs.rs/diesel/latest/diesel/prelude/trait.RunQueryDsl.html#method.load
    • Update: https://docs.rs/diesel/latest/diesel/fn.update.html
    • Delete: https://docs.rs/diesel/latest/diesel/fn.delete.html
    • pool (r2d2): https://docs.rs/diesel/latest/diesel/r2d2/index.html
  • https://www.postman.com/
• overall
  • why TODO App: https://levtech.jp/media/article/column/detail_473/
  • https://github.com/flosse/rust-web-framework-comparison#server-frameworks
  • https://github.com/nemesiscodex/actix-todo
  • https://github.com/tetter27/webapi_mvp
  • https://ozway.jp/2020/10/rust-mysql-diesel%EF%BC%881%EF%BC%89/
  • https://synamon.hatenablog.com/entry/actix_web_api
  • https://github.com/krocks96/rust-backend-playground
  • https://youtu.be/4Q7FAMydzOU?si=EjewNYm9KgkIWMfo
• spot
  • MySQL setup error: https://redj.hatenablog.com/entry/2023/04/09/012242
• ChatGPT-4o
• GitHub Copilot