public void TestFilteredInsert() { var id = Guid.NewGuid().ToString(); var t1 = new testClass { channel = "ch1", username = "******", password = "******", sessionId = id }; var username = typeof(testClass).GetProperty("username"); var password = typeof(testClass).GetProperty("password"); var res = dbc.Insert(t1, new List <PropertyInfo> { username, password }); Assert.AreEqual(1, res); var inserted = dbc.SelectSingle <testClass>(new { sessionId = id }); Assert.IsNotNull(inserted); Assert.IsTrue(inserted.channel.Equals("ch1")); Assert.IsNull(inserted.password); var del = dbc.Delete <testClass>(new { sessionId = id }); Assert.AreEqual(del, 1); }
public void TestInsert() { var t1 = new testClass { channel = "ch1", username = "******", password = "******", sessionId = Guid.NewGuid().ToString() }; var res = dbc.Insert(t1); Assert.AreEqual(1, res); }
public void TestSelect() { string session = Guid.NewGuid().ToString(); var t1 = new testClass { channel = "ch1", username = "******", password = "******", sessionId = session }; var t2 = new testClass { channel = "ch2", username = "******", password = "******", sessionId = session }; var t3 = new testClass { channel = "ch3", username = "******", password = "******", sessionId = session }; dbc.Insert(t1); dbc.Insert(t2); dbc.Insert(t3); object whereObj = new { sessionId = session }; var res = dbc.Select <testClass>(whereObj); Assert.IsNotNull(res); Assert.AreEqual(3, res.ToList().Count()); object whereObj2 = new { sessionId = session, channel = "ch1" }; var res2 = dbc.Select <testClass>(whereObj2); Assert.IsNotNull(res2); Assert.AreEqual(1, res2.Count()); var res3 = dbc.Select <testClass>(); Assert.IsNotNull(res3); Assert.IsTrue(res3.Count() >= 3); }
public void TestDelete() { string session = Guid.NewGuid().ToString(); var t1 = new testClass { channel = "ch1", username = "******", password = "******", sessionId = session }; var res = dbc.Insert(t1); Assert.AreEqual(1, res); object whereObj = new { sessionId = session, channel = "ch1" }; res = dbc.Delete <testClass>(whereObj); Assert.AreEqual(1, res); }
public void TestUpdateOptions4OracleDb() { string session = Guid.NewGuid().ToString(); var t1 = new testClass { channel = "ch1", username = "******", password = "******", sessionId = session }; var res = dbc.Insert(t1, options: Options); Assert.AreEqual(1, res); object updateObj = new { channel = "ch2" }; object whereObj = new { sessionId = session, channel = "ch1" }; res = dbc.Update <testClass>(updateObj, whereObj, options: Options); Assert.AreEqual(1, res); }
public void TestUpdateOptions4SqlServer() { DMLOptions.CurrentOptions = new DMLOptions('@', "R0_", '[', ']'); string session = Guid.NewGuid().ToString(); var t1 = new testClass { channel = "ch1", username = "******", password = "******", sessionId = session }; var res = dbc.Insert(t1, options: DMLOptions.DefaultOptions); Assert.AreEqual(1, res); object updateObj = new { channel = "ch2" }; object whereObj = new { sessionId = session, channel = "ch1" }; res = dbc.Update <testClass>(updateObj, whereObj); Assert.AreEqual(1, res); }