Test JSON support

JSONSupportTests.swift

import XCTest
import GRDB

class JSONSupportTests: GRDBTestCase {
    func testJSONSupport() throws {
        let queries = [
            #"select json('[]') = '[]';"#,
            #"select json_array() = '[]';"#,
            #"select json_array_length('[]') = 0;"#,
            #"select json_array_length('[[]]','$[0]') = 0;"#,
            #"select json_extract('[0]','$[0]') = 0;"#,
            #"select '[0]' -> 0 = '0';"#,
            #"select '[0]' ->> 0 = 0;"#,
            #"select json_insert('[]','$[0]',0) = '[0]';"#,
            #"select json_object('a',0) = '{"a":0}';"#,
            #"select json_patch('[]','[]') = '[]';"#,
            #"select json_remove('[0]','$[0]') = '[]';"#,
            #"select json_replace('[1]','$[0]',0) = '[0]';"#,
            #"select json_set('[]','$[0]',0) = '[0]';"#,
            #"select json_type('[]') = 'array';"#,
            #"select json_type('[0]','$[0]') = 'integer';"#,
            #"select json_valid('[]') = 1;"#,
            #"select json_quote('[]') = '"[]"';"#,
            #"select json_group_array(a) = '[0]' from (select 0 AS a);"#,
            #"select json_group_object(key,value) = '{"a":0}' from (select 'a' AS key, 0 as value);"#,
        ]
        
        try DatabaseQueue().read { db in
            print("OS", ProcessInfo.processInfo.operatingSystemVersionString)
            try print("SQLite version:",  String.fetchOne(db, sql: "select sqlite_version()") ?? "unknown")
            
            for query in queries {
                do {
                    let result = try Bool.fetchOne(db, sql: query)
                    XCTAssert(result == true, "Unexpected result executing \(query)")
                } catch {
                    XCTFail("Unexpected error executing \(query): \(error)")
                }
            }
        }
    }
}

Here's the DMG for the macOS version if you want to run it locally.
It is notarized.

https://storage.googleapis.com/sqlite-validator/SQLiteJSONValidator.dmg

Cheers - Martin