mentat/tests/external_test.rs

61 lines
1.9 KiB
Rust

// Copyright 2016 Mozilla
//
// Licensed under the Apache License, Version 2.0 (the "License"); you may not use
// this file except in compliance with the License. You may obtain a copy of the
// License at http://www.apache.org/licenses/LICENSE-2.0
// Unless required by applicable law or agreed to in writing, software distributed
// under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR
// CONDITIONS OF ANY KIND, either express or implied. See the License for the
// specific language governing permissions and limitations under the License.
#[test]
fn can_import_sqlite() {
// From https://github.com/jgallagher/rusqlite#rusqlite.
#[derive(Debug)]
struct Person {
id: i32,
name: String,
data: Option<Vec<u8>>,
}
let conn = mentat::new_connection("").expect("SQLite connected");
conn.execute(
"CREATE TABLE person (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL,
data BLOB
)",
rusqlite::params![],
)
.unwrap();
let me = Person {
id: 1,
name: "Steven".to_string(),
data: None,
};
conn.execute(
"INSERT INTO person (name, data)
VALUES (?1, ?2)",
rusqlite::params![&me.name, &me.data],
)
.unwrap();
let mut stmt = conn.prepare("SELECT id, name, data FROM person").unwrap();
let person_iter = stmt
.query_map(rusqlite::params![], |row| {
Ok(Person {
id: row.get(0).unwrap(),
name: row.get(1).unwrap(),
data: row.get(2).unwrap(),
})
})
.unwrap();
for person in person_iter {
let p = person.unwrap();
assert_eq!(me.id, p.id);
assert_eq!(me.data, p.data);
assert_eq!(me.data, p.data);
}
}