Files
GRDB.swift/Tests/GRDBTests/DatabaseQueueBackupTests.swift

34 lines
1.2 KiB
Swift

import XCTest
import GRDB
class DatabaseQueueBackupTests: GRDBTestCase {
func testBackup() throws {
// SQLCipher can't backup encrypted databases: use a pristine Configuration
let source = try makeDatabaseQueue(filename: "source.sqlite", configuration: Configuration())
let destination = try makeDatabaseQueue(filename: "destination.sqlite", configuration: Configuration())
try source.inDatabase { db in
try db.execute(sql: "CREATE TABLE items (id INTEGER PRIMARY KEY)")
try db.execute(sql: "INSERT INTO items (id) VALUES (NULL)")
XCTAssertEqual(try Int.fetchOne(db, sql: "SELECT COUNT(*) FROM items")!, 1)
}
try source.backup(to: destination)
try destination.inDatabase { db in
XCTAssertEqual(try Int.fetchOne(db, sql: "SELECT COUNT(*) FROM items")!, 1)
}
try source.inDatabase { db in
try db.execute(sql: "DROP TABLE items")
}
try source.backup(to: destination)
try destination.inDatabase { db in
XCTAssertFalse(try db.tableExists("items"))
}
}
}