Ejemplo n.º 1
0
        private static void Process()
        {
            do
            {
                Log("-----------------------------");
                Log("  GV = GraphViz");
                Log("  CX = Convert .csv to .xml");
                Log("  TH = Convert .txt to .html");
                Log("  XT = XML table");
                Log("-----------------------------");
                List <string> commands = new List <string>()
                {
                    "GV", "CX", "TH", "XT"
                };

                string command = cw.Ask(new QAManager(commands, "GV", "Select a tool"));
                switch (command.ToUpper())
                {
                case "C":
                {
                    return;
                }

                case "GV":
                {
                    GraphViz();
                    break;
                }

                case "CX":
                {
                    csvToXml = new CsvToXml(ow, configXml);
                    csvToXml.Start();
                    break;
                }

                case "TH":
                {
                    txtToHtml = new TxtToHtml(ow, configXml);
                    txtToHtml.Start();
                    break;
                }

                case "XT":
                {
                    xDbM = new XmlDBManager(ow, configXml);
                    xDbM.LoadDFD();
                    xDbM.SaveDFD();
                    break;
                }
                }
                Log(OK);
                xm.Save();
            } while (true);
        }
Ejemplo n.º 2
0
        public void XmlDBManager()
        {
            sm = new SettingsManager(configXml, "xmldbmanager");
            Assert.IsNotEmpty(sm.SelectElementValue("baseFolderPath"));
            Assert.IsNotEmpty(sm.SelectElementValue("dBFileName"));
            string DBPath      = Path.Combine(sm.SelectElementValue("baseFolderPath"), sm.SelectElementValue("dBFileName"));
            string DBPath_Test = Path.Combine(sm.SelectElementValue("baseFolderPath"), "DB_Test.xml");
            var    dm          = new XmlDBManager(configXml);

            // Load DFD
            dm.DFDPath = DBPath;
            dm.LoadDFD();
            // Delete Test DFD
            dm.DFDPath = DBPath_Test;
            dm.DeleteDFD();
            Assert.IsFalse(File.Exists(DBPath_Test));
            // Create Test DFD
            dm.DFDPath = DBPath_Test;
            dm.SaveDFD();
            Assert.IsTrue(File.Exists(DBPath_Test));
            // Create a table in Test DFD
            dm.DFDPath = DBPath_Test;
            XElement newTable1 =
                new XElement("table", new XAttribute("name", "coordinates"),
                             new XElement("Name", new XAttribute("type", "string")),
                             new XElement("Latitude", new XAttribute("type", "int")),
                             new XElement("Longitude", new XAttribute("type", "int")));

            dm.CreateDFDTable(newTable1);
            Assert.IsNotNull(dm.GetTableRef("coordinates"));
            // Delete the table in Test DFD
            dm.DeleteDFDTable("coordinates");
            Assert.IsNull(dm.GetTableRef("coordinates"));
            // Create table "coordinates" again (now from existing DFD)
            newTable1 =
                new XElement("table", new XAttribute("name", "coordinates"),
                             new XElement("Name", new XAttribute("type", "string")),
                             new XElement("Latitude", new XAttribute("type", "int")),
                             new XElement("Longitude", new XAttribute("type", "int")));
            dm.CreateDFDTable(newTable1);
            // Create a second table "people"
            XElement newTable2 =
                new XElement("table", new XAttribute("name", "people"),
                             new XElement("Firstname", new XAttribute("type", "string")),
                             new XElement("Lastname", new XAttribute("type", "string")),
                             new XElement("Initials", new XAttribute("type", "string")));

            dm.CreateDFDTable(newTable2);
            // Delete 2nd table
            dm.DeleteDFDTable("people");
            Assert.IsNull(dm.GetTableRef("people"));
            Assert.IsNotNull(dm.GetTableRef("coordinates"));
            // Add 2nd table again
            newTable2 =
                new XElement("table", new XAttribute("name", "people"),
                             new XElement("Firstname", new XAttribute("type", "string")),
                             new XElement("Lastname", new XAttribute("type", "string")),
                             new XElement("Initials", new XAttribute("type", "string")));
            dm.CreateDFDTable(newTable2);
            // Save to disk, load and verify that the 2 tables must exist.
            dm.SaveDFD();
            dm.LoadDFD();
            Assert.IsNotNull(dm.GetTableRef("coordinates"));
            Assert.IsNotNull(dm.GetTableRef("people"));
            // Delete 1st table
            dm.DeleteDFDTable("coordinates");
            Assert.IsNull(dm.GetTableRef("coordinates"));
            Assert.IsNotNull(dm.GetTableRef("people"));
            // Delete 2nd table
            dm.DeleteDFDTable("people");
            Assert.IsNull(dm.GetTableRef("people"));
            // Save to disk, load and verify that the 2 tables do not exist.
            dm.SaveDFD();
            dm.LoadDFD();
            Assert.IsNull(dm.GetTableRef("coordinates"));
            Assert.IsNull(dm.GetTableRef("people"));
        }