public DatabaseConnection(TestDatabase database, string currentSchema)
{
Database = database;
CurrentSchema = currentSchema;
Transaction = new FakeTransaction(this);
}
public void SetUp()
{
database = new TestDatabase();
var tableInfo = new DataTableInfo("APP", "person");
tableInfo.AddColumn("id", PrimitiveTypes.Numeric());
tableInfo.AddColumn("first_name", PrimitiveTypes.String());
tableInfo.AddColumn("last_name", PrimitiveTypes.String());
tableInfo.AddColumn("age", PrimitiveTypes.Numeric());
var table = database.CreateTable(tableInfo);
long rowIndex = table.NewRow();
table.SetValue(0, rowIndex, DataObject.Number(0));
table.SetValue(1, rowIndex, new DataObject(PrimitiveTypes.String(), new StringObject("Antonello")));
table.SetValue(2, rowIndex, new DataObject(PrimitiveTypes.String(), new StringObject("Provenzano")));
table.SetValue(3, rowIndex, new DataObject(PrimitiveTypes.Numeric(), Number.FromInt32(32)));
rowIndex = table.NewRow();
table.SetValue(0, rowIndex, DataObject.Number(1));
table.SetValue(1, rowIndex, DataObject.String("Mart"));
table.SetValue(2, rowIndex, DataObject.String("Roosmaa"));
table.SetValue(3, rowIndex, DataObject.Number(28));
tableInfo = new DataTableInfo("APP", "lives");
tableInfo.AddColumn("person_id", PrimitiveTypes.Numeric());
tableInfo.AddColumn("city", PrimitiveTypes.String());
tableInfo.AddColumn("country", PrimitiveTypes.String());
table = database.CreateTable(tableInfo);
rowIndex = table.NewRow();
table.SetValue(0, rowIndex, DataObject.Number(0));
table.SetValue(1, rowIndex, DataObject.String("Oslo"));
table.SetValue(2, rowIndex, DataObject.String("Norway"));
rowIndex = table.NewRow();
table.SetValue(0, rowIndex, DataObject.Number(1));
table.SetValue(1, rowIndex, DataObject.String("Tallinn"));
table.SetValue(2, rowIndex, DataObject.String("Estonia"));
tableInfo = new DataTableInfo("APP", "devices");
tableInfo.AddColumn("id", PrimitiveTypes.Numeric());
tableInfo.AddColumn("person_id", PrimitiveTypes.Numeric());
tableInfo.AddColumn("device_name", PrimitiveTypes.String());
tableInfo.AddColumn("os", PrimitiveTypes.String());
tableInfo.AddColumn("date", PrimitiveTypes.Date());
table = database.CreateTable(tableInfo);
rowIndex = table.NewRow();
table.SetValue(0, rowIndex, DataObject.Number(0));
table.SetValue(1, rowIndex, DataObject.Number(0));
table.SetValue(2, rowIndex, DataObject.String("Work Notebook"));
table.SetValue(3, rowIndex, DataObject.String("Windows 8.1"));
table.SetValue(4, rowIndex, DataObject.Now());
rowIndex = table.NewRow();
table.SetValue(0, rowIndex, DataObject.Number(1));
table.SetValue(1, rowIndex, DataObject.Number(0));
table.SetValue(2, rowIndex, DataObject.String("Tablet"));
table.SetValue(3, rowIndex, DataObject.String("Android 4.4"));
table.SetValue(4, rowIndex, DataObject.Now());
rowIndex = table.NewRow();
table.SetValue(0, rowIndex, DataObject.Number(2));
table.SetValue(1, rowIndex, DataObject.Number(0));
table.SetValue(2, rowIndex, DataObject.String("Other Notebook"));
table.SetValue(3, rowIndex, DataObject.String("Ubuntu Linux"));
table.SetValue(4, rowIndex, DataObject.Now());
rowIndex = table.NewRow();
table.SetValue(0, rowIndex, DataObject.Number(3));
table.SetValue(1, rowIndex, DataObject.Number(1));
table.SetValue(2, rowIndex, DataObject.String("Mac Work Notebook"));
table.SetValue(3, rowIndex, DataObject.String("Mac OS X"));
table.SetValue(4, rowIndex, DataObject.Now());
rowIndex = table.NewRow();
table.SetValue(0, rowIndex, DataObject.Number(4));
table.SetValue(1, rowIndex, DataObject.Number(1));
table.SetValue(2, rowIndex, DataObject.String("Tablet"));
table.SetValue(3, rowIndex, DataObject.String("Android 4.2"));
table.SetValue(4, rowIndex, DataObject.Now());
}
public void SetUp()
{
database = new TestDatabase();
var tableInfo = new DataTableInfo("APP", "person");
tableInfo.AddColumn("id", PrimitiveTypes.Numeric());
tableInfo.AddColumn("first_name", PrimitiveTypes.String());
tableInfo.AddColumn("last_name", PrimitiveTypes.String());
tableInfo.AddColumn("age", PrimitiveTypes.Numeric());
var table = database.CreateTable(tableInfo);
long rowIndex = table.NewRow();
table.SetValue(0, rowIndex, DataObject.Number(0));
table.SetValue(1, rowIndex, new DataObject(PrimitiveTypes.String(), new StringObject("Antonello")));
table.SetValue(2, rowIndex, new DataObject(PrimitiveTypes.String(), new StringObject("Provenzano")));
table.SetValue(3, rowIndex, new DataObject(PrimitiveTypes.Numeric(), Number.FromInt32(32)));
rowIndex = table.NewRow();
table.SetValue(0, rowIndex, DataObject.Number(1));
table.SetValue(1, rowIndex, DataObject.String("Mart"));
table.SetValue(2, rowIndex, DataObject.String("Roosmaa"));
table.SetValue(3, rowIndex, DataObject.Number(28));
tableInfo = new DataTableInfo("APP", "lives");
tableInfo.AddColumn("person_id", PrimitiveTypes.Numeric());
tableInfo.AddColumn("city", PrimitiveTypes.String());
tableInfo.AddColumn("country", PrimitiveTypes.String());
table = database.CreateTable(tableInfo);
rowIndex = table.NewRow();
table.SetValue(0, rowIndex, DataObject.Number(0));
table.SetValue(1, rowIndex, DataObject.String("Oslo"));
table.SetValue(2, rowIndex, DataObject.String("Norway"));
rowIndex = table.NewRow();
table.SetValue(0, rowIndex, DataObject.Number(1));
table.SetValue(1, rowIndex, DataObject.String("Tallinn"));
table.SetValue(2, rowIndex, DataObject.String("Estonia"));
tableInfo = new DataTableInfo("APP", "devices");
tableInfo.AddColumn("id", PrimitiveTypes.Numeric());
tableInfo.AddColumn("person_id", PrimitiveTypes.Numeric());
tableInfo.AddColumn("device_name", PrimitiveTypes.String());
tableInfo.AddColumn("os", PrimitiveTypes.String());
tableInfo.AddColumn("date", PrimitiveTypes.Date());
table = database.CreateTable(tableInfo);
rowIndex = table.NewRow();
table.SetValue(0, rowIndex, DataObject.Number(0));
table.SetValue(1, rowIndex, DataObject.Number(0));
table.SetValue(2, rowIndex, DataObject.String("Work Notebook"));
table.SetValue(3, rowIndex, DataObject.String("Windows 8.1"));
table.SetValue(4, rowIndex, DataObject.Now());
rowIndex = table.NewRow();
table.SetValue(0, rowIndex, DataObject.Number(1));
table.SetValue(1, rowIndex, DataObject.Number(0));
table.SetValue(2, rowIndex, DataObject.String("Tablet"));
table.SetValue(3, rowIndex, DataObject.String("Android 4.4"));
table.SetValue(4, rowIndex, DataObject.Now());
rowIndex = table.NewRow();
table.SetValue(0, rowIndex, DataObject.Number(2));
table.SetValue(1, rowIndex, DataObject.Number(0));
table.SetValue(2, rowIndex, DataObject.String("Other Notebook"));
table.SetValue(3, rowIndex, DataObject.String("Ubuntu Linux"));
table.SetValue(4, rowIndex, DataObject.Now());
rowIndex = table.NewRow();
table.SetValue(0, rowIndex, DataObject.Number(3));
table.SetValue(1, rowIndex, DataObject.Number(1));
table.SetValue(2, rowIndex, DataObject.String("Mac Work Notebook"));
table.SetValue(3, rowIndex, DataObject.String("Mac OS X"));
table.SetValue(4, rowIndex, DataObject.Now());
rowIndex = table.NewRow();
table.SetValue(0, rowIndex, DataObject.Number(4));
table.SetValue(1, rowIndex, DataObject.Number(1));
table.SetValue(2, rowIndex, DataObject.String("Tablet"));
table.SetValue(3, rowIndex, DataObject.String("Android 4.2"));
table.SetValue(4, rowIndex, DataObject.Now());
}
public DatabaseConnection(TestDatabase database, string currentSchema)
{
Database = database;
CurrentSchema = currentSchema;
Transaction = new FakeTransaction(this);
}
