Files
GRDB.swift/Tests/GRDBTests/DatabaseQueueSchemaCacheTests.swift

49 lines
1.6 KiB
Swift

import XCTest
@testable import GRDB
class DatabaseQueueSchemaCacheTests : GRDBTestCase {
func testCache() throws {
let dbQueue = try makeDatabaseQueue()
try dbQueue.inDatabase { db in
try db.execute(sql: "CREATE TABLE items (id INTEGER PRIMARY KEY)")
}
dbQueue.inDatabase { db in
// Assert that cache is empty
XCTAssertTrue(db.schemaCache.primaryKey("items") == nil)
}
try dbQueue.inDatabase { db in
// Warm cache
let primaryKey = try db.primaryKey("items")
XCTAssertEqual(primaryKey.rowIDColumn, "id")
// Assert that cache is warmed
XCTAssertTrue(db.schemaCache.primaryKey("items") != nil)
}
try dbQueue.inDatabase { db in
// Empty cache after schema change
try db.execute(sql: "DROP TABLE items")
// Assert that cache is empty
XCTAssertTrue(db.schemaCache.primaryKey("items") == nil)
}
try dbQueue.inDatabase { db in
do {
// Assert that cache is used: we expect an error now that
// the cache is empty.
_ = try db.primaryKey("items")
XCTFail()
} catch let error as DatabaseError {
XCTAssertEqual(error.resultCode, .SQLITE_ERROR)
XCTAssertEqual(error.message!, "no such table: items")
XCTAssertEqual(error.description, "SQLite error 1: no such table: items")
}
}
}
}