boxdb 0.3.2

use boxdb::{
    Database, Error, Format, QueryResult, Result, SchemaFormat,
    migrations::{MigrationSet, MigrationState},
};
use clap::{Parser, Subcommand};
use std::{
    io::{self, BufRead, IsTerminal, Write},
    path::PathBuf,
};

#[derive(Parser)]
#[command(
    name = "boxdb",
    version,
    about = "Extended SQLite client with typed columns and readable YAML stream storage",
    subcommand_precedence_over_arg = true,
    args_conflicts_with_subcommands = true
)]
struct Cli {
    #[command(subcommand)]
    command: Option<Command>,
    /// Database file, or :memory: (the default).
    database: Option<PathBuf>,
    /// Format for a new file; existing files are detected automatically.
    #[arg(long, value_enum, default_value = "binary")]
    format: Format,
    /// Execute SQL and exit.
    #[arg(short = 'e', long)]
    execute: Option<String>,
    /// Emit one typed JSON result per query.
    #[arg(long)]
    json: bool,
}
#[derive(Subcommand)]
enum Command {
    /// Inspect and export database schemas.
    Schema {
        #[command(subcommand)]
        command: SchemaCommand,
    },
    /// Create and apply versioned SQL migrations.
    Migrate {
        #[command(subcommand)]
        command: MigrationCommand,
    },
    /// Copy a database into a different storage format. Destination must be new.
    Convert {
        source: PathBuf,
        destination: PathBuf,
        #[arg(long, value_enum)]
        format: Format,
    },
}
#[derive(Subcommand)]
enum SchemaCommand {
    /// Export user schema without internal tables or application rows.
    Dump {
        database: PathBuf,
        #[arg(long, value_enum, default_value = "sql")]
        format: SchemaFormat,
    },
}
#[derive(Subcommand)]
enum MigrationCommand {
    /// Create a VERSION_NAME.sql template without opening a database.
    New {
        name: String,
        #[arg(long, default_value = "db/migrations")]
        dir: PathBuf,
    },
    /// List applied and pending migrations without changing the database.
    Status {
        database: PathBuf,
        #[arg(long, default_value = "db/migrations")]
        dir: PathBuf,
        #[arg(long)]
        json: bool,
        /// Exit with status 1 if migrations are pending.
        #[arg(long)]
        check: bool,
    },
    /// Roll back the latest applied migration. The database must exist.
    Down {
        database: PathBuf,
        #[arg(long, default_value = "db/migrations")]
        dir: PathBuf,
        #[arg(long)]
        json: bool,
    },
    /// Apply all pending migrations, creating the database if necessary.
    Up {
        database: PathBuf,
        #[arg(long, default_value = "db/migrations")]
        dir: PathBuf,
        #[arg(long, value_enum, default_value = "binary")]
        format: Format,
        #[arg(long)]
        json: bool,
    },
}
fn main() {
    if let Err(error) = run(Cli::parse()) {
        eprintln!("boxdb: {error}");
        std::process::exit(1);
    }
}
fn run(cli: Cli) -> Result<()> {
    if let Some(command) = cli.command {
        return match command {
            Command::Schema {
                command: SchemaCommand::Dump { database, format },
            } => {
                io::stdout()
                    .lock()
                    .write_all(&Database::dump_schema_file(database, format)?)?;
                Ok(())
            }
            Command::Migrate {
                command: MigrationCommand::New { name, dir },
            } => {
                println!("{}", MigrationSet::create(dir, &name)?.display());
                Ok(())
            }
            Command::Migrate {
                command:
                    MigrationCommand::Status {
                        database,
                        dir,
                        json,
                        check,
                    },
            } => {
                let statuses = MigrationSet::read(dir)?.status_file(database)?;
                if json {
                    println!("{}", serde_json::to_string(&statuses)?);
                } else {
                    println!("VERSION\tNAME\tSTATE");
                    for status in &statuses {
                        println!(
                            "{}\t{}\t{}",
                            status.migration.version,
                            status.migration.name,
                            if status.state == MigrationState::Applied {
                                "applied"
                            } else {
                                "pending"
                            }
                        );
                    }
                    let applied = statuses
                        .iter()
                        .filter(|s| s.state == MigrationState::Applied)
                        .count();
                    println!("\n{applied} applied, {} pending", statuses.len() - applied);
                }
                if check && statuses.iter().any(|s| s.state == MigrationState::Pending) {
                    return Err(Error::new("pending migrations".into()));
                }
                Ok(())
            }
            Command::Migrate {
                command:
                    MigrationCommand::Down {
                        database,
                        dir,
                        json,
                    },
            } => {
                if !database.is_file() {
                    return Err(Error::new("database not found".into()));
                }
                let migrations = MigrationSet::read(dir)?;
                let mut db = Database::open(database, Format::Binary)?;
                let reverted: Vec<_> = migrations.down(&mut db)?.into_iter().collect();
                if json {
                    println!("{}", serde_json::to_string(&reverted)?);
                } else {
                    for migration in reverted {
                        println!("Reverted {} {}", migration.version, migration.name);
                    }
                }
                Ok(())
            }
            Command::Migrate {
                command:
                    MigrationCommand::Up {
                        database,
                        dir,
                        format,
                        json,
                    },
            } => {
                let migrations = MigrationSet::read(dir)?;
                let mut db = Database::open(database, format)?;
                let applied = migrations.up(&mut db)?;
                if json {
                    println!("{}", serde_json::to_string(&applied)?);
                } else {
                    for migration in applied {
                        println!("Applied {} {}", migration.version, migration.name);
                    }
                }
                Ok(())
            }
            Command::Convert {
                source,
                destination,
                format,
            } => {
                if !source.is_file() {
                    return Err(Error::new("source database not found".into()));
                }
                Database::convert(source, destination, format)?;
                Ok(())
            }
        };
    }
    let path = cli.database.unwrap_or_else(|| PathBuf::from(":memory:"));
    let mut db = if path.to_str() == Some(":memory:") {
        Database::memory()
    } else {
        Database::open(path, cli.format)?
    };
    if let Some(sql) = cli.execute {
        return execute(&mut db, &sql, cli.json);
    }
    let interactive = io::stdin().is_terminal();
    let mut pending = String::new();
    let stdin = io::stdin();
    let mut input = stdin.lock();
    loop {
        if interactive {
            print!(
                "{}",
                if pending.is_empty() {
                    "boxdb> "
                } else {
                    "   ...> "
                }
            );
            io::stdout().flush().map_err(Error::from)?;
        }
        let mut line = String::new();
        if input.read_line(&mut line).map_err(Error::from)? == 0 {
            break;
        }
        if pending.is_empty() && line.trim_start().starts_with('.') {
            match line.trim() {
                ".quit" | ".exit" => break,
                ".help" => println!(
                    ".tables  .schema  .format  .help  .quit\nTerminate SQL statements with a semicolon."
                ),
                ".format" => println!("{:?}", db.format()),
                ".tables" => execute(
                    &mut db,
                    "SELECT name FROM sqlite_schema WHERE type='table' AND name NOT GLOB '__boxdb_*' AND name NOT LIKE 'sqlite_%' ORDER BY name",
                    cli.json,
                )?,
                ".schema" => execute(
                    &mut db,
                    "SELECT sql FROM sqlite_schema ORDER BY type,name",
                    cli.json,
                )?,
                _ if interactive => eprintln!("unknown command; use .help"),
                _ => return Err(Error::new("unknown shell command".into())),
            }
            continue;
        }
        pending.push_str(&line);
        if complete(&pending) {
            if let Err(e) = execute(&mut db, &pending, cli.json) {
                if interactive {
                    eprintln!("boxdb: {e}");
                } else {
                    return Err(e);
                }
            }
            pending.clear();
        }
    }
    if !pending.trim().is_empty() {
        execute(&mut db, &pending, cli.json)?;
    }
    Ok(())
}
fn complete(sql: &str) -> bool {
    let Ok(sql) = std::ffi::CString::new(sql) else {
        return false;
    };
    // SAFETY: CString remains alive and provides a NUL-terminated SQL string.
    unsafe { rusqlite::ffi::sqlite3_complete(sql.as_ptr()) != 0 }
}
fn execute(db: &mut Database, sql: &str, json: bool) -> Result<()> {
    for result in db.execute(sql)? {
        print_result(&result, json)?;
    }
    Ok(())
}
fn print_result(result: &QueryResult, json: bool) -> Result<()> {
    if result.columns.is_empty() {
        return Ok(());
    }
    if json {
        println!("{}", serde_json::to_string(result).map_err(Error::from)?);
    } else {
        println!("{}", result.columns.join("\t"));
        for row in &result.rows {
            println!(
                "{}",
                row.iter()
                    .map(|v| v
                        .to_string()
                        .replace('\\', "\\\\")
                        .replace('\t', "\\t")
                        .replace('\n', "\\n"))
                    .collect::<Vec<_>>()
                    .join("\t")
            );
        }
    }
    Ok(())
}