Rust sqlite Example

Note

The sqlite^^^ crate comes up first in seatch but only has 240K downloads. The rusqlite^^^ has 8 million. So, I'm going with that.

This is what I'm doing for a basic sqlite call setup.

Create A Table

Code

use rusqlite::Connection;
use rusqlite::Result;

fn main() -> Result<()> {
    let conn = Connection::open("./_sqlite_db_test.db3")?;
    let create_table = "
        CREATE TABLE storage (name TEXT, color TEXT)";
    conn.execute(create_table, ())?;
    Ok(())
}

Insert Data

Code

use rusqlite::Connection;
use rusqlite::Result;

fn main() -> Result<()> {
    let conn = Connection::open("./_sqlite_db_test.db3")?;
    let insert_data = "
        INSERT INTO storage (name, color) VALUES (?1, ?2)";
    conn.execute(insert_data, ("alfa", "red"))?;
    Ok(())
}

Query Data

Code

fn main() -> Result<()> {
    let conn = Connection::open("./_sqlite_db_test.db3")?;
    let mut get_data = conn.prepare("SELECT name, color FROM storage WHERE name = ?1")?;
    let response = get_data.query_map(["alfa"], |row| {
        Ok((row.get::<usize, String>(0), row.get::<usize, String>(1)))
    })?;
    for item in response {
        println!("{}", item.unwrap().0.unwrap());
    }
    Ok(())
}