Function register_array_contained

src/functions/array_functions.rs:396–420

array_contained(array1, array2) - Check if all elements of array1 are in array2

(conn: &Connection)

/// array_contained(array1, array2) - Check if all elements of array1 are in array2
fn register_array_contained(conn: &Connection) -> Result<()> {
    conn.create_scalar_function(
        "array_contained",
        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 arr1 are in arr2
                    let contained_all = arr1.iter().all(|elem| arr2.contains(elem));
                    Ok(contained_all)
                }
                _ => Ok(false),
            }
        },
    )?;
    
    Ok(())
}

/// array_overlap(array1, array2) - Check if arrays have common elements
fn register_array_overlap(conn: &Connection) -> Result<()> {