tokio-rusqlite
Asynchronous handle for rusqlite library.
Usage
use rusqlite::{params, Result};
use tokio_rusqlite::Connection;
#[derive(Debug)]
struct Person {
id: i32,
name: String,
data: Option<Vec<u8>>,
}
#[tokio::main]
async fn main() -> Result<()> {
let conn = Connection::open_in_memory().await?;
let people = conn
.call(|conn| {
conn.execute(
"CREATE TABLE person (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL,
data BLOB
)",
[],
)?;
let steven = Person {
id: 1,
name: "Steven".to_string(),
data: None,
};
conn.execute(
"INSERT INTO person (name, data) VALUES (?1, ?2)",
params![steven.name, steven.data],
)?;
let mut stmt = conn.prepare("SELECT id, name, data FROM person")?;
let people = stmt
.query_map([], |row| {
Ok(Person {
id: row.get(0)?,
name: row.get(1)?,
data: row.get(2)?,
})
})?
.collect::<Result<Vec<Person>, rusqlite::Error>>()?;
Ok::<_, rusqlite::Error>(people)
})
.await?;
for person in people {
println!("Found person {:?}", person);
}
Ok(())
}
Safety
This crate uses #![forbid(unsafe_code)] to ensure everything is implemented in 100% safe Rust.
License
This project is licensed under the MIT license.
548 Dec 31, 2022
31.5k Jan 1, 2023
224 Dec 21, 2022
145 Nov 23, 2022
2.1k Jan 8, 2023
3 Sep 18, 2021
20 Jul 17, 2021
28 Nov 3, 2022
166 Jan 4, 2023
4 Oct 20, 2023
12 Nov 18, 2022
9 Feb 16, 2021
1 Feb 15, 2022
7 Dec 16, 2022
59 Oct 27, 2023
35 Jun 26, 2022
138 Dec 27, 2022
2.8k Jan 8, 2023
168 Dec 25, 2022