121 lines
6.2 KiB
Ziran
121 lines
6.2 KiB
Ziran
#import "SQLite"
|
|
|
|
// Reads a NUL-terminated column value as text.
|
|
Same :: (value: *u8, expected: string) -> bool {
|
|
if value == null {
|
|
return false
|
|
}
|
|
index: s64 = 0
|
|
while index < expected.count {
|
|
if value[index] != expected[index] {
|
|
return false
|
|
}
|
|
index += 1
|
|
}
|
|
return value[expected.count] == cast(u8)0
|
|
}
|
|
|
|
#program_export
|
|
main :: () -> s32 {
|
|
path: [9]u8 = .{58, 109, 101, 109, 111, 114, 121, 58, 0}
|
|
database: *void = null
|
|
flags: s32 = SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE
|
|
if SqliteOpen(*path[0], *database, flags) != SQLITE_OK || database == null {
|
|
return 1
|
|
}
|
|
if SqliteGetAutocommit(null) || !SqliteGetAutocommit(database) { return 30 }
|
|
if SqliteExecText(database, "BEGIN") != SQLITE_OK || SqliteGetAutocommit(database) { return 31 }
|
|
if SqliteExecText(database, "COMMIT") != SQLITE_OK || !SqliteGetAutocommit(database) { return 32 }
|
|
if SqliteExecText(database, "BEGIN IMMEDIATE") != SQLITE_OK || SqliteGetAutocommit(database) { return 33 }
|
|
if SqliteExecText(database, "ROLLBACK") != SQLITE_OK || !SqliteGetAutocommit(database) { return 34 }
|
|
if SqliteExecText(database, "create table votes (voter text not null, score integer not null)") != SQLITE_OK {
|
|
return 2
|
|
}
|
|
statement: *void = null
|
|
if SqlitePrepareText(database, "insert into votes (voter, score) values (?, ?)", -1, *statement, null) != SQLITE_OK {
|
|
return 3
|
|
}
|
|
// Binding copies the text, so a temporary Ziran string is safe.
|
|
if SqliteBindTextString(statement, 1, "Café \"night\"", -1) != SQLITE_OK ||
|
|
SqliteBindInt(statement, 2, -3) != SQLITE_OK ||
|
|
SqliteStep(statement) != SQLITE_DONE {
|
|
return 4
|
|
}
|
|
if SqliteReset(statement) != SQLITE_OK || SqliteClearBindings(statement) != SQLITE_OK {
|
|
return 5
|
|
}
|
|
if SqliteBindTextString(statement, 1, "bob", -1) != SQLITE_OK ||
|
|
SqliteBindInt64(statement, 2, 5000000000) != SQLITE_OK ||
|
|
SqliteStep(statement) != SQLITE_DONE {
|
|
return 6
|
|
}
|
|
if SqliteLastInsertRowid(database) != 2 {
|
|
return 16
|
|
}
|
|
if SqliteFinalize(statement) != SQLITE_OK {
|
|
return 7
|
|
}
|
|
if SqlitePrepareText(database, "select voter, score from votes order by rowid", -1, *statement, null) != SQLITE_OK {
|
|
return 8
|
|
}
|
|
if SqliteStep(statement) != SQLITE_ROW || !Same(SqliteColumnText(statement, 0), "Café \"night\"") ||
|
|
SqliteColumnInt(statement, 1) != -3 {
|
|
return 9
|
|
}
|
|
if SqliteStep(statement) != SQLITE_ROW || SqliteColumnInt64(statement, 1) != 5000000000 {
|
|
return 10
|
|
}
|
|
if SqliteStep(statement) != SQLITE_DONE || SqliteFinalize(statement) != SQLITE_OK {
|
|
return 11
|
|
}
|
|
// A statement longer than the short buffers takes the allocated path.
|
|
long_sql := "select 1 "
|
|
if SqlitePrepareText(database, long_sql, -1, *statement, null) != SQLITE_OK ||
|
|
SqliteStep(statement) != SQLITE_ROW || SqliteColumnInt(statement, 0) != 1 ||
|
|
SqliteFinalize(statement) != SQLITE_OK {
|
|
return 12
|
|
}
|
|
if SqliteExecText(database, "not sql") == SQLITE_OK {
|
|
return 13
|
|
}
|
|
if SqliteErrorCode(database) == SQLITE_OK || SqliteErrorMessage(database) == null ||
|
|
SqliteVersionNumber() < 3000000 || SqliteBusyTimeout(database, 100) != SQLITE_OK { return 17 }
|
|
if SqliteExecText(database, "create table binary_values (data blob, value real, absent text)") != SQLITE_OK { return 18 }
|
|
if SqlitePrepareText(database, "insert into binary_values values (?, ?, ?)", -1, *statement, null) != SQLITE_OK { return 19 }
|
|
blob: [3]u8 = .{1, 0, 255}
|
|
if SqliteBindBlob(statement, 1, blob[:]) != SQLITE_OK ||
|
|
SqliteBindDouble(statement, 2, 1.25) != SQLITE_OK ||
|
|
SqliteBindNull(statement, 3) != SQLITE_OK { return 20 }
|
|
// Bind copied the original binary data.
|
|
blob[0] = cast(u8)99
|
|
if SqliteStep(statement) != SQLITE_DONE || SqliteChanges(database) != 1 { return 21 }
|
|
if SqliteReset(statement) != SQLITE_OK ||
|
|
SqliteBindBlob(statement, 1, blob[0:0]) != SQLITE_OK ||
|
|
SqliteStep(statement) != SQLITE_DONE || SqliteFinalize(statement) != SQLITE_OK { return 22 }
|
|
if SqlitePrepareText(database, "select data, value, absent from binary_values order by rowid", -1, *statement, null) != SQLITE_OK { return 23 }
|
|
if SqliteStep(statement) != SQLITE_ROW || SqliteColumnCount(statement) != 3 ||
|
|
SqliteColumnType(statement, 0) != SQLITE_BLOB || SqliteColumnBytes(statement, 0) != 3 ||
|
|
SqliteColumnDouble(statement, 1) != 1.25 || SqliteColumnType(statement, 2) != SQLITE_NULL { return 24 }
|
|
bytes := SqliteColumnBlob(statement, 0)
|
|
if bytes == null || bytes[0] != 1 || bytes[1] != 0 || bytes[2] != 255 { return 25 }
|
|
if SqliteStep(statement) != SQLITE_ROW || SqliteColumnType(statement, 0) != SQLITE_BLOB ||
|
|
SqliteColumnBytes(statement, 0) != 0 || SqliteFinalize(statement) != SQLITE_OK { return 26 }
|
|
copy: *void = null
|
|
if SqliteOpenText(":memory:", *copy, flags) != SQLITE_OK { return 27 }
|
|
backup := SqliteBackupInit(copy, database)
|
|
if backup == null || SqliteBackupStep(backup, -1) != SQLITE_DONE ||
|
|
SqliteBackupFinish(backup) != SQLITE_OK { return 28 }
|
|
if SqlitePrepareText(copy, "select count(*) from binary_values", -1, *statement, null) != SQLITE_OK ||
|
|
SqliteStep(statement) != SQLITE_ROW || SqliteColumnInt(statement, 0) != 2 ||
|
|
SqliteFinalize(statement) != SQLITE_OK || SqliteClose(copy) != SQLITE_OK { return 29 }
|
|
// A tail pointer is refused: the copied SQL does not outlive the call.
|
|
tail: *u8 = null
|
|
if SqlitePrepareText(database, "select 1", -1, *statement, *tail) != SQLITE_MISUSE {
|
|
return 14
|
|
}
|
|
if SqliteClose(database) != SQLITE_OK {
|
|
return 15
|
|
}
|
|
return 0
|
|
}
|