Struct Schema 

pub struct Schema;

Database schema management.

Implementations

impl Schema

pub fn create_tables(conn: &Connection) -> Result<()>

Create all tables in the database.

pub fn create_indexes(conn: &Connection) -> Result<()>

Create indexes for efficient queries.

pub fn drop_indexes(conn: &Connection) -> Result<()>

Drop all non-primary indexes (for bulk import performance). After import completes, call create_indexes to rebuild them.

pub fn initialize(conn: &Connection) -> Result<()>

Initialize a new database with schema and indexes.

pub fn get_version(conn: &Connection) -> Result<Option<i32>>

Get the current schema version from the database. Returns None if the database is not initialized (table doesn’t exist or no rows).

pub fn set_metadata(conn: &Connection, key: &str, value: &str) -> Result<()>

Set a metadata value.

pub fn get_metadata(conn: &Connection, key: &str) -> Result<Option<String>>

Get a metadata value.

pub fn migrate_if_needed(conn: &Connection) -> Result<()>

Migrate the database schema if needed.

This handles upgrades from older schema versions to the current version.