mirror of
https://github.com/groue/GRDB.swift
synced 2026-11-22 04:00:39 +00:00
81 lines
3.1 KiB
Swift
81 lines
3.1 KiB
Swift
import XCTest
|
|
@testable import GRDB
|
|
|
|
class DatabasePoolBackupTests: GRDBTestCase {
|
|
|
|
func testBackup() throws {
|
|
// SQLCipher can't backup encrypted databases: use a pristine Configuration
|
|
let source = try makeDatabasePool(filename: "source.sqlite", configuration: Configuration())
|
|
let destination = try makeDatabasePool(filename: "destination.sqlite", configuration: Configuration())
|
|
|
|
try source.write { 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.read { db in
|
|
XCTAssertEqual(try Int.fetchOne(db, sql: "SELECT COUNT(*) FROM items")!, 1)
|
|
}
|
|
|
|
try source.write { db in
|
|
try db.execute(sql: "DROP TABLE items")
|
|
}
|
|
|
|
try source.backup(to: destination)
|
|
|
|
try destination.read { db in
|
|
XCTAssertFalse(try db.tableExists("items"))
|
|
}
|
|
}
|
|
|
|
// TODO: fix flaky test
|
|
// func testConcurrentWriteDuringBackup() throws {
|
|
// let source = try makeDatabasePool(filename: "source.sqlite")
|
|
// let destination = try makeDatabasePool(filename: "destination.sqlite")
|
|
//
|
|
// try source.write { 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)
|
|
// }
|
|
//
|
|
// let s1 = DispatchSemaphore(value: 0)
|
|
// let s2 = DispatchSemaphore(value: 0)
|
|
// DispatchQueue.global().async {
|
|
// _ = s1.wait(timeout: .distantFuture)
|
|
// try! source.writeInTransaction(.immediate) { db in
|
|
// try db.execute(sql: "INSERT INTO items (id) VALUES (NULL)")
|
|
// s2.signal()
|
|
// return .commit
|
|
// }
|
|
// }
|
|
//
|
|
// try destination.writeWithoutTransaction { dbDestination in
|
|
// try source.backup(
|
|
// to: dbDestination,
|
|
// afterBackupInit: {
|
|
// s1.signal()
|
|
// _ = s2.wait(timeout: .distantFuture)
|
|
// },
|
|
// afterBackupStep: {
|
|
// try! source.write { db in
|
|
// try db.execute(sql: "INSERT INTO items (id) VALUES (NULL)")
|
|
// }
|
|
// })
|
|
// }
|
|
//
|
|
// try source.read { db in
|
|
// XCTAssertEqual(try Int.fetchOne(db, sql: "SELECT COUNT(*) FROM items")!, 3)
|
|
// }
|
|
// try destination.read { db in
|
|
// // TODO: understand why the fix for https://github.com/groue/GRDB.swift/issues/102
|
|
// // had this value change from 2 to 1.
|
|
// // TODO: Worse, this test is fragile. I've seen not 1 but 2 once.
|
|
// XCTAssertEqual(try Int.fetchOne(db, sql: "SELECT COUNT(*) FROM items")!, 1)
|
|
// }
|
|
// }
|
|
}
|