public async Task OnPostFile2FileMigrationAsync()
{
await _sqliteDb.File2FileMigration();
DeletedEntities = await _sqliteDb.GetDeletedEntitiesInfo();
DatabaseInfo = _sqliteDb.GetSqliteDatabaseInfo();
}
public async Task OnPostClearBaseAsync()
{
await _sqliteDb.ClearDatabase();
await _sqliteDb.Vacuum();
DeletedEntities = await _sqliteDb.GetDeletedEntitiesInfo();
DatabaseInfo = _sqliteDb.GetSqliteDatabaseInfo();
}
private void CreateSqliteDatabase_OnClick(object sender, RoutedEventArgs e)
{
try
{
var sqliteDatabaseInfo = new SqliteDatabaseInfo()
{
DatabasePath = sqlite_databasePath.Text,
Password = sqlite_password.Text
};
sqliteDatabaseInfo.CreateDatabase();
CreateSchema(sqliteDatabaseInfo);
OpenSession(sqliteDatabaseInfo);
MessageBox.Show(string.Format("Database {0} is created", sqlServer_databasePath.Text));
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error");
}
}
public void AppConfigModelTest()
{
Boolean ret;
SqliteDatabaseInfo db = new SqliteDatabaseInfo {
Path = System.Environment.CurrentDirectory, Filename = "test_" + DateTime.Now.ToString("yyyyMMddHHmmss")
};
AppConfigEntity appConfigEntity = new AppConfigEntity(db);
/**********************************************************************************************************/
AppConfig[] insert_entity = new AppConfig[]
{
new AppConfig()
{
Key = "setting.view.enable", Value = "false", Description = "Test"
},
new AppConfig()
{
Key = "setting.view.visible", Value = "false", Description = "Test"
},
new AppConfig()
{
Key = "setting.view.disable", Value = "false", Description = "Test"
},
new AppConfig()
{
Key = "setting.view.LineColor", Value = "red", Description = "Test"
},
new AppConfig()
{
Key = "setting.view.BackColor", Value = "blue", Description = "Test"
},
new AppConfig()
{
Key = "setting.view.TaskBarColor", Value = "green", Description = "Test"
}
};
/**********************************************************************************************************/
AppConfig[] delete_entity = new AppConfig[]
{
new AppConfig()
{
Id = 2
},
new AppConfig()
{
Id = 4
}
};
/**********************************************************************************************************/
AppConfig[] update_entity = new AppConfig[2];
update_entity[0] = insert_entity[2]; update_entity[0].Id = 3; update_entity[0].Value = "true";
update_entity[1] = insert_entity[4]; update_entity[1].Id = 5; update_entity[1].Value = "black";
/**********************************************************************************************************/
try
{
appConfigEntity.CreateTable();
foreach (var item in insert_entity)
{
appConfigEntity.Insert(item);
}
AppConfig[] select_entity = appConfigEntity.Select();
foreach (var item in delete_entity)
{
appConfigEntity.Delete(item);
}
foreach (var item in update_entity)
{
appConfigEntity.Update(item);
}
ret = true;
}
catch (Exception ex)
{
Console.Write(ex.Message);
ret = false;
}
Assert.IsTrue(ret);
}
public async Task OnGetAsync()
{
DeletedEntities = await _sqliteDb.GetDeletedEntitiesInfo();
DatabaseInfo = _sqliteDb.GetSqliteDatabaseInfo();
}
