public void AddMissingColumn_Test_ColumnDidNotExistAndWeDetectedItCorrectly() { // 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" }); _w.output(db.BackupDatabase()); // add ColumnA to it bool result = db.TestAddMissingColumn(dbConstants.table_name, new string[1] { "boomer" }, new string[1] { "TEXT" }); // check return value is true Assert.True(result); _w.output(db.BackupDatabase()); // add ColumnA to it again. This time return value should be false (because we did not need to add the column) result = db.TestAddMissingColumn(dbConstants.table_name, new string[1] { "boomer" }, new string[1] { "TEXT" }); Console.WriteLine("Result #2 = " + result); Assert.False(result); }
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 AddMissingColumn_ListOfColumnsNotEqualToListOfTypes() { // 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[2] { "boomer", "poob" }, new string[1] { "TEXT" }); }