//----< test stub >-------------
static void Main()
{
List<Type> colTypes = new List<Type>(new Type[]{typeof(int),typeof(string),typeof(DateTime)});
List<string> colNames = new List<string>(new string[]{"GroupId","Name","JoinDate"});
QueryDataset table = new QueryDataset(colTypes,colNames);
List<object> entry = new List<object>();
entry.Add(1);
entry.Add("David");
entry.Add(new DateTime(2010,6,3));
table.AddRow(1, entry);
entry.Clear();
entry.Add(3);
entry.Add("Mary");
entry.Add(new DateTime(2011, 10, 12));
table.AddRow(2, entry);
foreach (var name in table.GetColumnNames())
Console.Write(name + " ");
Console.WriteLine();
foreach (var row in table)
{
foreach (var field in row.Value)
Console.Write(field + " ");
Console.WriteLine();
}
Console.ReadKey();
}
public QueryDataset GetQueryResult(string id, int startLines, int numLines)
{
int i = 1, k = numLines;
QueryDataset queryDataset = null, ret = null;
if (id == "")
throw new Exception("Empty ID");
if (m_ResultCache.ContainsKey(id))
{
queryDataset = m_ResultCache[id];
}
ret = new QueryDataset(queryDataset.GetColumnTypes(), queryDataset.GetColumnNames());
if (startLines < queryDataset.count)
{
foreach(var row in queryDataset)
{
if ((i == startLines) && (k > 0))
{
ret.AddRow(row.Key, row.Value);
k--;
}
if (k == 0)
break;
i++;
}
}
return ret;
}
/// <summary>
/// Used to create a Mock dataset with values
/// </summary>
/// <returns> QueryDataset object </returns>
public QueryDataset MockDataSet()
{
List<Type> colTypes = new List<Type>(new Type[] { typeof(int), typeof(string), typeof(DateTime) });
List<string> colNames = new List<string>(new string[] { "GroupId", "Name", "JoinDate" });
QueryDataset table = new QueryDataset(colTypes, colNames);
List<object> entry = new List<object>();
entry.Add(1);
entry.Add("David");
entry.Add(new DateTime(2010, 6, 3));
table.AddRow(1, entry);
entry.Clear();
entry.Add(3);
entry.Add("Mary");
entry.Add(new DateTime(2011, 10, 12));
table.AddRow(2, entry);
entry.Clear();
entry.Add(5);
entry.Add("Harry");
entry.Add(new DateTime(2011, 7, 4));
table.AddRow(3, entry);
entry.Clear();
entry.Add(7);
entry.Add("Peter");
entry.Add(new DateTime(2011, 3, 18));
table.AddRow(4, entry);
entry.Clear();
entry.Add(9);
entry.Add("Kate");
entry.Add(new DateTime(2011, 12, 18));
table.AddRow(5, entry);
return table;
}