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);
}
