use crate::database;
#[test]
fn test_01_create() {
let db = database::find_bean_database().unwrap();
db.conn().unwrap().execute(
"CREATE TABLE IF NOT EXISTS users1 (
id SERIAL PRIMARY KEY,
name VARCHAR(100) NOT NULL,
age INT
)",
&[],
);
}
#[test]
fn test_02_query() {
let db = database::find_bean_database().unwrap();
for row in db.conn().unwrap().query("SELECT * FROM users limit 3", &[]) {
println!(" id={:#?} ", row.get(0).unwrap());
}
for row in db
.conn()
.unwrap()
.query("SELECT * FROM train_group limit 3", &[])
{
println!(" id={:#?} ", row.get(0).unwrap());
}
}