tellaro-query-language 0.2.23

//! Empty array operator tests - matching Python test_empty_array_operators.py
//!
//! Tests how TQL operators behave with empty arrays to ensure
//! consistent and predictable behavior across all operators.
//!
//! NOTE: Rust has different semantics for array field comparisons than Python.
//! In Python, `tags = 'python'` checks if any element in tags equals 'python'.
//! In Rust, the behavior is to use explicit collection operators (any/all/none).
//! These tests document Rust's actual behavior.

use serde_json::json;
use tellaro_query_language::Tql;

// =============================================================================
// Basic Empty Array Tests with Collection Operators
// Note: In Rust, to check array elements, use ANY operator explicitly
// =============================================================================

#[test]
fn test_empty_array_any_equality() {
    let tql = Tql::new();
    let data = vec![
        json!({"id": 1, "tags": []}),
        json!({"id": 2, "tags": ["python", "rust"]}),
        json!({"id": 3, "tags": ["javascript"]}),
    ];

    // Use ANY to check if any element equals 'python'
    // Empty array does not contain 'python', so id=1 should not match
    let results = tql
        .query(&data, "any tags eq 'python'")
        .expect("Query should succeed");
    assert_eq!(results.len(), 1);
    assert_eq!(results[0]["id"], 2);
}

#[test]
fn test_empty_array_none_inequality() {
    let tql = Tql::new();
    let data = vec![
        json!({"id": 1, "tags": []}),
        json!({"id": 2, "tags": ["python", "rust"]}),
        json!({"id": 3, "tags": ["javascript"]}),
    ];

    // Use NONE to check if no element equals 'python'
    // Empty array does not contain 'python' (so NONE is true), plus id=3
    let results = tql
        .query(&data, "none tags eq 'python'")
        .expect("Query should succeed");
    assert_eq!(results.len(), 2);
    let ids: Vec<i64> = results.iter().filter_map(|r| r["id"].as_i64()).collect();
    assert!(ids.contains(&1));
    assert!(ids.contains(&3));
}

#[test]
fn test_empty_array_any_greater_than() {
    let tql = Tql::new();
    let data = vec![
        json!({"id": 1, "scores": []}),
        json!({"id": 2, "scores": [50, 75]}),
        json!({"id": 3, "scores": [25]}),
    ];

    // Using ANY to check if any element > 60
    // Empty array has no elements > 60, only id=2 matches
    let results = tql
        .query(&data, "any scores gt 60")
        .expect("Query should succeed");
    assert_eq!(results.len(), 1);
    assert_eq!(results[0]["id"], 2);
}

#[test]
fn test_empty_array_any_less_than() {
    let tql = Tql::new();
    let data = vec![
        json!({"id": 1, "scores": []}),
        json!({"id": 2, "scores": [50, 75]}),
        json!({"id": 3, "scores": [25]}),
    ];

    // Using ANY to check if any element < 60
    // Empty array has no elements < 60, id=2 (50) and id=3 (25) match
    let results = tql
        .query(&data, "any scores lt 60")
        .expect("Query should succeed");
    assert_eq!(results.len(), 2);
    let ids: Vec<i64> = results.iter().filter_map(|r| r["id"].as_i64()).collect();
    assert!(ids.contains(&2));
    assert!(ids.contains(&3));
}

#[test]
fn test_empty_array_any_contains() {
    let tql = Tql::new();
    let data = vec![
        json!({"id": 1, "tags": []}),
        json!({"id": 2, "tags": ["python", "rust"]}),
        json!({"id": 3, "tags": ["javascript"]}),
    ];

    // Using ANY to check if any element contains 'py'
    // Empty array does not contain 'py', only id=2 matches
    let results = tql
        .query(&data, "any tags contains 'py'")
        .expect("Query should succeed");
    assert_eq!(results.len(), 1);
    assert_eq!(results[0]["id"], 2);
}

#[test]
fn test_empty_array_any_startswith() {
    let tql = Tql::new();
    let data = vec![
        json!({"id": 1, "tags": []}),
        json!({"id": 2, "tags": ["python", "rust"]}),
        json!({"id": 3, "tags": ["javascript"]}),
    ];

    // Using ANY to check if any element starts with 'py'
    // Empty array has no elements starting with 'py', only id=2 matches
    let results = tql
        .query(&data, "any tags startswith 'py'")
        .expect("Query should succeed");
    assert_eq!(results.len(), 1);
    assert_eq!(results[0]["id"], 2);
}

