#![cfg(feature = "postgres")]

use flp_gsp::{interpreter::postgres::*, Expression};

#[test]
fn test_postgres() {
    let s = r#"((((! "age" -) & (! "age" > "18")) & ("sex" ? ["male", "Male"] | "sex" ~ "Female")) & "\"name\"" * "J?c*")"#;
    let expression = Expression::try_from_str(s).unwrap();
    println!("{:?}", expression);

    let mut renames = PostgresRenames::new();
    renames.insert("sex".into(), "gender".into());

    let mut types = PostgresTypes::new();
    types.insert("age".into(), PostgresType::Int(None));
    types.insert("sex".into(), PostgresType::StringLike(None));
    types.insert("\"name\"".into(), PostgresType::StringLike(None));

    let interpreted = interpret(&expression, &renames, &types, 1).unwrap();
    let (clause, binds) = interpreted;

    assert_eq!(
        clause,
        "((((NOT age IS NULL) AND (NOT age > $1)) AND (gender IN ($2, $3) OR gender ILIKE $4)) AND \"name\" ILIKE $5)"
    );
    assert_eq!(
        binds,
        vec![
            PostgresType::Int(Some(18)),
            PostgresType::StringLike(Some("male".into())),
            PostgresType::StringLike(Some("Male".into())),
            PostgresType::StringLike(Some("Female".into())),
            PostgresType::StringLike(Some("J_c%".into()))
        ]
    );
}