Function test_jsonb_delete_function

src/functions/json_functions.rs:2050–2166

()

    
    #[test]
    fn test_jsonb_delete_function() {
        let conn = Connection::open_in_memory().unwrap();
        register_json_functions(&conn).unwrap();
        
        // Test deleting from object
        let test_json = r#"{"name": "John", "age": 30, "email": "john@example.com"}"#;
        let result: Option<String> = conn.query_row(
            "SELECT jsonb_delete(?, ?)",
            [test_json, "{email}"],
            |row| row.get(0)
        ).unwrap();
        
        assert!(result.is_some());
        let parsed: JsonValue = serde_json::from_str(&result.unwrap()).unwrap();
        match parsed {
            JsonValue::Object(map) => {
                assert_eq!(map.get("name"), Some(&JsonValue::String("John".to_string())));
                assert_eq!(map.get("age"), Some(&JsonValue::Number(serde_json::Number::from(30))));
                assert_eq!(map.get("email"), None); // Should be deleted
                assert_eq!(map.len(), 2); // Only 2 keys remaining
            }
            _ => panic!("Expected JSON object"),
        }
        
        // Test deleting from nested object
        let nested_json = r#"{"user": {"name": "Alice", "email": "alice@example.com"}, "active": true}"#;
        let result: Option<String> = conn.query_row(
            "SELECT jsonb_delete(?, ?)",
            [nested_json, "{user,email}"],
            |row| row.get(0)
        ).unwrap();
        
        assert!(result.is_some());
        let parsed: JsonValue = serde_json::from_str(&result.unwrap()).unwrap();
        match parsed {
            JsonValue::Object(map) => {
                if let Some(JsonValue::Object(user_map)) = map.get("user") {
                    assert_eq!(user_map.get("name"), Some(&JsonValue::String("Alice".to_string())));
                    assert_eq!(user_map.get("email"), None); // Should be deleted
                    assert_eq!(user_map.len(), 1); // Only name remaining
                } else {
                    panic!("Expected nested user object");
                }
            }
            _ => panic!("Expected JSON object"),
        }
        
        // Test deleting from array
        let array_json = r#"["apple", "banana", "cherry", "date"]"#;
        let result: Option<String> = conn.query_row(
            "SELECT jsonb_delete(?, ?)",
            [array_json, "{1}"],
            |row| row.get(0)
        ).unwrap();
        
        assert!(result.is_some());
        let parsed: JsonValue = serde_json::from_str(&result.unwrap()).unwrap();
        match parsed {