public void EmptyQuery()
{
var db = new Energy.Source.Connection();
string error;
object result;
int number;
DataTable table;
Energy.Base.Table fetch;
result = db.Scalar(null, out error);
Assert.AreEqual("Empty query", error);
Assert.IsNull(result);
result = db.Scalar("", out error);
Assert.AreEqual("Empty query", error);
Assert.IsNull(result);
number = db.Scalar <int>(null, out error);
Assert.AreEqual("Empty query", error);
Assert.AreEqual(0, number);
number = db.Execute(null, out error);
Assert.AreEqual("Empty query", error);
Assert.AreEqual(-2, number);
table = db.Read(null, out error);
Assert.AreEqual("Empty query", error);
Assert.IsNull(table);
fetch = db.Fetch(null, out error);
Assert.AreEqual("Empty query", error);
Assert.IsNull(fetch);
table = db.Load(null, out error);
Assert.AreEqual("Empty query", error);
Assert.IsNull(table);
}
private static void Test2()
{
DataTable t1 = db.Read("SELECT * FROM UserTable");
string text = Energy.Base.Plain.DataTableToPlainText(t1, null);
for (int j = 0; j < t1.Columns.Count; j++)
{
Console.Write(t1.Columns[j].ColumnName);
Console.Write(" | ");
}
Console.WriteLine();
for (int i = 0; i < t1.Rows.Count; i++)
{
for (int j = 0; j < t1.Columns.Count; j++)
{
Console.Write(Energy.Base.Cast.ObjectToString(t1.Rows[i][j]));
Console.Write(" | ");
}
Console.WriteLine();
}
string query = "SELECT TOP 1000 * FROM LogTable ORDER BY id DESC";
Console.WriteLine();
Console.WriteLine("--- Benchmark 1 ---");
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("Memory: {0}", Energy.Core.Memory.GetCurrentMemoryUsage());
Energy.Core.Benchmark.Result benchmark;
Console.WriteLine("Using FetchDataTable()");
benchmark = Energy.Core.Benchmark.Profile(() =>
{
DataTable t10 = db.Read(query);
if (t10 == null)
{
Console.WriteLine(db.GetErrorText());
}
else
{
Console.WriteLine(string.Format("Result count: {0}", t10.Rows.Count));
}
}, 3, 1, "FetchDataTableLoad");
Console.WriteLine(benchmark.ToString());
Console.WriteLine("Memory: {0}", Energy.Core.Memory.GetCurrentMemoryUsage());
Console.WriteLine("Using FetchDataTable2()");
benchmark = Energy.Core.Benchmark.Profile(() =>
{
DataTable t10 = db.Read(query);
if (t10 == null)
{
Console.WriteLine(db.GetErrorText());
}
else
{
Console.WriteLine(string.Format("Result count: {0}", t10.Rows.Count));
}
}, 3, 1, "FetchDataTableRead");
Console.WriteLine(benchmark.ToString());
Console.WriteLine("Memory: {0}", Energy.Core.Memory.GetCurrentMemoryUsage());
}
