public void SelectTest()
{
BoxDBAdapter db = GetBoxDBAdapter();
BoxDBAdapterTestVO vo = db.Select <BoxDBAdapterTestVO>(tableName, 1);
Debug.Log(vo.ToString());
db.Dispose();
Assert.IsNotNull(vo);
}
public void InsertTest()
{
BoxDBAdapter db = GetBoxDBAdapter();
BoxDBAdapterTestVO[] voList = new BoxDBAdapterTestVO[3]
{
new BoxDBAdapterTestVO((int)db.MakeNewId(), "test1", 1f),
new BoxDBAdapterTestVO((int)db.MakeNewId(), "测试2", 2f),
new BoxDBAdapterTestVO((int)db.MakeNewId(), "test3", 3f)
};
bool success = db.Insert(tableName, voList);
db.Dispose();
Assert.IsTrue(success);
}
public void DeleteTest()
{
BoxDBAdapter db = GetBoxDBAdapter();
BoxDBAdapterTestVO[] voList = new BoxDBAdapterTestVO[]
{
new BoxDBAdapterTestVO(9999, "test9999", 9999f)
};
db.Insert(tableName, voList);
bool success = db.Delete(tableName, 9999);
db.Dispose();
Assert.IsTrue(success);
}
public void UpdateTest()
{
BoxDBAdapter db = GetBoxDBAdapter();
BoxDBAdapterTestVO[] voList = new BoxDBAdapterTestVO[3]
{
new BoxDBAdapterTestVO(1, "test1_update", 1f),
new BoxDBAdapterTestVO(2, "测试2_update", 2f),
new BoxDBAdapterTestVO(4, "test3_update", 3f)
};
db.Update(tableName, voList);
BoxDBAdapterTestVO vo = db.Select <BoxDBAdapterTestVO>(tableName, 1);
db.Dispose();
Assert.AreEqual("test1_update", vo.Name);
}
