TekkenProgres

A todo API server(going to make it multithreaded) for learning tekken characters, using sqlite for database

Guide

To create our sqlite database, we need to install sqlx-cli

cargo install sqlx-cli

Create a sqlite database, name it todo.db(optional)

sqlx database create --url "sqlite:todo.db"

Creates a new todo task in migrations/-.sql

sqlx migrate add todo

Edit the sql file in migrations directory as my repository suggest

CREATE TABLE todos (
    id TEXT PRIMARY KEY,
    title TEXT NOT NULL,
    movement INTEGER,
    punishment INTEGER,
    mixup INTEGER,
    combo INTEGER
);

Runs the migrations

sqlx migrate run 

Because we already set our DATABASE_URL in root directory, now we have a todos table in todo.db.

Now we're all set for the database-side. To run the API server, simply enter below command.

cargo watch -q -c -w src/ -x run