Ejemplo n.º 1
0
 public void TestRunDownloadScript()
 {
     using (StringWriter sw = new StringWriter())
     {
         Console.SetOut(sw);
         string[]      updateResult     = LoadXML.RunDownloadScript();
         string[]      makePrettyResult = LoadXML.RunDownloadScript(function: LoadXML.Functions.MAKE_PRETTY_XML);
         List <string> filePaths        = new List <string>(updateResult.Concat(makePrettyResult));
         foreach (string s in filePaths)
         {
             Assert.IsTrue(File.Exists(s.Trim('\"')), s.Trim('\"'));
         }
         List <string> expected = sw.ToString().Split('\n').ToList <string>();
         #region Assertions
         Assert.AreEqual("UPDATE_XML\r", expected[0]);
         Assert.AreEqual("Selected file:" + "\"" + updateResult[0] + "\"" + "\r", expected[1]);
         Assert.AreEqual("Downloading data from Lotto.pl server. Progress:\r", (expected[3]));
         Assert.AreEqual("********************************************************************************\r", (expected[4]));
         Assert.IsTrue(expected[5].Contains("Processed") & expected[5].Contains("days"));
         Assert.AreEqual("Function UPDATE_XML has finished", expected[expected.Count - 10]);
         Assert.AreEqual("MAKE_PRETTY_XML\r", expected[expected.Count - 8]);
         Assert.AreEqual("File has been formated.\r", expected[expected.Count - 5]);
         Assert.AreEqual("Function MAKE_PRETTY_XML has finished", expected[expected.Count - 3]);
         #endregion
     }
 }
Ejemplo n.º 2
0
        static void Main(string[] args)
        {
            //LoadXML.RunDownloadScript(function : LoadXML.Functions.UPDATE_XML);
            //LoadXML.RunDownloadScript(function: LoadXML.Functions.MAKE_PRETTY_XML);


            //ExportDrawsToSQL exportToSQL = new ExportDrawsToSQL(new SQLUtils.ConnectionString(@"(localdb)\MSSQLLocalDB", "Lotto", true, "RawData"));
            //exportToSQL.ExportDrawsListToSQL(LoadXML.DeserializeXML());

            //bool c = SQLQueries.procedure_ValidateDatabaseRowNumbers(new SQLUtils.ConnectionString(@"(localdb)\MSSQLLocalDB", "Lotto", true, "RawData").ToString());

            LoadXML.RunDownloadScript();
            Console.WriteLine("Done");
            Console.ReadKey();
        }