Type-Safe PostgreSQL ORM & Desktop Studio for Rust

mod liteorm;
use lite_orm::{Database, Model};
use liteorm::{User, Post};

#[tokio::main]
async fn main() -> Result<(), Box<dyn std::error::Error>> {
    let db = Database::connect_env().await?;

    // Type-safe SELECT with parameterized WHERE
    let active_users = db
        .all(User::select()
            .where_(User::ACTIVE.equals(true))
            .limit(20))
        .await?;

    // Safe deletion guarded against unconstrained drops
    db.delete(Post::delete().where_(Post::USER_ID.equals(12))).await?;

    Ok(())
}

-- Transactional, idempotent PostgreSQL migration
BEGIN;

CREATE TABLE "User" (
  "id" SERIAL PRIMARY KEY,
  "email" TEXT NOT NULL UNIQUE,
  "name" TEXT NOT NULL,
  "active" BOOLEAN NOT NULL DEFAULT true,
  "created_at" TIMESTAMPTZ NOT NULL DEFAULT now()
);

CREATE TABLE "Post" (
  "id" SERIAL PRIMARY KEY,
  "title" TEXT NOT NULL,
  "content" TEXT,
  "user_id" INTEGER NOT NULL REFERENCES "User"("id")
);

COMMIT;