Function setup_test_db

tests/float_decimal_test.rs:8–55

()

use sqlparser::dialect::PostgreSqlDialect;

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 with REAL and DOUBLE PRECISION columns
    conn.execute(
        "CREATE TABLE measurements (
            id INTEGER PRIMARY KEY,
            temperature TEXT,
            pressure TEXT,
            humidity TEXT
        )",
        [],
    ).unwrap();
    
    conn.execute(
        "INSERT INTO __pgsqlite_schema (table_name, column_name, pg_type, sqlite_type) VALUES
         ('measurements', 'temperature', 'REAL', 'DECIMAL'),
         ('measurements', 'pressure', 'DOUBLE PRECISION', 'DECIMAL'),
         ('measurements', 'humidity', 'FLOAT4', 'DECIMAL')",
        [],
    ).unwrap();
    
    conn.execute(
        "CREATE TABLE calculations (
            id INTEGER PRIMARY KEY,
            value1 TEXT,
            value2 TEXT,
            result TEXT
        )",
        [],
    ).unwrap();
    
    conn.execute(
        "INSERT INTO __pgsqlite_schema (table_name, column_name, pg_type, sqlite_type) VALUES
         ('calculations', 'value1', 'FLOAT8', 'DECIMAL'),
         ('calculations', 'value2', 'FLOAT4', 'DECIMAL'),
         ('calculations', 'result', 'DOUBLE PRECISION', 'DECIMAL')",
        [],
    ).unwrap();
    
    conn
}

fn rewrite_query(conn: &Connection, sql: &str) -> Result<String, String> {
    let dialect = PostgreSqlDialect {};