Function test_array_functions

src/functions/array_functions.rs:814–849

()

    
    #[test]
    fn test_array_functions() {
        let conn = Connection::open_in_memory().unwrap();
        register_array_functions(&conn).unwrap();
        
        // Test array_length
        let len: i32 = conn.query_row(
            "SELECT array_length('[1,2,3,4,5]', 1)",
            [],
            |row| row.get(0)
        ).unwrap();
        assert_eq!(len, 5);
        
        // Test array_append
        let result: String = conn.query_row(
            "SELECT array_append('[1,2,3]', '4')",
            [],
            |row| row.get(0)
        ).unwrap();
        assert_eq!(result, "[1,2,3,4]");
        
        // Test array_contains
        let contains: bool = conn.query_row(
            "SELECT array_contains('[1,2,3,4,5]', '[2,3]')",
            [],
            |row| row.get(0)
        ).unwrap();
        assert!(contains);
        
        // Test array_overlap
        let overlap: bool = conn.query_row(
            "SELECT array_overlap('[1,2,3]', '[3,4,5]')",
            [],
            |row| row.get(0)
        ).unwrap();
        assert!(overlap);
    }
}