Function register_array_contains

src/functions/array_functions.rs:369–393

array_contains(array1, array2) - Check if array1 contains all elements of array2

(conn: &Connection)

/// array_contains(array1, array2) - Check if array1 contains all elements of array2
fn register_array_contains(conn: &Connection) -> Result<()> {
    conn.create_scalar_function(
        "array_contains",
        2,
        FunctionFlags::SQLITE_UTF8 | FunctionFlags::SQLITE_DETERMINISTIC,
        |ctx| {
            let array1_json: String = ctx.get(0)?;
            let array2_json: String = ctx.get(1)?;
            
            match (
                serde_json::from_str::<JsonValue>(&array1_json),
                serde_json::from_str::<JsonValue>(&array2_json),
            ) {
                (Ok(JsonValue::Array(arr1)), Ok(JsonValue::Array(arr2))) => {
                    // Check if all elements of arr2 are in arr1
                    let contains_all = arr2.iter().all(|elem| arr1.contains(elem));
                    Ok(contains_all)
                }
                _ => Ok(false),
            }
        },
    )?;
    
    Ok(())
}

/// array_contained(array1, array2) - Check if all elements of array1 are in array2
fn register_array_contained(conn: &Connection) -> Result<()> {