1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
use crate::*; test_case!(basic, async move { run!( r#" CREATE TABLE Test ( id INTEGER, num INTEGER, name TEXT )"# ); run!("INSERT INTO Test (id, num, name) VALUES (1, 2, \"Hello\")"); run!("INSERT INTO Test (id, num, name) VALUES (1, 9, \"World\")"); run!("INSERT INTO Test (id, num, name) VALUES (3, 4, \"Great\"), (4, 7, \"Job\")"); use Value::*; test!( Ok(select!( id | num | name I64 | I64 | Str; 1 2 "Hello".to_owned(); 1 9 "World".to_owned(); 3 4 "Great".to_owned(); 4 7 "Job".to_owned() )), "SELECT id, num, name FROM Test" ); count!(4, "SELECT * FROM Test"); run!("UPDATE Test SET id = 2"); let test_cases = vec![ (Ok(select!(id; I64; 2; 2; 2; 2)), "SELECT id FROM Test"), ( Ok(select!(id | num; I64 | I64; 2 2; 2 9; 2 4; 2 7)), "SELECT id, num FROM Test", ), ]; for (expected, sql) in test_cases.into_iter() { test!(expected, sql); } });