#[test]
fn test_empty_array_any_endswith() {
    let tql = Tql::new();
    let data = vec![
        json!({"id": 1, "tags": []}),
        json!({"id": 2, "tags": ["python", "rust"]}),
        json!({"id": 3, "tags": ["javascript"]}),
    ];

    // Using ANY to check if any element ends with 'on'
    // Empty array has no elements ending with 'on', only id=2 matches (python)
    let results = tql
        .query(&data, "any tags endswith 'on'")
        .expect("Query should succeed");
    assert_eq!(results.len(), 1);
    assert_eq!(results[0]["id"], 2);
}

// =============================================================================
// Collection Operator Tests with Empty Arrays
// =============================================================================

#[test]
fn test_empty_array_collection_any_operator() {
    let tql = Tql::new();
    let data = vec![
        json!({"id": 1, "tags": []}),
        json!({"id": 2, "tags": ["python", "rust"]}),
        json!({"id": 3, "tags": ["javascript"]}),
    ];

    // ANY checks if value is in array - empty array does not contain 'python'
    let results = tql
        .query(&data, "any tags eq 'python'")
        .expect("Query should succeed");
    assert_eq!(results.len(), 1);
    assert_eq!(results[0]["id"], 2);
}

#[test]
fn test_empty_array_collection_all_operator() {
    let tql = Tql::new();
    let data = vec![
        json!({"id": 1, "tags": []}),
        json!({"id": 2, "tags": ["python", "rust"]}),
        json!({"id": 3, "tags": ["javascript"]}),
    ];

    // ALL checks if all elements equal value
    // Empty array: TQL explicitly returns False for empty arrays
    let results = tql
        .query(&data, "all tags eq 'python'")
        .expect("Query should succeed");
    assert_eq!(results.len(), 0);
}

#[test]
fn test_empty_array_collection_none_operator() {
    let tql = Tql::new();
    let data = vec![
        json!({"id": 1, "tags": []}),
        json!({"id": 2, "tags": ["python", "rust"]}),
        json!({"id": 3, "tags": ["javascript"]}),
    ];

    // NONE checks if value is NOT in array
    // Empty array does not contain 'python', so NONE is true
    let results = tql
        .query(&data, "none tags eq 'python'")
        .expect("Query should succeed");
    assert_eq!(results.len(), 2);
    let ids: Vec<i64> = results.iter().filter_map(|r| r["id"].as_i64()).collect();
    assert!(ids.contains(&1));
    assert!(ids.contains(&3));
}

// =============================================================================
// Existence Tests with Empty Arrays
// =============================================================================

#[test]
fn test_empty_array_exists() {
    let tql = Tql::new();
    let data = vec![
        json!({"id": 1, "tags": []}),
        json!({"id": 2, "tags": ["python", "rust"]}),
        json!({"id": 3, "tags": ["javascript"]}),
    ];

    // Field exists even if it's an empty array, so all match
    let results = tql
        .query(&data, "tags exists")
        .expect("Query should succeed");
    assert_eq!(results.len(), 3);
}

#[test]
fn test_empty_array_not_exists() {
    let tql = Tql::new();
    let data = vec![
        json!({"id": 1, "tags": []}),
        json!({"id": 2, "tags": ["python", "rust"]}),
        json!({"id": 3}), // Missing tags field
    ];

    // Only id=3 has missing tags field
    let results = tql
        .query(&data, "tags not exists")
        .expect("Query should succeed");
    assert_eq!(results.len(), 1);
    assert_eq!(results[0]["id"], 3);
}

// =============================================================================
// Multiple Records with Empty Arrays
// =============================================================================

#[test]
fn test_multiple_empty_arrays() {
    let tql = Tql::new();
    let data = vec![
        json!({"id": 1, "tags": []}),
        json!({"id": 2, "tags": []}),
        json!({"id": 3, "tags": ["python"]}),
    ];

    // Using ANY to check element equality - only id=3 matches
    let results = tql
        .query(&data, "any tags eq 'python'")
        .expect("Query should succeed");
    assert_eq!(results.len(), 1);
    assert_eq!(results[0]["id"], 3);
}

// =============================================================================
// Compound Expressions with Empty Arrays
// =============================================================================

#[test]
fn test_empty_array_with_and_expression() {
    let tql = Tql::new();
    let data = vec![
        json!({"id": 1, "tags": []}),
        json!({"id": 2, "tags": ["python", "rust"]}),
        json!({"id": 3, "tags": ["javascript"]}),
    ];

    // id > 1: records 2, 3
    // any tags eq 'python': record 2
    // Combined: record 2
    let results = tql
        .query(&data, "id > 1 AND any tags eq 'python'")
        .expect("Query should succeed");
    assert_eq!(results.len(), 1);
    assert_eq!(results[0]["id"], 2);
}

