SQLite Version Status

The package provides an interface to SQLite.

Documentation

Example

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 &(column, value) in pairs.iter() {
        println!("{} = {}", column, value.unwrap());
    }
    true
}).unwrap();

}

fn setup() -> PathBuf { let path = PathBuf::from("database.sqlite3"); if fs::metadata(&path).isok() { fs::removefile(&path).unwrap(); } path } ```

Contributing

  1. Fork the project.
  2. Implement your idea.
  3. Open a pull request.