Struct SqliteProvider 

pub struct SqliteProvider { /* private fields */ }

SQLite database provider

Implementations

impl SqliteProvider

pub fn new(pool: SqlitePool) -> Self

Create a new SQLite provider

Arguments

• pool - SQLite connection pool

Trait Implementations

impl DatabaseProvider for SqliteProvider

fn list_tables<'life0, 'async_trait>( &'life0 self, ) -> Pin<Box<dyn Future<Output = Result<Vec<TableInfo>, DatabaseError>> + Send + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait,

List all table names in the database

fn get_table_schema<'life0, 'life1, 'async_trait>( &'life0 self, table: &'life1 str, ) -> Pin<Box<dyn Future<Output = Result<TableSchema, DatabaseError>> + Send + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait, 'life1: 'async_trait,

Get schema information for a specific table

fn get_rows<'life0, 'life1, 'async_trait>( &'life0 self, table: &'life1 str, query: RowQuery, ) -> Pin<Box<dyn Future<Output = Result<RowsResponse, DatabaseError>> + Send + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait, 'life1: 'async_trait,

Fetch rows with pagination, sorting, and filtering

fn count_rows<'life0, 'life1, 'life2, 'async_trait>( &'life0 self, table: &'life1 str, query: &'life2 RowQuery, ) -> Pin<Box<dyn Future<Output = Result<CountResponse, DatabaseError>> + Send + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait, 'life1: 'async_trait, 'life2: 'async_trait,

Get total row count for a table (with optional filters)

fn execute_query<'life0, 'life1, 'async_trait>( &'life0 self, sql: &'life1 str, ) -> Pin<Box<dyn Future<Output = Result<QueryResult, DatabaseError>> + Send + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait, 'life1: 'async_trait,

Execute a raw SQL query