Struct Database 

pub struct Database {
    pub conn: Connection,
}

Represents a database connection and provides methods for interacting with it.

The Database struct is the primary entry point for interacting with the database. It holds the connection pool and provides methods for creating new connections, running migrations, and performing other database-level operations.

Fields

conn: Connection

The database connection.

Implementations

impl Database

pub async fn new(database_url: &str) -> Result<Self, Error>

Creates a new database connection.

This method is only available when the turso feature is not enabled. It uses sqlx to connect to the database specified by the database_url.

Arguments

• database_url - The connection string for the database.

Returns

A Result containing a new Database instance on success, or an Error on failure.

pub async fn migrate(&self) -> Result<(), Error>

Runs database migrations.

This method iterates over all registered models and applies their migrations to the database. For migrations to be discovered, the models must be imported into the binary where this method is called.

Example

// In your main.rs
use rusql_alchemy::prelude::*;
use rusql_alchemy::Error;

// Import your models so they can be discovered for migration.
#[allow(unused_imports)]
use crate::models::*;

#[tokio::main]
async fn main() -> Result<(), Error> {
    let database = Database::new_local("local.db").await?;
    database.migrate().await?;
    Ok(())
}