Created
October 7, 2023 09:28
-
-
Save groue/046ebddb4a410304094c022d756081c8 to your computer and use it in GitHub Desktop.
Test JSON support
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)") | |
} | |
} | |
} | |
} | |
} |
martindufort
commented
Oct 13, 2023
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
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment