The package provides an interface to SQLite.
The example given below can be ran using the following command:
cargo run --example workflow
```rust extern crate sqlite;
use std::fs; use std::path::PathBuf;
fn main() { let path = setup(); let database = sqlite::open(&path).unwrap();
database.execute(r#"
CREATE TABLE `users` (id INTEGER, name VARCHAR(255));
INSERT INTO `users` (id, name) VALUES (1, 'Alice');
"#).unwrap();
database.process("SELECT * FROM `users`;", |pairs| {
for (ref column, ref value) in pairs {
println!("{} = {}", column, value);
}
true
}).unwrap();
}
fn setup() -> PathBuf { let path = PathBuf::from("database.sqlite3"); if fs::metadata(&path).isok() { fs::removefile(&path).unwrap(); } path } ```