public void TestDemoStatisticsTimeIO()
{
GetConnection u = new GetConnection();
GetBatches b = new GetBatches();
GetBatchResult r = new GetBatchResult();
GetSqlInfo s = new GetSqlInfo();
string constring_1 = u.GetConnectionString("AdventureWorks2014");
string[] batches = b.GetFileContent(@"..\\..\\..\\SabinIO.Performance.StatisticsTimeIO\\Demos\\DemoStatisticsTimeIO.sql");
SqlConnection _conn = new SqlConnection(constring_1);
_conn.InfoMessage += new SqlInfoMessageEventHandler(s.Message);
for (int i = 0; i < batches.Length; i++)
{
_conn.Open();
SqlCommand cmd_1 = new SqlCommand(batches[i], _conn);
cmd_1.ExecuteNonQuery();
_conn.Close();
}
MatchCollection q = Regex.Matches(s.SqlInfoMessages[1], @"\d+");
Assert.IsTrue(Convert.ToInt32(q[1].ToString()) <= 1246);
MatchCollection w = Regex.Matches(s.SqlInfoMessages[2], @"\d+");
Assert.IsTrue(Convert.ToInt32(q[0].ToString()) <= 200);
}
public void TestTruncateDeleteDemo1()
{
GetConnection u = new GetConnection();
GetBatches b = new GetBatches();
GetBatchResult r = new GetBatchResult();
GetSqlInfo s = new GetSqlInfo();
string constring_1 = u.GetConnectionString("SabinIO.Performance.TruncateDelete");
string[] batches = b.GetFileContent(@"..\\..\\..\\SabinIO.Performance.TruncateDelete\\Demos\\TruncateDeleteDemo1.sql");
SqlConnection _conn = new SqlConnection(constring_1);
_conn.InfoMessage += new SqlInfoMessageEventHandler(s.Message);
for (int i = 0; i < batches.Length; i++)
{
_conn.Open();
SqlCommand cmd_1 = new SqlCommand(batches[i], _conn);
cmd_1.CommandTimeout = 60;
cmd_1.ExecuteNonQuery();
_conn.Close();
}
MatchCollection q = Regex.Matches(s.SqlInfoMessages[1], @"\d+");
Assert.IsTrue(Convert.ToInt32(q[0].ToString()) <= 10);
Assert.IsTrue(Convert.ToInt32(q[1].ToString()) <= 10);
MatchCollection w = Regex.Matches(s.SqlInfoMessages[2], @"\d+");
Assert.IsTrue(Convert.ToInt32(w[0].ToString()) <= 10);
Assert.IsTrue(Convert.ToInt32(w[1].ToString()) <= 22);
Assert.IsTrue(Convert.ToInt32(w[2].ToString()) <= 10);
Assert.IsTrue(Convert.ToInt32(w[3].ToString()) <= 10);
Assert.IsTrue(Convert.ToInt32(w[4].ToString()) <= 10);
Assert.IsTrue(Convert.ToInt32(w[5].ToString()) <= 10);
Assert.IsTrue(Convert.ToInt32(w[6].ToString()) <= 10);
}
