public void DropTable (VirtuosoConnection connection)
{
VirtuosoCommand drop = connection.CreateCommand ();
drop.CommandText = "drop table foo";
try
{
drop.ExecuteNonQuery();
}
catch (Exception)
{
}
finally
{
drop.Dispose();
}
}
public void InsertRow (VirtuosoConnection connection, int i)
{
string s = new string (new char[3] { (char) ('a' + i), (char) ('b' + i), (char) ('c' + i) });
VirtuosoCommand insert = connection.CreateCommand();
insert.CommandText = "insert into foo values (" + i + ", '" + s + "')";
insert.ExecuteNonQuery();
insert.Dispose();
DataRow row = checkTable.NewRow ();
row["id"] = i;
row["txt"] = s;
checkTable.Rows.Add (row);
}
public void CheckTable (VirtuosoConnection connection, TestCaseResult result)
{
VirtuosoCommand select = connection.CreateCommand ();
select.CommandText = "select * from foo";
VirtuosoDataAdapter adapter = new VirtuosoDataAdapter ();
adapter.SelectCommand = (VirtuosoCommand) select;
DataSet dataset = new DataSet ();
adapter.Fill (dataset);
DataTable table = dataset.Tables["Table"];
result.FailIfNotEqual (checkTable.Rows.Count, table.Rows.Count);
result.FailIfNotEqual (checkTable.Columns.Count, table.Columns.Count);
for (int i = 0; i < table.Rows.Count; i++)
{
DataRow row = table.Rows[i];
DataRow checkRow = checkTable.Rows[i];
for (int j = 0; j < table.Columns.Count; j++)
{
string name = table.Columns[j].ColumnName;
result.FailIfNotEqual (checkRow[name], row[name]);
}
}
}
public void CreateTable (VirtuosoConnection connection)
{
VirtuosoCommand create = connection.CreateCommand ();
create.CommandText = "create table foo (id int primary key, txt varchar(100))";
create.ExecuteNonQuery();
create.Dispose();
checkTable = new DataTable ();
checkTable.Columns.Add ("id", typeof (int));
checkTable.Columns.Add ("txt", typeof (string));
InsertRow (connection, 1);
InsertRow (connection, 2);
}
