Function register_array_length

src/functions/array_functions.rs:42–74

array_length(array, dimension) - Get length of array in specified dimension

(conn: &Connection)

/// array_length(array, dimension) - Get length of array in specified dimension
fn register_array_length(conn: &Connection) -> Result<()> {
    conn.create_scalar_function(
        "array_length",
        2,
        FunctionFlags::SQLITE_UTF8 | FunctionFlags::SQLITE_DETERMINISTIC,
        |ctx| {
            let array_json: String = ctx.get(0)?;
            let dimension: i32 = ctx.get(1)?;
            
            match serde_json::from_str::<JsonValue>(&array_json) {
                Ok(JsonValue::Array(arr)) => {
                    if dimension == 1 {
                        Ok(Some(arr.len() as i32))
                    } else {
                        // For higher dimensions, check first element
                        if let Some(JsonValue::Array(inner)) = arr.first() {
                            if dimension == 2 {
                                Ok(Some(inner.len() as i32))
                            } else {
                                Ok(None) // Higher dimensions not yet supported
                            }
                        } else {
                            Ok(None)
                        }
                    }
                }
                _ => Ok(None),
            }
        },
    )?;
    
    Ok(())
}

/// array_upper(array, dimension) - Get upper bound of array dimension
fn register_array_upper(conn: &Connection) -> Result<()> {