SQLite in-memory COUNT
examples/sqlite/in-memory-count/src/main.rs
use sqlite::State; fn main() { let connection = sqlite::open(":memory:").unwrap(); connection.execute("CREATE TABLE users (name TEXT, age INTEGER, grade INTEGER);").unwrap(); connection.execute("INSERT INTO users VALUES ('Alice', 42, 80);").unwrap(); connection.execute("INSERT INTO users VALUES ('Bob', 79, 70);").unwrap(); let query = "SELECT COUNT(*) cnt FROM users"; let mut statement = connection.prepare(query).unwrap(); if let Ok(State::Row) = statement.next() { println!("\ncount = {}", statement.read::<i64, _>("cnt").unwrap()); } else { println!("trouble"); } }
count = 2