public static void SimpleDBTestsInitialize(TestContext testContextIn)
{
using (SimpleDBLayer db = new SimpleDBLayer(TEST_DB_PATH)) {
SimpleDBLayerColumn[] columnsTest = new SimpleDBLayerColumn[] {
new SimpleDBLayerColumn("ID", SimpleDBLayerColumnType.INTEGER, true, true, true, true, null),
new SimpleDBLayerColumn("String", SimpleDBLayerColumnType.VAR_255, false, false, false, false, null),
new SimpleDBLayerColumn("BigNumber", SimpleDBLayerColumnType.DOUBLE, false, false, true, false, null),
};
SimpleDBLayerTable[] tablesTest = new SimpleDBLayerTable[] {
new SimpleDBLayerTable("TestTableA", columnsTest),
};
SimpleDBLayerIndex[] indexesTest = new SimpleDBLayerIndex[] {
new SimpleDBLayerIndex("test_index", "TestTableA", "ID"),
};
db.EnsureTablesAndIndexes(tablesTest, indexesTest);
SimpleDBLayer.DBCondition[] deleteConditions = new SimpleDBLayer.DBCondition[] {
new SimpleDBLayer.DBCondition('\0', "String", "TestKey", SimpleDBLayer.DBComparator.EQUAL_TO),
};
db.DeleteRows("TestTableA", deleteConditions, false);
}
}
public void TestDBInsert()
{
using (SimpleDBLayer db = new SimpleDBLayer(TEST_DB_PATH)) {
Random rand = new Random();
int testRand = rand.Next();
Dictionary <string, object> data = new Dictionary <string, object>();
data.Add("BigNumber", testRand.ToString());
data.Add("String", "TestKey");
db.InsertRow("TestTableA", data);
int dbObject = Convert.ToInt32((double)db.SelectObject("BigNumber", "TestTableA", "String", "TestKey"));
Assert.AreEqual(testRand, dbObject);
}
}
