//[TestMethod]
public void CanCreateBaselineDatabase()
{
SettingsRepository repo = new SettingsRepository();
List<string> filesToRun = repo.GetSchemaChangeScripts(@"C:\Development\Nada\NadaNtd\Nada.UI\DatabaseScripts\Differentials\");
string result = repo.RunSchemaChangeScripts(filesToRun);
Assert.IsTrue(result.Length == 0);
}
public void DoUpdateDatabase()
{
SettingsRepository repo = new SettingsRepository();
//List<string> filesToRun = new List<string> { @"C:\Users\jed\Source\Repos\NadaNTD\Nada.UI\DatabaseScripts\ScriptDiffTest.sql" };
List<string> filesToRun = new List<string> { @"C:\Development\Nada\NadaNtd\Nada.UI\DatabaseScripts\ScriptDiffTest.sql" };
string result = repo.RunSchemaChangeScripts(filesToRun);
Assert.IsTrue(result.Length == 0);
}
void worker_DoWork(object sender, DoWorkEventArgs e)
{
try
{
SettingsRepository repo = new SettingsRepository();
e.Result = repo.RunSchemaChangeScripts((List<string>)e.Argument);
}
catch (Exception ex)
{
Logger log = new Logger();
log.Error("Error updating database. UpdateDb:worker_DoWork. ", ex);
e.Result = new ImportResult(Translations.UnexpectedException + " " + ex.Message);
}
}
