public override global::System.Data.DataTable Clone()
{
TestDataTable cln = ((TestDataTable)(base.Clone()));
cln.InitVars();
return(cln);
}
public void Fill(TestDataTable dt)
{
var cmd = connection.CreateCommand();
cmd.CommandText = SQL;
using (var reader = cmd.ExecuteReader())
dt.Load(reader);
}
private void InitClass()
{
this.DataSetName = "Test";
this.Prefix = "";
this.Namespace = "http://tempuri.org/Test.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableTest = new TestDataTable();
base.Tables.Add(this.tableTest);
}
internal void InitVars(bool initTable)
{
this.tableTest = ((TestDataTable)(base.Tables["Test"]));
if ((initTable == true))
{
if ((this.tableTest != null))
{
this.tableTest.InitVars();
}
}
}
public void ReturnColumnCollectionTest()
{
MainWindow mainWindow = new MainWindow();
TestDataTable testDataTable = new TestDataTable();
DataTable dataTable = testDataTable.ReturnTestDataTable();
mainWindow.ReturnColumnCollection <int>(dataTable, "");
Assert.Fail();
}
public void TestNullIn()
{
// arrange
// act
var values = StartTest()
.Where(x => x.Byte_N.In(new byte?[] { null }))
.ToArray(Executor);
// assert
Assert.AreEqual(1, values.Length);
TestDataTable.Compare(TestDataTables.DataTypeTestNulled, values[0]);
}
public void TestDivide()
{
// arrange
// act
var values = StartTest()
.Where(x => x.PrimaryKey / 2 == TestDataTables.DataTypeTestNulled.PrimaryKey / 2)
.ToList(Executor);
// assert
Assert.AreEqual(1, values.Count);
TestDataTable.Compare(TestDataTables.DataTypeTestNulled, values[0]);
}
public void TestAndCondition()
{
// arrange
// act
var values = StartTest()
.Where(x => x.PrimaryKey == TestDataTables.DataTypeTestNotNulled.PrimaryKey && x.DateTime == TestDataTables.DataTypeTestNotNulled.DateTime)
.ToIEnumerable(Executor)
.ToList();
// assert
Assert.AreEqual(1, values.Count);
TestDataTable.Compare(TestDataTables.DataTypeTestNotNulled, values[0]);
}
public void TestNonEquality()
{
// arrange
// act
var values = StartTest()
.Where(x => x.PrimaryKey != TestDataTables.DataTypeTestNotNulled.PrimaryKey)
.ToIEnumerable(Executor)
.ToList();
// assert
Assert.AreEqual(1, values.Count);
TestDataTable.Compare(TestDataTables.DataTypeTestNulled, values[0]);
}
public void TestEqualityForNullable()
{
// arrange
// act
var values = StartTest()
.Where(x => x.Float_N == null)
.ToIEnumerable(Executor)
.ToList();
// assert
Assert.AreEqual(1, values.Count);
TestDataTable.Compare(TestDataTables.DataTypeTestNulled, values[0]);
}
public void TestValues()
{
// arrange
// act
var values = StartTest()
.ToIEnumerable(Executor)
.ToList();
// assert
Assert.AreEqual(2, values.Count);
TestDataTable.Compare(TestDataTables.DataTypeTestNotNulled, values[0]);
TestDataTable.Compare(TestDataTables.DataTypeTestNulled, values[1]);
}
public void TestOrderByDesc()
{
// arrange
// act
var values = StartTest()
.OrderByDesc(x => x.PrimaryKey)
.ToList(Executor);
// assert
Assert.AreEqual(2, values.Count);
TestDataTable.Compare(TestDataTables.DataTypeTestNulled, values[0]);
TestDataTable.Compare(TestDataTables.DataTypeTestNotNulled, values[1]);
}
public void TestIn()
{
// arrange
// act
var values = StartTest()
.Where(x => x.PrimaryKey.In(new int[1] {
TestDataTables.DataTypeTestNulled.PrimaryKey
}))
.ToArray(Executor);
// assert
Assert.AreEqual(1, values.Length);
TestDataTable.Compare(TestDataTables.DataTypeTestNulled, values[0]);
}
public void TestGreaterThan()
{
// arrange
var pk = TestDataTables.DataTypeTestNulled.PrimaryKey - 1;
// act
var values = StartTest()
.Where(x => x.PrimaryKey > pk)
.ToIEnumerable(Executor)
.ToList();
// assert
Assert.AreEqual(1, values.Count);
TestDataTable.Compare(TestDataTables.DataTypeTestNulled, values[0]);
}
public void TestJoins()
{
// arrange
// act
var values = Query <One2One>()
.From(x => x.T1)
.InnerJoinOne(x => x.T2).On((q, t2) => q.T1.PrimaryKey == t2.PrimaryKey)
.ToIEnumerable(Executor)
.ToList();
// assert
Assert.AreEqual(2, values.Count);
TestDataTable.Compare(TestDataTables.DataTypeTestNotNulled, values[0].T1);
TestDataTable.Compare(TestDataTables.DataTypeTestNotNulled, values[0].T2);
TestDataTable.Compare(TestDataTables.DataTypeTestNulled, values[1].T1);
TestDataTable.Compare(TestDataTables.DataTypeTestNulled, values[1].T2);
}
public void TableAddGetTest()
{
var table = new TestDataTable();
for (var i = 0; i < 10; i++)
{
table.Add(new TestDataItem()
{
Name = "名字" + i,
Age = i
});
}
var result = table.Get(item => item.Age < 5);
Assert.AreEqual(5, result.Count());
}
public void TableQuerySpeedTest()
{
var table = new TestDataTable();
// 生成 300 个数据项
for (var i = 0; i < 300; i++)
{
table.Add(new TestDataItem
{
Name = string.Format("名字:{0}", i),
Age = i
});
}
var stopWatch = new Stopwatch();
stopWatch.Start();
// 查询 10000 次
for (var i = 0; i < 10000; i++)
{
foreach (var testDataItem in table.Get(item => item.Age == 150 && item.Name == "名字:150"))
{
}
}
var oldTime = stopWatch.ElapsedMilliseconds;
UnityEngine.Debug.Log(oldTime);
// 追加代码
stopWatch.Reset();
stopWatch.Start();
// 查询 10000 次
for (var i = 0; i < 10000; i++)
{
foreach (var testDataItem in table.AgeIndex.Get(150).Where(item => item.Name == "名字:150"))
{
}
}
var newTime = stopWatch.ElapsedMilliseconds;
UnityEngine.Debug.Log(newTime);
// ?
}
internal TestRow(global::System.Data.DataRowBuilder rb) :
base(rb)
{
this.tableTest = ((TestDataTable)(this.Table));
}
