use motedb::{Database, QueryResult};
fn main() -> motedb::Result<()> {
let _ = env_logger::Builder::from_env(env_logger::Env::default().default_filter_or("off"))
.format_timestamp_millis()
.try_init();
let _ = std::fs::remove_dir_all("logging_demo.mote");
let db = Database::create("logging_demo.mote")?;
db.execute("CREATE TABLE sensors (id INT PRIMARY KEY, v FLOAT)")?;
db.execute("INSERT INTO sensors VALUES (1, 21.5)")?;
db.execute("INSERT INTO sensors VALUES (2, 22.0)")?;
let r = db.execute("SELECT * FROM sensors ORDER BY v")?;
if let QueryResult::Select { rows, .. } = r.materialize()? {
println!("rows: {:?}", rows.len());
}
db.checkpoint()?;
db.close()?;
let _ = std::fs::remove_dir_all("logging_demo.mote");
Ok(())
}