public static void storeTestRun(MightyOrm db, MightyOrm dbTc, MightyOrm dbTestResult, TestRun tr) { var insert = db.New(); insert.Category = tr.Category; insert.Sha256 = tr.Sha256; insert.Filename = tr.Filename; db.Insert(insert); List <TestCase> testCases = tr.TestCases; if (testCases != null && testCases.Count > 0) { foreach (TestCase tc in testCases) { DatabaseConnector.storeTestCase(dbTc, dbTestResult, tc, insert.TestRunID); } } Console.WriteLine(insert.TestRunID); }
static void Main(string[] args) { // Console.WriteLine("Hello World!"); /* * * string path = @"C:\Users\amccaff\src\TQP\TaskQueueProcessor\TaskQueueProcessor\sample.json"; * * string json = File.ReadAllText(path); * TestRun testRun = TestRun.generateTestRun(json); * Console.WriteLine(testRun.DateTimeStamp); * Console.WriteLine(testRun.TestCases.ElementAt(0).BitstringMCVEstimateMode); * Console.WriteLine(testRun.TestCases.ElementAt(0).TestResults.ElementAt(0).AvgCollision); */ // MightyOrm db = new MightyOrm("Server=localhost\\SQLEXPRESS;Database=TaskQueueProcessor;ProviderName=System.Data.SqlClient;User=user;Password=user","TestResult","TestResultID"); // Object thing = db.Execute("SELECT * FROM TaskQueue"); // Object thing = db.Single("SELECT * FROM TaskQueue WHERE 1=1"); // dynamic tq = db.Single("SELECT * FROM TaskQueue WHERE TaskID = 1"); //dynamic tq = db.Single(1); //TaskQueue taskQueue = (TaskQueue) tq; //Console.WriteLine($"{tq.TaskType}"); /* * TestRun tr = new TestRun(); * tr.Category = 1; * tr.Sha256 = "FakeShaHereAgain"; * tr.Filename = "filename2.txt"; * DatabaseConnector.storeTestRun(db, tr); */ /* * TestCase tc = new TestCase(); * tc.BinLrsRes = 0.12345; * tc.TestCaseDesc = "Look at me!"; * //db.TableName = "TestCase"; * //db.PrimaryKeyInfo = "TestCaseID"; * DatabaseConnector.storeTestCase(db,tc,"2"); */ /* * //TestResult tr = new TestResult(); * tr.Compression = 0.0123456; * tr.Iteration = "123"; * * DatabaseConnector.storeTestResult(db, tr, "1"); */ MightyOrm dbTestRun = new MightyOrm("Server=localhost\\SQLEXPRESS;Database=TaskQueueProcessor;ProviderName=System.Data.SqlClient;User=user;Password=user", "TestRun", "TestRunID"); MightyOrm dbTestCase = new MightyOrm("Server=localhost\\SQLEXPRESS;Database=TaskQueueProcessor;ProviderName=System.Data.SqlClient;User=user;Password=user", "TestCase", "TestCaseID"); MightyOrm dbTestResult = new MightyOrm("Server=localhost\\SQLEXPRESS;Database=TaskQueueProcessor;ProviderName=System.Data.SqlClient;User=user;Password=user", "TestResult", "TestResultID"); TestRun tr = new TestRun(); tr.Category = 2; tr.Sha256 = "FakeSha256"; tr.Filename = "file.txt"; TestCase tc = new TestCase(); tc.TestCaseDesc = "Check out my fake description"; tc.HOriginal = 1.23456; tc.HBitstring = 0.0001; TestResult testResult = new TestResult(); testResult.Iteration = "123"; testResult.Excursion = 0.5; tc.TestResults.Add(testResult); tr.TestCases.Add(tc); DatabaseConnector.storeTestRun(dbTestRun, dbTestCase, dbTestResult, tr); }
static public TestRun generateTestRun(String json) { TestRun testRun = JsonSerializer.Deserialize <TestRun>(json); return(testRun); }