Files
sqlite/tests/sqlite_callback_test.zi

88 lines
4.3 KiB
Ziran

#import "SQLite"
CallbackState :: struct { bias: float64; calls: s32; destroyed: s32; }
Observe :: (context: *void, argc: s32, argv: **void) {
state := cast(*CallbackState)SqliteUserData(context)
if state == null || argc != 1 || argv == null {
SqliteResultDouble(context, -10000.0)
return
}
state.calls += 1
kind := SqliteValueType(argv[0])
value := state.bias - cast(float64)kind
if kind == SQLITE_BLOB {
count := SqliteValueBytes(argv[0])
bytes := cast(*u8)SqliteValueBlob(argv[0])
value = state.bias
index: s32 = 0
while index < count {
if bytes == null { SqliteResultDouble(context, -10001.0); return }
value += cast(float64)bytes[index]
index += 1
}
}
SqliteResultDouble(context, value)
}
Destroy :: (data: *void) {
state := cast(*CallbackState)data
if state != null { state.destroyed += 1 }
}
Query :: (database: *void, expected: float64) -> bool {
statement: *void = null
if SqlitePrepareText(database, "select observe(x'0100ff'),observe(x''),observe(NULL),observe(7),observe('café')", -1, *statement, null) != SQLITE_OK { return false }
defer SqliteFinalize(statement)
return SqliteStep(statement) == SQLITE_ROW &&
SqliteColumnDouble(statement, 0) == expected + 256.0 &&
SqliteColumnDouble(statement, 1) == expected &&
SqliteColumnDouble(statement, 2) == expected - 5.0 &&
SqliteColumnDouble(statement, 3) == expected - 1.0 &&
SqliteColumnDouble(statement, 4) == expected - 3.0
}
#program_export
main :: () -> s32 {
flags: s32 = SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE
database: *void = null
other: *void = null
if SqliteOpenText(":memory:", *database, flags) != SQLITE_OK ||
SqliteOpenText(":memory:", *other, flags) != SQLITE_OK { return 1 }
name: [8]u8 = .{111,98,115,101,114,118,101,0}
first: CallbackState = .{bias=10.0}
second: CallbackState = .{bias=100.0}
replacement: CallbackState = .{bias=20.0}
failed: CallbackState = .{bias=30.0}
final_state: CallbackState = .{bias=40.0}
// SQLITE_UTF8 is SQLite's documented text encoding value 1.
if SqliteCreateFunction(database, *name[0], 1, 1, cast(*void)*first, Observe, null, null, Destroy) != SQLITE_OK ||
SqliteCreateFunction(other, *name[0], 1, 1, cast(*void)*second, Observe, null, null, Destroy) != SQLITE_OK { return 2 }
if !Query(database, 10.0) || !Query(other, 100.0) || !Query(database, 10.0) ||
first.calls != 10 || second.calls != 5 || first.destroyed != 0 || second.destroyed != 0 { return 3 }
// SQLite invokes the replaced registration's destructor synchronously.
if SqliteCreateFunction(database, *name[0], 1, 1, cast(*void)*replacement, Observe, null, null, Destroy) != SQLITE_OK ||
first.destroyed != 1 || replacement.destroyed != 0 || !Query(database, 20.0) ||
!Query(other, 100.0) || second.destroyed != 0 { return 4 }
// A 256-byte UTF-8 name is documented to fail with SQLITE_MISUSE.
// Unlike an invalid argc, it does not invoke undefined SQLite behavior.
too_long: [257]u8
index: s32 = 0
while index < 256 { too_long[index] = cast(u8)120; index += 1 }
too_long[256] = cast(u8)0
if SqliteCreateFunction(database, *too_long[0], 1, 1, cast(*void)*failed, Observe, null, null, Destroy) != SQLITE_MISUSE ||
failed.destroyed != 1 || !Query(database, 20.0) { return 5 }
if SqliteClose(database) != SQLITE_OK || first.destroyed != 1 ||
replacement.destroyed != 1 || failed.destroyed != 1 || second.destroyed != 0 { return 6 }
// All three null function callbacks delete the function, releasing data.
empty: *void = null
no_scalar := cast(SqliteScalar)empty
no_destructor := cast(SqliteDestructor)empty
if SqliteCreateFunction(other, *name[0], 1, 1, null, no_scalar, null, null, no_destructor) != SQLITE_OK || second.destroyed != 1 { return 7 }
if SqliteCreateFunction(other, *name[0], 1, 1, cast(*void)*final_state, Observe, null, null, Destroy) != SQLITE_OK ||
!Query(other, 40.0) || final_state.destroyed != 0 { return 8 }
if SqliteClose(other) != SQLITE_OK || second.destroyed != 1 || final_state.destroyed != 1 ||
first.destroyed != 1 || replacement.destroyed != 1 || failed.destroyed != 1 { return 9 }
return 0
}