rustbasic-passport 0.1.1

OAuth2 server and personal access tokens for Rust applications, a port of laravel/passport for the RustBasic ecosystem.
Documentation
use std::fs;
use std::path::PathBuf;

use clap::{Parser, Subcommand};

use rustbasic_passport::jwt::SigningKey;

#[derive(Parser)]
#[command(
    name = "rustbasic-passport",
    about = "Helpers for the rustbasic-passport OAuth2 server",
    version
)]
struct Cli {
    #[command(subcommand)]
    command: Command,
}

#[derive(Subcommand)]
enum Command {
    /// Generate an RSA key pair, like `php artisan passport:keys`
    GenerateKeys {
        /// Directory where the keys are written
        #[arg(long, default_value = ".")]
        output_dir: PathBuf,
        /// Base name of the key files
        #[arg(long, default_value = "oauth")]
        name: String,
    },
    /// Print the SQL schema for the OAuth tables
    Install {
        /// Database dialect: sqlite, postgres or mysql
        #[arg(long, default_value = "sqlite")]
        database: String,
    },
}

fn main() -> Result<(), Box<dyn std::error::Error>> {
    let cli = Cli::parse();
    match cli.command {
        Command::GenerateKeys { output_dir, name } => {
            let key = SigningKey::generate("default")?;
            let private_path = output_dir.join(format!("{name}-private.key"));
            let public_path = output_dir.join(format!("{name}-public.key"));
            fs::write(&private_path, &key.private_pem)?;
            fs::write(&public_path, &key.public_pem)?;
            println!(
                "Encryption keys generated successfully: {} and {}",
                private_path.display(),
                public_path.display()
            );
        }
        Command::Install { database } => {
            print!("{}", schema_for(&database));
        }
    }
    Ok(())
}

fn schema_for(database: &str) -> &'static str {
    match database.to_ascii_lowercase().as_str() {
        "postgres" => POSTGRES_SQL,
        "mysql" => MYSQL_SQL,
        _ => SQLITE_SQL,
    }
}

const SQLITE_SQL: &str = r#"-- oauth_clients
CREATE TABLE oauth_clients (
    id VARCHAR(64) PRIMARY KEY NOT NULL,
    owner_type VARCHAR(255),
    owner_id VARCHAR(64),
    name VARCHAR(255) NOT NULL,
    secret VARCHAR(255),
    provider VARCHAR(255),
    redirect_uris TEXT,
    grant_types TEXT,
    revoked BOOLEAN NOT NULL DEFAULT 0,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
);
CREATE INDEX idx_oauth_clients_owner ON oauth_clients(owner_type, owner_id);

-- oauth_auth_codes
CREATE TABLE oauth_auth_codes (
    id VARCHAR(100) PRIMARY KEY NOT NULL,
    user_id VARCHAR(64),
    client_id VARCHAR(64) NOT NULL,
    scopes TEXT,
    revoked BOOLEAN NOT NULL DEFAULT 0,
    expires_at DATETIME
);

-- oauth_access_tokens
CREATE TABLE oauth_access_tokens (
    id VARCHAR(100) PRIMARY KEY NOT NULL,
    user_id VARCHAR(64),
    client_id VARCHAR(64) NOT NULL,
    name VARCHAR(255),
    scopes TEXT,
    revoked BOOLEAN NOT NULL DEFAULT 0,
    expires_at DATETIME,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
);
CREATE INDEX idx_oauth_access_tokens_user_id ON oauth_access_tokens(user_id);

-- oauth_refresh_tokens
CREATE TABLE oauth_refresh_tokens (
    id VARCHAR(100) PRIMARY KEY NOT NULL,
    client_id VARCHAR(64) NOT NULL,
    access_token_id VARCHAR(100) NOT NULL,
    revoked BOOLEAN NOT NULL DEFAULT 0,
    expires_at DATETIME
);
CREATE INDEX idx_oauth_refresh_tokens_access_token_id ON oauth_refresh_tokens(access_token_id);
CREATE INDEX idx_oauth_refresh_tokens_client_id ON oauth_refresh_tokens(client_id);

-- oauth_device_codes
CREATE TABLE oauth_device_codes (
    id VARCHAR(80) PRIMARY KEY NOT NULL,
    user_id VARCHAR(64),
    client_id VARCHAR(64) NOT NULL,
    user_code VARCHAR(8) NOT NULL,
    scopes TEXT,
    revoked BOOLEAN NOT NULL DEFAULT 0,
    user_approved_at DATETIME,
    last_polled_at DATETIME,
    expires_at DATETIME
);
CREATE UNIQUE INDEX idx_oauth_device_codes_user_code ON oauth_device_codes(user_code);
CREATE INDEX idx_oauth_device_codes_client_id ON oauth_device_codes(client_id);
CREATE INDEX idx_oauth_device_codes_user_id ON oauth_device_codes(user_id);
"#;

const POSTGRES_SQL: &str = r#"-- oauth_clients
CREATE TABLE oauth_clients (
    id VARCHAR(64) PRIMARY KEY,
    owner_type VARCHAR(255),
    owner_id VARCHAR(64),
    name VARCHAR(255) NOT NULL,
    secret VARCHAR(255),
    provider VARCHAR(255),
    redirect_uris TEXT,
    grant_types TEXT,
    revoked BOOLEAN NOT NULL DEFAULT FALSE,
    created_at TIMESTAMP NOT NULL DEFAULT NOW(),
    updated_at TIMESTAMP NOT NULL DEFAULT NOW()
);
CREATE INDEX idx_oauth_clients_owner ON oauth_clients(owner_type, owner_id);

