public void UpdateThrowsExceptionWhenNoWhereandNoPrimaryKey() { var success = false; //this really writes to the db. So it is disabled. /* */ SqlDataService db = new SqlDataService(AppSettingsReader.GetSettings().GetSection("Sql_Con_String").Value, new FileLogger()); Random rand = new Random(); var log = new Log() { Message = "Test " + rand.Next(0, 100), ApplicationId = int.Parse(AppSettingsReader.GetSettings().GetSection("ApplicationId").Value) }; try { success = db.UpdateData(log); } catch (SqlException e) { Assert.IsTrue(false); } catch { Assert.IsTrue(true); } Assert.IsFalse(success); }
public void CanInsertMultipleRowsToDbQuickly() { var success = true; //this really writes to the db. So it is disabled. /* */ Stopwatch sw = new Stopwatch(); SqlDataService db = new SqlDataService(AppSettingsReader.GetSettings().GetSection("Sql_Con_String").Value, new FileLogger()); var log1 = new Log() { Message = "Test1", ApplicationId = int.Parse(AppSettingsReader.GetSettings().GetSection("ApplicationId").Value) }; var log2 = new Log() { Message = "Test2", ApplicationId = int.Parse(AppSettingsReader.GetSettings().GetSection("ApplicationId").Value) }; var logs = new List <Log>() { log1, log2 }; Assert.AreEqual(log1.ApplicationId, 3); Assert.AreEqual(log2.ApplicationId, 3); sw.Start(); success = db.BulkInsertData(logs); sw.Stop(); Assert.IsTrue(sw.ElapsedMilliseconds <= 3000); Assert.IsTrue(success); }
public void CanGetDbInfoQuickly() { var success = true; //this really reads from the db. It is disabled. Stopwatch sw = new Stopwatch(); SqlDataService db = new SqlDataService(AppSettingsReader.GetSettings().GetSection("Sql_Con_String").Value, new FileLogger()); /**/ sw.Start(); var logs = db.GetData <Log>(); sw.Stop(); Assert.IsTrue(sw.ElapsedMilliseconds <= 5000); Stopwatch sw2 = new Stopwatch(); sw2.Start(); var condensedLogs = db.GetData <Log>("WHERE ApplicationId = 3", "Logs"); sw2.Stop(); Assert.IsTrue(sw2.ElapsedMilliseconds <= 5000); Assert.IsTrue(success); } [TestMethod] public void CanGetDbInfoWithString() { var success = true; //this really reads from the db. It is disabled. Stopwatch sw = new Stopwatch(); ISqlDataService db = new SqlDataService(AppSettingsReader.GetSettings().GetSection("Sql_Con_String").Value, new FileLogger()); /**/ sw.Start(); var sprocs = db.GetData <string>($@"Select Distinct ExceptionAsJson From [MyAwesome].[dbo].[Logs] WHERE ApplicationId = 3", System.Data.CommandType.Text); sw.Stop(); Assert.IsTrue(sw.ElapsedMilliseconds <= 2000); Assert.IsTrue(success); }
public void CanWriteToSqlDb() { var success = true; //this really writes to the db. So it is disabled. /* */ var conString = AppSettingsReader.GetSettings().GetSection("Sql_Con_String").Value; SqlDataService db = new SqlDataService(AppSettingsReader.GetSettings().GetSection("Sql_Con_String").Value, new FileLogger()); var log = new Log() { Message = "Test", ApplicationId = int.Parse(AppSettingsReader.GetSettings().GetSection("ApplicationId").Value) }; Assert.AreEqual(log.ApplicationId, 3); success = db.InsertData(log); Assert.IsTrue(success); }
public void CanUpdateToSqlDbUsingWhereClause() { var success = true; //this really writes to the db. So it is disabled. /* */ SqlDataService db = new SqlDataService(AppSettingsReader.GetSettings().GetSection("Sql_Con_String").Value, new FileLogger()); Random rand = new Random(); var log = new Log() { Message = "Test " + rand.Next(0, 100), ApplicationId = int.Parse(AppSettingsReader.GetSettings().GetSection("ApplicationId").Value) }; success = db.UpdateData(log, "Where LogId = 32", "Logs"); var newLog = db.GetData <Log>("Where Logid = 32"); Assert.AreEqual(newLog.FirstOrDefault().Message, log.Message); Assert.IsTrue(success); }
public void CanWriteToSqlDbQuickly() { var success = true; //this really writes to the db. So it is disabled. /* */ Stopwatch sw = new Stopwatch(); SqlDataService db = new SqlDataService(AppSettingsReader.GetSettings().GetSection("Sql_Con_String").Value, new FileLogger()); var log = new Log() { Message = "Test", ApplicationId = int.Parse(AppSettingsReader.GetSettings().GetSection("ApplicationId").Value) }; Assert.AreEqual(log.ApplicationId, 3); sw.Start(); success = db.InsertData(log); sw.Stop(); Assert.IsTrue(sw.ElapsedMilliseconds <= 1000); Assert.IsTrue(success); }
public void DoesNotOverwriteSetFieldsWithUnspecifiedFields() { var success = true; //this really writes to the db. So it is disabled. /* */ SqlDataService db = new SqlDataService(AppSettingsReader.GetSettings().GetSection("Sql_Con_String").Value, new FileLogger()); Random rand = new Random(); var roll = rand.Next(0, 100); var log = new Log() { LogId = 33, Message = "Test " + roll, ApplicationId = int.Parse(AppSettingsReader.GetSettings().GetSection("ApplicationId").Value), ExceptionMessage = "Test " + roll }; db.UpdateData(log); var roll2 = 101; //exception is null, it won't set. var log2 = new Log() { LogId = 33, Message = "Test " + roll2, ApplicationId = int.Parse(AppSettingsReader.GetSettings().GetSection("ApplicationId").Value), }; db.UpdateData(log2); var newLog = db.GetData <Log>("Where Logid = 33"); Assert.AreEqual(newLog.FirstOrDefault().Message, log2.Message); Assert.AreEqual(newLog.FirstOrDefault().ExceptionMessage, log.ExceptionMessage); Assert.IsTrue(success); }
public void CanUpdateMultipleRowsToDbQuickly() { var success = true; //this really writes to the db. So it is disabled. /* */ Stopwatch sw = new Stopwatch(); SqlDataService db = new SqlDataService(AppSettingsReader.GetSettings().GetSection("Sql_Con_String").Value, new FileLogger()); var log1 = new Log() { LogId = 66, Message = "Test1 Bulk Update ID 66", ApplicationId = int.Parse(AppSettingsReader.GetSettings().GetSection("ApplicationId").Value) }; var log2 = new Log() { LogId = 67, Message = "Test2 Bulk Update ID 67", ExceptionMessage = "Fake Exception Message, man. 2k length but it comes in from Max.", ApplicationId = int.Parse(AppSettingsReader.GetSettings().GetSection("ApplicationId").Value) }; var logs = new List <Log>() { log1, log2 }; Assert.AreEqual(log1.ApplicationId, 3); Assert.AreEqual(log2.ApplicationId, 3); sw.Start(); success = db.BulkUpdateData(logs); sw.Stop(); Assert.IsTrue(sw.ElapsedMilliseconds <= 6000); Assert.IsTrue(success); }