Struct Sqlite 

pub struct Sqlite { /* private fields */ }

SQLite database driver.

Implementations

impl Sqlite

pub async fn connect(db_dir: &Path, db_name: &str) -> Result<Arc<Self>>

Methods from Deref<Target = DatabaseConnection>

pub async fn ping(&self) -> Result<(), DbErr>

Checks if a connection to the database is still valid.

pub async fn close_by_ref(&self) -> Result<(), DbErr>

Explicitly close the database connection

pub fn get_mysql_connection_pool(&self) -> &Pool<MySql>

Get sqlx::MySqlPool

Panics

Panics if DbConn is not a MySQL connection.

pub fn get_postgres_connection_pool(&self) -> &Pool<Postgres>

Get sqlx::PgPool

Panics

Panics if DbConn is not a Postgres connection.

pub fn get_sqlite_connection_pool(&self) -> &Pool<Sqlite>

Get sqlx::SqlitePool

Panics

Panics if DbConn is not a SQLite connection.

Trait Implementations

impl AsRef<DatabaseConnection> for Sqlite

fn as_ref(&self) -> &DatabaseConnection

Converts this type into a shared reference of the (usually inferred) input type.

impl Borrow<DatabaseConnection> for Sqlite

fn borrow(&self) -> &DatabaseConnection

Immutably borrows from an owned value.

impl DatabaseDriver for Sqlite

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

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

Set the following SQLite pragmas for performance:

• journal_mode=WAL
• cache=64000
• synchronous=NORMAL

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

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

Execute wal_checkpoint to checkpoint the WAL (Write-Ahead Logging) journal.

fn connection(&self) -> DatabaseConnection

Returns the database connection for the driver.

impl Debug for Sqlite

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Deref for Sqlite

type Target = DatabaseConnection

The resulting type after dereferencing.

fn deref(&self) -> &Self::Target

Dereferences the value.

impl<'c> IntoSchemaManagerConnection<'c> for &'c Sqlite

fn into_schema_manager_connection(self) -> SchemaManagerConnection<'c>

impl FXStruct for Sqlite