public void GuidDoesExist() { _w.output("GUIDDOESEXIST"); bool result = false; _w.output("here1"); // Create a test database FAKE_SqlLiteDatabase db = CreateTestDatabase(String.Format("{0}", dbConstants.ID)); _w.output("here"); try { db.InsertData(dbConstants.table_name, new string[3] { dbConstants.STATUS, dbConstants.XML, dbConstants.GUID } , new object[3] { "boo status", "boo xml", "GUID_A" }); result = db.TestAddMissingColumn(dbConstants.table_name, new string[1] { "boomer" }, new string[1] { "TEXT" }); } catch (Exception ex) { _w.output(ex.ToString()); } _w.output("here"); Assert.True(db.Exists(dbConstants.table_name, dbConstants.GUID, "GUID_A")); _w.output(result); }
public void GuidDoesNotExist() { // Create a test database FAKE_SqlLiteDatabase db = CreateTestDatabase(String.Format("{0}", dbConstants.ID)); db.InsertData(dbConstants.table_name, new string[3] { dbConstants.STATUS, dbConstants.XML, dbConstants.GUID }, new object[3] { "boo status", "boo xml", "GUID_A" }); bool result = db.TestAddMissingColumn(dbConstants.table_name, new string[1] { "boomer" }, new string[1] { "TEXT" }); Console.WriteLine("GuidDoesNotExist"); Assert.False(db.Exists(dbConstants.table_name, dbConstants.GUID, "GUID_B")); }
public void AddingToUniqueColumn() { // Create a test database FAKE_SqlLiteDatabase db = CreateTestDatabase(String.Format("{0}", dbConstants.GUID)); Console.WriteLine("First insert should work"); if (db.Exists("boo", dbConstants.XML, "z")) { } ; db.InsertData(dbConstants.table_name, new string[3] { dbConstants.STATUS, dbConstants.XML, dbConstants.GUID } , new object[3] { "boo status", "boo xml", "GUID_A" }); Console.WriteLine("inserting a unique GUID_B is okay"); db.InsertData(dbConstants.table_name, new string[3] { dbConstants.STATUS, dbConstants.XML, dbConstants.GUID } , new object[3] { "boo status", "boo xml", "GUID_B" }); Console.WriteLine("Second insert should fail "); db.InsertData(dbConstants.table_name, new string[3] { dbConstants.STATUS, dbConstants.XML, dbConstants.GUID } , new object[3] { "boo status", "boo xml", "GUID_A" }); }