#[test]
fn test_empty_array_with_or_expression() {
    let tql = Tql::new();
    let data = vec![
        json!({"id": 1, "tags": []}),
        json!({"id": 2, "tags": ["python", "rust"]}),
        json!({"id": 3, "tags": ["javascript"]}),
    ];

    // any tags eq 'python': record 2
    // id = 1: record 1
    // Combined: records 1 and 2
    let results = tql
        .query(&data, "any tags eq 'python' OR id = 1")
        .expect("Query should succeed");
    assert_eq!(results.len(), 2);
    let ids: Vec<i64> = results.iter().filter_map(|r| r["id"].as_i64()).collect();
    assert!(ids.contains(&1));
    assert!(ids.contains(&2));
}

// =============================================================================
// Empty Array with In Operator
// =============================================================================

#[test]
fn test_empty_array_field_with_in_operator() {
    let tql = Tql::new();
    let data = vec![
        json!({"id": 1, "tags": []}),
        json!({"id": 2, "tags": ["python"]}),
        json!({"id": 3, "tags": ["javascript"]}),
    ];

    // Test the reversed 'in' operator with ANY: check if 'python' is in tags array
    // Empty array [] does not contain 'python', only id=2 matches
    let results = tql
        .query(&data, "any tags eq 'python'")
        .expect("Query should succeed");
    assert_eq!(results.len(), 1);
    assert_eq!(results[0]["id"], 2);
}

// =============================================================================
// Empty Array with Negated Collection Operators
// =============================================================================

#[test]
fn test_empty_array_none_contains() {
    let tql = Tql::new();
    let data = vec![
        json!({"id": 1, "tags": []}),
        json!({"id": 2, "tags": ["python", "rust"]}),
        json!({"id": 3, "tags": ["javascript"]}),
    ];

    // NONE tags contain 'python' - true for empty array and javascript
    let results = tql
        .query(&data, "none tags contains 'python'")
        .expect("Query should succeed");
    assert_eq!(results.len(), 2);
    let ids: Vec<i64> = results.iter().filter_map(|r| r["id"].as_i64()).collect();
    assert!(ids.contains(&1));
    assert!(ids.contains(&3));
}

#[test]
fn test_empty_array_none_startswith() {
    let tql = Tql::new();
    let data = vec![
        json!({"id": 1, "tags": []}),
        json!({"id": 2, "tags": ["python", "rust"]}),
        json!({"id": 3, "tags": ["javascript"]}),
    ];

    // NONE tags start with 'py' - true for empty array and javascript
    let results = tql
        .query(&data, "none tags startswith 'py'")
        .expect("Query should succeed");
    assert_eq!(results.len(), 2);
    let ids: Vec<i64> = results.iter().filter_map(|r| r["id"].as_i64()).collect();
    assert!(ids.contains(&1));
    assert!(ids.contains(&3));
}

// =============================================================================
// Empty Nested Arrays
// =============================================================================

#[test]
fn test_empty_nested_array() {
    let tql = Tql::new();
    let data = vec![
        json!({"id": 1, "data": {"items": []}}),
        json!({"id": 2, "data": {"items": ["a", "b"]}}),
    ];

    // Using ANY to check nested array elements
    let results = tql
        .query(&data, "any data.items eq 'a'")
        .expect("Query should succeed");
    assert_eq!(results.len(), 1);
    assert_eq!(results[0]["id"], 2);
}

// =============================================================================
// Empty Array with Numeric Comparison
// =============================================================================

#[test]
fn test_empty_array_numeric_any_gte_and_lte() {
    let tql = Tql::new();
    let data = vec![
        json!({"id": 1, "values": []}),
        json!({"id": 2, "values": [5, 15, 25]}),
        json!({"id": 3, "values": [50]}),
    ];

    // Note: "any field between X and Y" syntax isn't supported in Rust
    // Using combination of gte and lte with AND instead
    // Check if any value is >= 10 AND any value is <= 20
    // This tests that empty arrays don't match
    let results = tql
        .query(&data, "any values gte 10 AND any values lte 20")
        .expect("Query should succeed");
    // id=2 has values [5, 15, 25] - 15 and 25 are >= 10, and 5 and 15 are <= 20
    assert_eq!(results.len(), 1);
    assert_eq!(results[0]["id"], 2);
}

#[test]
fn test_empty_array_numeric_any_in_list() {
    let tql = Tql::new();
    let data = vec![
        json!({"id": 1, "values": []}),
        json!({"id": 2, "values": [1, 2, 3]}),
        json!({"id": 3, "values": [4, 5]}),
    ];

    // Using ANY to check if any element is in [1, 2]
    let results = tql
        .query(&data, "any values in [1, 2]")
        .expect("Query should succeed");
    assert_eq!(results.len(), 1);
    assert_eq!(results[0]["id"], 2);
}