public async Task CreateBackup() { var obj1 = new BackupTestObj { Text = "GLaDOS loves testing!" }; var obj2 = new BackupTestObj2 { Text = "Keep testing, just keep testing" }; SQLiteConnection srcDb = new BackupTestDb(TestPath.CreateTemporaryDatabase()); int numIn1 = srcDb.Insert(obj1); Assert.AreEqual(1, numIn1); int numIn2 = srcDb.Insert(obj2); Assert.AreEqual(1, numIn2); const int numInserts = 1000; int inserts = 0; for (int i = 0; i < numInserts; i++) { inserts += srcDb.Insert(new BackupTestObj3()); } Assert.AreEqual(numInserts, inserts); List <BackupTestObj> result1 = srcDb.Query <BackupTestObj>("select * from BackupTestObj").ToList(); Assert.AreEqual(numIn1, result1.Count); Assert.AreEqual(obj1.Text, result1.First().Text); List <BackupTestObj> result2 = srcDb.Query <BackupTestObj>("select * from BackupTestObj2").ToList(); Assert.AreEqual(numIn2, result2.Count); Assert.AreEqual(obj2.Text, result2.First().Text); string destDbPath = await srcDb.CreateDatabaseBackup(); // Assert.IsTrue(File.Exists(destDbPath)); SQLiteConnection destDb = new BackupTestDb(destDbPath); result1 = destDb.Query <BackupTestObj>("select * from BackupTestObj").ToList(); Assert.AreEqual(numIn1, result1.Count); Assert.AreEqual(obj1.Text, result1.First().Text); result2 = destDb.Query <BackupTestObj>("select * from BackupTestObj2").ToList(); Assert.AreEqual(numIn2, result2.Count); Assert.AreEqual(obj2.Text, result2.First().Text); int count = destDb.ExecuteScalar <int>("select count(*) from BackupTestObj3"); Assert.AreEqual(numInserts, count); srcDb.Close(); destDb.Close(); }
public void CreateBackup() { var obj1 = new BackupTestObj { Text = "GLaDOS loves testing!" }; var obj2 = new BackupTestObj2 { Text = "Keep testing, just keep testing" }; SQLiteConnection srcDb = new BackupTestDb(TestPath.GetTempFileName()); int numIn1 = srcDb.Insert(obj1); Assert.AreEqual(1, numIn1); int numIn2 = srcDb.Insert(obj2); Assert.AreEqual(1, numIn2); const int numInserts = 1000; int inserts = 0; for (int i = 0; i < numInserts; i++) { inserts += srcDb.Insert(new BackupTestObj3()); } Assert.AreEqual(numInserts, inserts); List<BackupTestObj> result1 = srcDb.Query<BackupTestObj>("select * from BackupTestObj").ToList(); Assert.AreEqual(numIn1, result1.Count); Assert.AreEqual(obj1.Text, result1.First().Text); List<BackupTestObj> result2 = srcDb.Query<BackupTestObj>("select * from BackupTestObj2").ToList(); Assert.AreEqual(numIn2, result2.Count); Assert.AreEqual(obj2.Text, result2.First().Text); string destDbPath = srcDb.CreateDatabaseBackup(new SQLitePlatformTest()); Assert.IsTrue(File.Exists(destDbPath)); SQLiteConnection destDb = new BackupTestDb(destDbPath); result1 = destDb.Query<BackupTestObj>("select * from BackupTestObj").ToList(); Assert.AreEqual(numIn1, result1.Count); Assert.AreEqual(obj1.Text, result1.First().Text); result2 = destDb.Query<BackupTestObj>("select * from BackupTestObj2").ToList(); Assert.AreEqual(numIn2, result2.Count); Assert.AreEqual(obj2.Text, result2.First().Text); int count = destDb.ExecuteScalar<int>("select count(*) from BackupTestObj3"); Assert.AreEqual(numInserts, count); srcDb.Close(); destDb.Close(); }