public void RetrieveAllDatabaseNodesTest()
{
DatabasesXmlHandler dbHandler = new DatabasesXmlHandler();
DatabaseInfo dbInfo = new DatabaseInfo();
Guid tmpGuid = Guid.NewGuid();
dbInfo.ID = tmpGuid;
dbInfo.Host = "localhost";
dbInfo.User = "******";
dbInfo.Password = "******";
dbInfo.DatabaseName = "TestDatabase";
dbInfo.StartTime = new TimeSpan(4, 30, 0);
dbInfo.AddUseDatabase = false;
dbInfo.IncludeRoutines = true;
dbHandler.InsertDatabaseNode(dbInfo);
dbInfo.ID = Guid.NewGuid();
dbInfo.DatabaseName = "NewDatabase";
dbHandler.InsertDatabaseNode(dbInfo);
Assert.IsTrue(1 < dbHandler.GetAllDatabaseNodes().Count);
dbHandler.RemoveDatabaseNode(dbInfo.ID);
dbHandler.RemoveDatabaseNode(tmpGuid);
}
public void InsertNewDatabaseNodeToDatabasesXMLFileTest()
{
DatabasesXmlHandler dbHandler = new DatabasesXmlHandler();
DatabaseInfo dbInfo = new DatabaseInfo();
dbInfo.ID = Guid.NewGuid();
dbInfo.Host = "localhost";
dbInfo.User = "******";
dbInfo.Password = "******";
dbInfo.DatabaseName = "test_database";
dbInfo.StartTime = new TimeSpan(4, 30, 0);
dbInfo.AddUseDatabase = false;
dbInfo.IncludeRoutines = true;
dbHandler.InsertDatabaseNode(dbInfo);
XElement document = XElement.Load(ConfigurationHandler.DB_CONFIG_FILE);
var databaseNode = document
.Elements("Database")
.FirstOrDefault(x => x.Attribute("ID").Value == dbInfo.ID.ToString());
string databaseName = databaseNode.Element("Name").Value;
Assert.AreEqual("test_database", databaseName);
//remove the database node we just created
dbHandler.RemoveDatabaseNode(dbInfo.ID);
}
public void UpdateSpecificDatabaseNodeTest()
{
DatabasesXmlHandler dbHandler = new DatabasesXmlHandler();
DatabaseInfo dbInfo = new DatabaseInfo();
dbInfo.ID = Guid.NewGuid();
dbInfo.Host = "localhost";
dbInfo.User = "******";
dbInfo.Password = "******";
dbInfo.DatabaseName = "TestDatabase";
dbInfo.StartTime = new TimeSpan(4, 30, 0);
dbInfo.AddUseDatabase = false;
dbInfo.IncludeRoutines = true;
dbHandler.InsertDatabaseNode(dbInfo);
//modify the dbInfo start time
dbInfo.StartTime = new TimeSpan(22, 59, 0);
dbHandler.UpdateDatabaseNode(dbInfo);
dbInfo = dbHandler.GetDatabaseNode(dbInfo.ID)
;
Assert.AreEqual("22:59:00", dbInfo.StartTime.ToString());
dbHandler.RemoveDatabaseNode(dbInfo.ID);
}
/// <summary>
/// Handles the Click event of the RemoveDatabaseButton control: Deleted the database from the config file.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="RoutedEventArgs"/> instance containing the event data.</param>
private void RemoveDatabaseButton_Click(object sender, RoutedEventArgs e)
{
var result = FirstFloor.ModernUI.Windows.Controls.ModernDialog.ShowMessage(string.Format("Are you sure that you want to remove the database '{0}'?\nThis action can't be undone!", CurrentDbInfo.DatabaseName), "Remove Database", MessageBoxButton.YesNo);
if (result.ToString().ToLower().Equals("yes"))
{
dbHandler.RemoveDatabaseNode(CurrentDbInfo.ID);
new LogHandler().LogMessage(LogHandler.MessageType.INFO, string.Format("The database {0} has been successfully removed", CurrentDbInfo.DatabaseName));
NavigationCommands.GoToPage.Execute(new Uri("/Pages/DatabasesPage.xaml", UriKind.Relative), FirstFloor.ModernUI.Windows.Navigation.NavigationHelper.FindFrame(null, this));
}
}
public void RetrieveSpecificDatabaseNodeTest()
{
DatabasesXmlHandler dbHandler = new DatabasesXmlHandler();
DatabaseInfo dbInfo = new DatabaseInfo();
dbInfo.ID = Guid.NewGuid();
dbInfo.Host = "localhost";
dbInfo.User = "******";
dbInfo.Password = "******";
dbInfo.DatabaseName = "TestDatabase";
dbInfo.StartTime = new TimeSpan(4, 30, 0);
dbInfo.AddUseDatabase = false;
dbInfo.IncludeRoutines = true;
dbHandler.InsertDatabaseNode(dbInfo);
DatabaseInfo dbInfo2 = dbHandler.GetDatabaseNode(dbInfo.ID);
Assert.AreEqual("TestDatabase", dbInfo2.DatabaseName);
dbHandler.RemoveDatabaseNode(dbInfo.ID);
}
public void RemoveSpecificDatabaseNodeTest()
{
DatabasesXmlHandler dbHandler = new DatabasesXmlHandler();
DatabaseInfo dbInfo = new DatabaseInfo();
dbInfo.ID = Guid.NewGuid();
dbInfo.Host = "localhost";
dbInfo.User = "******";
dbInfo.Password = "******";
dbInfo.DatabaseName = "TestDatabase";
dbInfo.StartTime = new TimeSpan(4, 30, 0);
dbInfo.AddUseDatabase = false;
dbInfo.IncludeRoutines = true;
dbHandler.InsertDatabaseNode(dbInfo);
dbHandler.RemoveDatabaseNode(dbInfo.ID);
XElement document = XElement.Load(ConfigurationHandler.DB_CONFIG_FILE);
var databaseNode = document
.Elements("Database")
.FirstOrDefault(x => x.Attribute("ID").Value == dbInfo.ID.ToString());
Assert.IsNull(databaseNode);
}