Crate database [−] [src]

A relational database.

Example

use database::prelude::*;

let database: Database<SQLite> = Database::open(":memory:").unwrap();

let statement = create_table().name("foo")
                              .column(column().name("bar").kind(Type::Float))
                              .column(column().name("baz").kind(Type::Integer));
database.execute(statement).unwrap();

let statement = insert_into().table("foo").column("bar").column("baz");
let mut statement = database.prepare(statement).unwrap();
statement.execute(&[Value::Float(42.0), Value::Integer(69)]).unwrap();

let statement = select().table("foo");
let mut statement = database.prepare(statement).unwrap();
statement.execute(&[]).unwrap();

while let Some(record) = statement.next().unwrap() {
    assert_eq!(record[0], Value::Float(42.0));
    assert_eq!(record[1], Value::Integer(69));
}