Function setup_test_db

tests/subquery_cte_test.rs:9–72

()

use sqlparser::ast::{Query, Statement};

fn setup_test_db() -> Connection {
    let conn = Connection::open_in_memory().unwrap();
    
    // Initialize metadata table
    TypeMetadata::init(&conn).unwrap();
    
    // Register decimal functions
    pgsqlite::functions::register_all_functions(&conn).unwrap();
    
    // Create test tables
    conn.execute(
        "CREATE TABLE orders (
            id INTEGER PRIMARY KEY,
            customer_id INTEGER,
            total TEXT,
            tax TEXT,
            status TEXT
        )",
        [],
    ).unwrap();
    
    conn.execute(
        "INSERT INTO __pgsqlite_schema (table_name, column_name, pg_type, sqlite_type) VALUES
         ('orders', 'total', 'NUMERIC', 'DECIMAL'),
         ('orders', 'tax', 'NUMERIC', 'DECIMAL')",
        [],
    ).unwrap();
    
    conn.execute(
        "CREATE TABLE customers (
            id INTEGER PRIMARY KEY,
            name TEXT,
            credit_limit TEXT,
            discount_rate TEXT
        )",
        [],
    ).unwrap();
    
    conn.execute(
        "INSERT INTO __pgsqlite_schema (table_name, column_name, pg_type, sqlite_type) VALUES
         ('customers', 'credit_limit', 'NUMERIC', 'DECIMAL'),
         ('customers', 'discount_rate', 'NUMERIC', 'DECIMAL')",
        [],
    ).unwrap();
    
    conn.execute(
        "CREATE TABLE products (
            id INTEGER PRIMARY KEY,
            name TEXT,
            price TEXT,
            cost TEXT
        )",
        [],
    ).unwrap();
    
    conn.execute(
        "INSERT INTO __pgsqlite_schema (table_name, column_name, pg_type, sqlite_type) VALUES
         ('products', 'price', 'NUMERIC', 'DECIMAL'),