public void GetTop10RecordsTest()
{
string query = this.GenerateQueryString(1000);
DataResultTable dt = this.client.GetResultTable(query, 10);
Assert.Equal(10, dt.Count);
}
public void GetLimitedRecordsTest()
{
string query = this.GenerateQueryString(100);
DataResultTable dt = this.client.GetLimitedRecords(query, 20, 20);
Assert.Equal(20, dt.Count);
int firstRecord = dt[0].GetValue <int>("n");
int lastRecord = dt[dt.Count - 1].GetValue <int>("n");
Assert.Equal(21, firstRecord);
Assert.Equal(40, lastRecord);
}
public void GetReversedLimitedRecordsTest()
{
string query = this.GenerateQueryString(100, true);
DataResultTable dt = this.client.GetResultTable(query, 10);
Assert.Equal(10, dt.Count);
int firstRecord = dt[0].GetValue <int>("n");
int lastRecord = dt[dt.Count - 1].GetValue <int>("n");
Assert.Equal(100, firstRecord);
Assert.Equal(91, lastRecord);
}
public void PagedResultTableMassTest(int page, int pageSize, int expCount, int expFirst, int expLast)
{
string query = this.GenerateQueryString(1000);
DataResultTable dt = this.client.GetPagedResultTable(query, page, pageSize);
Assert.Equal(expCount, dt.Count);
if (dt.Count > 0)
{
int firstRecord = dt[0].GetValue <int>("n");
int lastRecord = dt[dt.Count - 1].GetValue <int>("n");
Assert.Equal(expFirst, firstRecord);
Assert.True(expLast == lastRecord);
}
}
