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