use std::path::Path;
use njord::sqlite;
use njord_derive::sql;
#[test]
fn execute_raw_sql() {
let db_relative_path = "./db/insert.db";
let db_path = Path::new(&db_relative_path);
let conn = sqlite::open(db_path).unwrap();
let sql = sql! {
INSERT INTO users (username, email, address)
VALUES
("raw_execute", "raw_execute@icloud.com", "raw_execute_address");
DELETE FROM users
WHERE username = "raw_execute";
};
let results = sqlite::raw_execute(&conn, &sql);
assert!(!results.is_err());
}