use crate::database;
#[test]
fn test_01_create() {
let db = database::find_bean_database().unwrap();
let _ = 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();
let ret = db.conn().unwrap().query("SELECT * FROM users limit 3", &[]);
for row in ret.unwrap() {
println!(" id={:#?} ", row.columns().get(0).unwrap());
}
let ret = db
.conn()
.unwrap()
.query("SELECT * FROM train_group limit 3", &[]);
if ret.is_ok() {
for row in ret.unwrap() {
println!(" id={:#?} ", row.columns().get(0).unwrap());
}
}
}