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); }
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); }
/// <summary> /// Adds a database node to the list. /// </summary> /// <param name="dbInfo">The database information.</param> public void addDatabase(DatabaseInfo dbInfo) { this.databases.Add(dbInfo); dbHandler.InsertDatabaseNode(dbInfo); new LogHandler().LogMessage(LogHandler.MessageType.INFO, string.Format("The database {0} is now ready for backup", dbInfo.DatabaseName)); }