-- oauth_auth_codes
CREATE TABLE oauth_auth_codes (
    id VARCHAR(100) PRIMARY KEY,
    user_id VARCHAR(64),
    client_id VARCHAR(64) NOT NULL,
    scopes TEXT,
    revoked BOOLEAN NOT NULL DEFAULT FALSE,
    expires_at TIMESTAMP
);

-- oauth_access_tokens
CREATE TABLE oauth_access_tokens (
    id VARCHAR(100) PRIMARY KEY,
    user_id VARCHAR(64),
    client_id VARCHAR(64) NOT NULL,
    name VARCHAR(255),
    scopes TEXT,
    revoked BOOLEAN NOT NULL DEFAULT FALSE,
    expires_at TIMESTAMP,
    created_at TIMESTAMP NOT NULL DEFAULT NOW(),
    updated_at TIMESTAMP NOT NULL DEFAULT NOW()
);
CREATE INDEX idx_oauth_access_tokens_user_id ON oauth_access_tokens(user_id);

-- oauth_refresh_tokens
CREATE TABLE oauth_refresh_tokens (
    id VARCHAR(100) PRIMARY KEY,
    client_id VARCHAR(64) NOT NULL,
    access_token_id VARCHAR(100) NOT NULL,
    revoked BOOLEAN NOT NULL DEFAULT FALSE,
    expires_at TIMESTAMP
);
CREATE INDEX idx_oauth_refresh_tokens_access_token_id ON oauth_refresh_tokens(access_token_id);
CREATE INDEX idx_oauth_refresh_tokens_client_id ON oauth_refresh_tokens(client_id);

-- oauth_device_codes
CREATE TABLE oauth_device_codes (
    id VARCHAR(80) PRIMARY KEY,
    user_id VARCHAR(64),
    client_id VARCHAR(64) NOT NULL,
    user_code VARCHAR(8) NOT NULL,
    scopes TEXT,
    revoked BOOLEAN NOT NULL DEFAULT FALSE,
    user_approved_at TIMESTAMP,
    last_polled_at TIMESTAMP,
    expires_at TIMESTAMP
);
CREATE UNIQUE INDEX idx_oauth_device_codes_user_code ON oauth_device_codes(user_code);
CREATE INDEX idx_oauth_device_codes_client_id ON oauth_device_codes(client_id);
CREATE INDEX idx_oauth_device_codes_user_id ON oauth_device_codes(user_id);
"#;

const MYSQL_SQL: &str = r#"-- oauth_clients
CREATE TABLE oauth_clients (
    id VARCHAR(64) PRIMARY KEY,
    owner_type VARCHAR(255) NULL,
    owner_id VARCHAR(64) NULL,
    name VARCHAR(255) NOT NULL,
    secret VARCHAR(255) NULL,
    provider VARCHAR(255) NULL,
    redirect_uris TEXT NULL,
    grant_types TEXT NULL,
    revoked TINYINT(1) NOT NULL DEFAULT 0,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE INDEX idx_oauth_clients_owner ON oauth_clients(owner_type, owner_id);

-- oauth_auth_codes
CREATE TABLE oauth_auth_codes (
    id VARCHAR(100) PRIMARY KEY,
    user_id VARCHAR(64) NULL,
    client_id VARCHAR(64) NOT NULL,
    scopes TEXT NULL,
    revoked TINYINT(1) NOT NULL DEFAULT 0,
    expires_at DATETIME NULL
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- oauth_access_tokens
CREATE TABLE oauth_access_tokens (
    id VARCHAR(100) PRIMARY KEY,
    user_id VARCHAR(64) NULL,
    client_id VARCHAR(64) NOT NULL,
    name VARCHAR(255) NULL,
    scopes TEXT NULL,
    revoked TINYINT(1) NOT NULL DEFAULT 0,
    expires_at DATETIME NULL,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE INDEX idx_oauth_access_tokens_user_id ON oauth_access_tokens(user_id);

-- oauth_refresh_tokens
CREATE TABLE oauth_refresh_tokens (
    id VARCHAR(100) PRIMARY KEY,
    client_id VARCHAR(64) NOT NULL,
    access_token_id VARCHAR(100) NOT NULL,
    revoked TINYINT(1) NOT NULL DEFAULT 0,
    expires_at DATETIME NULL
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE INDEX idx_oauth_refresh_tokens_access_token_id ON oauth_refresh_tokens(access_token_id);
CREATE INDEX idx_oauth_refresh_tokens_client_id ON oauth_refresh_tokens(client_id);

-- oauth_device_codes
CREATE TABLE oauth_device_codes (
    id VARCHAR(80) PRIMARY KEY,
    user_id VARCHAR(64) NULL,
    client_id VARCHAR(64) NOT NULL,
    user_code VARCHAR(8) NOT NULL,
    scopes TEXT NULL,
    revoked TINYINT(1) NOT NULL DEFAULT 0,
    user_approved_at DATETIME NULL,
    last_polled_at DATETIME NULL,
    expires_at DATETIME NULL
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE UNIQUE INDEX idx_oauth_device_codes_user_code ON oauth_device_codes(user_code);
CREATE INDEX idx_oauth_device_codes_client_id ON oauth_device_codes(client_id);
CREATE INDEX idx_oauth_device_codes_user_id ON oauth_device_codes(user_id);
"#;