Struct VaporDB 

pub struct VaporDB {
    pub connection: Connection,
    pub db_path: String,
    pub bookmark_manager: Option<BookmarkManager>,
    pub transaction_manager: TransactionManager,
}

A high-level API for interacting with SQLite databases through vapor-cli

This struct provides a simplified interface to vapor-cli’s functionality, making it easy to use as a library in other Rust projects.

Fields

connection: Connection

db_path: String

bookmark_manager: Option<BookmarkManager>

transaction_manager: TransactionManager

Implementations

impl VaporDB

pub fn open<P: AsRef<Path>>(db_path: P) -> Result<Self>

Create a new VaporDB instance with an existing database

pub fn create<P: AsRef<Path>>(db_path: P) -> Result<Self>

Create a new database and return a VaporDB instance

pub fn execute(&self, sql: &str) -> Result<()>

Execute a SQL query and return the result

pub fn execute_with_options( &self, sql: &str, options: &QueryOptions, ) -> Result<()>

Execute a SQL query with custom options

pub fn list_tables(&self) -> Result<Vec<String>>

List all tables in the database

pub fn show_table_schema(&self, table_name: &str) -> Result<()>

Show schema for a specific table

pub fn show_all_schemas(&self) -> Result<()>

Show all table schemas

pub fn show_database_info(&self) -> Result<()>

Show database information

pub fn export_to_csv(&self, table_name: &str, file_path: &str) -> Result<()>

Export a table to CSV

pub fn export_query_to_csv(&self, query: &str, file_path: &str) -> Result<()>

Export query results to CSV

pub fn start_repl(&self) -> Result<()>

Start the interactive REPL

pub fn start_shell(&self) -> Result<()>

Start the interactive shell

pub fn populate_with_test_data( &self, config: Option<PopulationConfig>, ) -> Result<()>

Populate database with test data

pub fn begin_transaction(&self) -> Result<()>

Begin a transaction

pub fn commit_transaction(&self) -> Result<()>

Commit the current transaction

pub fn rollback_transaction(&self) -> Result<()>

Rollback the current transaction

pub fn is_transaction_active(&self) -> bool

Check if a transaction is active

pub fn bookmark_manager(&mut self) -> Option<&mut BookmarkManager>

Get access to the bookmark manager