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();
}
