Files
sqlite/tests/sqlite_test.zi

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
}