mirror of
https://github.com/groue/GRDB.swift
synced 2026-11-22 04:00:39 +00:00
34 lines
1.2 KiB
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"))
|
|
}
|
|
}
|
|
}
|