public void ANDYCOW0_Update()
{
DBObject dbObj = new DBObject()
{
DataBaseType = DBObject.DataBase.Oracle,
ID = "cgh",
Password = "******",
Node = "jiatest4",
IP = "10.31.11.118"
};
DAOFactory factory = new DAOFactory(dbObj);
var daoObject = factory.GetDataAccessObjectFactory();
var andycow0 = new ANDYCOW0()
{
//FIRST = "66",
SECOND = 7,
THIRD = DateTime.Now//.AddDays(-1)
};
var target = daoObject.Update <ANDYCOW0>(andycow0, (x) => x.FIRST.Contains("6"));
bool result = false;
if (target.IsSuccess && target.EffectRows > 0)
{
result = true;
}
Assert.AreEqual(true, result);
}
//[TestMethod()]
public void Andycow0Delete()
{
DBObject dbObj = new DBObject()
{
DataBaseType = DBObject.DataBase.Oracle,
ID = "cgh", //"cghopr",
Password = "******", //"oprappl",
//Node = "lnka2"
Node = "jiatest4",
IP = "10.31.11.118"//
};
var first = testContextInstance.DataRow[0].ToString();
var second = Int32.Parse(testContextInstance.DataRow[1].ToString());
var third = DateTime.ParseExact(testContextInstance.DataRow[2].ToString(), "yyyyMMddHHmmss", null);
//var fourth = testContextInstance.DataRow[3].ToString();
ANDYCOW0 andycow0 = new ANDYCOW0()
{
FIRST = first,
SECOND = second,
THIRD = third
};
DAOFactory factory = new DAOFactory(dbObj);
var daoObject = factory.GetDataAccessObjectFactory();
var target = daoObject.Delete(andycow0);
bool result = false;
if (target.IsSuccess)
{
result = true;
}
Assert.AreEqual(true, result);
}
public void Andycow0_Update()
{
DBObject dbObj = new DBObject()
{
DataBaseType = DBObject.DataBase.Oracle,
ID = "cgh",
Password = "******",
Node = "jiatest4",
IP = "10.31.11.118"
};
DAOFactory factory = new DAOFactory(dbObj);
var daoobject = factory.GetDataAccessObjectFactory();
var andycow0 = new ANDYCOW0()
{
FIRST = "22",
SECOND = 2
};
var w_andycow0 = new ANDYCOW0()
{
FIRST = "11",
SECOND = 1
};
var target = daoobject.Update(andycow0, w_andycow0);
bool result = false;
if (target.IsSuccess == true && target.EffectRows == 1)
{
result = true;
}
Assert.AreEqual(true, result);
}
public void ANDYCOW0_TDD_Update()
{
DBObject dbObj = new DBObject()
{
DataBaseType = DBObject.DataBase.Oracle,
ID = "cgh",
Password = "******",
Node = "jiatest4",
IP = "10.31.11.118"
};
var first = testContextInstance.DataRow[0].ToString();
var second = Int32.Parse(testContextInstance.DataRow[1].ToString());
var third = DateTime.ParseExact(testContextInstance.DataRow[2].ToString(), "yyyyMMddHHmmss", null);
DAOFactory factory = new DAOFactory(dbObj);
var daoObject = factory.GetDataAccessObjectFactory();
var andycow0 = new ANDYCOW0()
{
//FIRST = "11",
SECOND = 300,
THIRD = DateTime.Now.AddDays(-1)
};
var target = daoObject.Update <ANDYCOW0>(andycow0, (x) => x.FIRST == "22" && x.SECOND > 300);
bool result = false;
if (target.IsSuccess && target.EffectRows > 0)
{
result = true;
}
Assert.AreEqual(true, result);
}
