spatialite-rs 0.1.6

Wraps the sqlite crate, so that when you call spatialite_rs::open it will load mod_spatialite.so into the connection before returning.
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51

use sqlite::*;
use std::path::Path;

pub fn open<T: AsRef<Path>>(path: T) -> Result<Connection> {
    let connection = sqlite::Connection::open(path)?;
    load_spatialite_extension(&connection);
    Ok(connection)
}

pub fn open_with_flags<T: AsRef<Path>>(path: T, flags: OpenFlags) -> Result<Connection> {
    let connection = sqlite::Connection::open_with_flags(&path, flags)?;
    load_spatialite_extension(&connection);
    Ok(connection)
}

fn load_spatialite_extension(conn: &Connection) {
    load_custom_extension(conn, "mod_spatialite.so");
}

pub fn load_custom_extension(conn: &Connection, module: &str) {
    unsafe {
        sqlite3_sys::sqlite3_enable_load_extension(conn.as_raw(), 1);
    }
    conn.execute(format!("SELECT load_extension('{}');", module))
        .unwrap();
    unsafe {
        sqlite3_sys::sqlite3_enable_load_extension(conn.as_raw(), 0);
    }
}

pub fn load_custom_extension_ep(conn: &Connection, module: &str, entry_point: &str ) {
    unsafe {
        sqlite3_sys::sqlite3_enable_load_extension(conn.as_raw(), 1);
    }
    conn.execute(format!("SELECT load_extension('{}', '{}');", module, entry_point))
        .unwrap();
    unsafe {
        sqlite3_sys::sqlite3_enable_load_extension(conn.as_raw(), 0);
    }
}

#[test]
fn test_open() -> anyhow::Result<()> {
    {
        open("spatialite_rs_test.db")?;
    }

    open_with_flags("spatialite_rs_test.db", OpenFlags::new().set_read_only())?;
    std::fs::remove_file("spatialite_rs_test.db")?;
    Ok(())
}