public void TestSetUp()
{
HeapDatabase testdb = new HeapDatabase(null, "testdb");
ITransactionState transaction = testdb.CreateTransaction();
transaction.CreateSchema("test");
IMutableTable table = (IMutableTable) transaction.CreateTable(new TableName("test", "names"));
table.Columns.Add("id", SqlType.Numeric, true);
table.Columns.Add("first_name", SqlType.String, true);
table.Columns.Add("last_name", SqlType.String, true);
TableRow row = table.NewRow();
row.SetValue("id", 1);
row.SetValue("first_name", "Antonello");
row.SetValue("last_name", "Provenzano");
row.Insert();
table.Commit();
table = (IMutableTable) transaction.CreateTable(new TableName("test", "books"));
table.Columns.Add("id", SqlType.Numeric, true);
table.Columns.Add("title", SqlType.String, true);
table.Columns.Add("author", SqlType.String, false);
row = table.NewRow();
row["id"] = 1;
row["title"] = "The Lord Of The Rings";
row["author"] = "J. R. R. Tolkien";
row.Insert();
row = table.NewRow();
row["id"] = 2;
row["title"] = "Buddenbrooks";
row["author"] = "Thomas Mann";
row.Insert();
table.Commit();
table = (IMutableTable) transaction.CreateTable(new TableName("test", "book_read"));
table.Columns.Add("id", SqlType.Numeric, true);
table.Columns.Add("book_id", SqlType.Numeric, true);
table.Columns.Add("name_id", SqlType.Numeric, true);
table.Columns.Add("read_date", SqlType.DateTime, true);
row = table.NewRow();
row["id"] = 1;
row["book_id"] = 1;
row["name_id"] = 1;
row["read_date"] = "2001-12-22";
row.Insert();
row = table.NewRow();
row["id"] = 2;
row["book_id"] = 2;
row["name_id"] = 1;
row["read_date"] = "2009-05-10";
row.Insert();
table.Commit();
testdb.CommitTransaction(transaction);
sessionContext = new EmbeddedSessionContext(testdb, true, "antonello");
connection = sessionContext.CreateConnection();
connection.Open();
try {
IDbCommand command = connection.CreateCommand();
command.CommandText = "SET SCHEMA test;";
command.ExecuteNonQuery();
} catch (Exception e) {
Console.Error.WriteLine("Error: {0}", e.Message);
Console.Error.WriteLine(e.StackTrace);
}
}
