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 {
GenerateKeys {
#[arg(long, default_value = ".")]
output_dir: PathBuf,
#[arg(long, default_value = "oauth")]
name: String,
},
Install {
#[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);
"#;