test_subquery/
test_subquery.rs

1//! Test INSERT...SELECT and Subquery in SET
2
3use qail_core::parse;
4use qail_core::transpiler::ToSql;
5
6fn main() {
7    println!("=== Testing INSERT...SELECT ===\n");
8    
9    // Test 1: Basic INSERT SELECT
10    let query1 = "add archive fields id, name from (get users fields id, name where active = false)";
11    println!("Query 1: {}", query1);
12    match parse(query1) {
13        Ok(cmd) => {
14            println!("  source_query: {:?}", cmd.source_query.is_some());
15            println!("  SQL: {}\n", cmd.to_sql());
16        }
17        Err(e) => println!("  Parse error: {:?}\n", e),
18    }
19    
20    println!("=== Testing Subquery in SET ===\n");
21    
22    // Test 2: Subquery in UPDATE
23    let query2 = "set orders values total = (get items fields sum(price) where order_id = orders.id) where id = :id";
24    println!("Query 2: {}", query2);
25    match parse(query2) {
26        Ok(cmd) => println!("  SQL: {}\n", cmd.to_sql()),
27        Err(e) => println!("  Parse error: {:?}\n", e),
28    }
29    
30    // Test 3: Simple subquery value
31    let query3 = "set users values role_id = (get roles fields id where name = 'admin') where user_id = :id";
32    println!("Query 3: {}", query3);
33    match parse(query3) {
34        Ok(cmd) => println!("  SQL: {}\n", cmd.to_sql()),
35        Err(e) => println!("  Parse error: {:?}\n", e),
36    }
37}
test_subquery/test_subquery.rs

test_subquery/
test_subquery.rs
