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