qail-core 0.27.9

AST-native query builder - type-safe expressions, zero SQL strings
Documentation 
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

//! Test INSERT...SELECT and Subquery in SET

use qail_core::parse;
use qail_core::transpiler::ToSql;

fn main() {
    println!("=== Testing INSERT...SELECT ===\n");

    // Test 1: Basic INSERT SELECT
    let query1 =
        "add archive fields id, name from (get users fields id, name where active = false)";
    println!("Query 1: {}", query1);
    match parse(query1) {
        Ok(cmd) => {
            println!("  source_query: {:?}", cmd.source_query.is_some());
            println!("  SQL: {}\n", cmd.to_sql());
        }
        Err(e) => println!("  Parse error: {:?}\n", e),
    }

    println!("=== Testing Subquery in SET ===\n");

    // Test 2: Subquery in UPDATE
    let query2 = "set orders values total = (get items fields sum(price) where order_id = orders.id) where id = :id";
    println!("Query 2: {}", query2);
    match parse(query2) {
        Ok(cmd) => println!("  SQL: {}\n", cmd.to_sql()),
        Err(e) => println!("  Parse error: {:?}\n", e),
    }

    // Test 3: Simple subquery value
    let query3 =
        "set users values role_id = (get roles fields id where name = 'admin') where user_id = :id";
    println!("Query 3: {}", query3);
    match parse(query3) {
        Ok(cmd) => println!("  SQL: {}\n", cmd.to_sql()),
        Err(e) => println!("  Parse error: {:?}\n", e),
    }
}