Database is not created

[danielniccoli]

Hi,

very new to Tauri and Rust. I am trying to use the sql plugin to create a database. I have this code and I can see that mysetup() is run due to the stdout output. However, mydatabase.db is not being created and I do not see any attempt to touch that file using procmon.exe. What am I doing wrong?

fn mysetup(_app: &mut tauri::App) -> Result<(), Box<(dyn std::error::Error)>> {
    print!("Initialise SQLite database and set state …");

    let migrations = vec![
        // Define your migrations here
        Migration {
            version: 1,
            description: "create_initial_tables",
            sql: "CREATE TABLE documents (id INTEGER PRIMARY KEY, name TEXT);",
            kind: MigrationKind::Up,
        },
    ];

    let _ = tauri::Builder::default().plugin(
        tauri_plugin_sql::Builder::default()
            .add_migrations("sqlite:mydatabase.db", migrations)
            .build(),
    );

    println!(" done!");

    Ok(())
}

fn main() {
    tauri::Builder::default()
        .plugin(tauri_plugin_shell::init())
        .plugin(tauri_plugin_sql::Builder::default().build())
        .setup(mysetup)
        .invoke_handler(tauri::generate_handler![greet])
        .run(tauri::generate_context!())
        .expect("error while running tauri application");
}

[FabianLars]

iirc the sql plugin will only create the db once you load() it. The migrations will also only run at that point. Arguably doesn't make that much sense, but this is how it currently works.

[danielniccoli]

Thanks. I agree that this doesn't make sense. DB creation and migration need an option to be explicit.