Function register_array_cat

src/functions/array_functions.rs:242–265

array_cat(array1, array2) - Concatenate two arrays

(conn: &Connection)

/// array_cat(array1, array2) - Concatenate two arrays
fn register_array_cat(conn: &Connection) -> Result<()> {
    conn.create_scalar_function(
        "array_cat",
        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(mut arr1)), Ok(JsonValue::Array(arr2))) => {
                    arr1.extend(arr2);
                    Ok(serde_json::to_string(&arr1).ok())
                }
                _ => Ok(None),
            }
        },
    )?;
    
    Ok(())
}

/// array_remove(array, element) - Remove all occurrences of element
fn register_array_remove(conn: &Connection) -> Result<()> {