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 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" }); }
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 DropTableTest() { 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" }); Assert.True(db.TableExists(dbConstants.table_name)); db.DropTableIfExists(dbConstants.table_name); Assert.True(db.TableExists(dbConstants.table_name)); } catch (Exception) { } }
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" }); }
public void CreateFakeDatabaseAndBackup() { SqlLiteDatabase db = CreateTestDatabase(String.Format("{0}", dbConstants.GUID)); db.InsertData(dbConstants.table_name, new string[3] { dbConstants.STATUS, dbConstants.XML, dbConstants.GUID }, new object[3] { "boo status", "boo xml", "GUID_A" }); db.InsertData(dbConstants.table_name, new string[3] { dbConstants.STATUS, dbConstants.XML, dbConstants.GUID }, new object[3] { "boo status2", "boo xml2", "GUID_A2" }); db.Dispose(); db = new FAKE_SqlLiteDatabase(test_database_name); try { db.DropTableIfExists(dbConstants.table_name + "_b"); } catch (Exception ex) { _w.output(String.Format("Unable to drop table {0}", ex.ToString())); } db.CreateTableIfDoesNotExist(dbConstants.table_name + "_b", new string[4] { dbConstants.ID, dbConstants.GUID, dbConstants.XML, dbConstants.STATUS }, new string[4] { "INTEGER", "TEXT UNIQUE", "LONGTEXT", "TEXT" }, dbConstants.GUID ); db.InsertData(dbConstants.table_name + "_b", new string[3] { dbConstants.STATUS, dbConstants.XML, dbConstants.GUID }, new object[3] { "boo status", "boo xml", "GUID_B" }); db.Dispose(); db = new FAKE_SqlLiteDatabase(test_database_name); try { db.DropTableIfExists(dbConstants.table_name + "_c"); } catch (Exception ex) { _w.output(String.Format("Unable to drop table {0}", ex.ToString())); } db.CreateTableIfDoesNotExist(dbConstants.table_name + "_c", new string[4] { dbConstants.ID, dbConstants.GUID, dbConstants.XML, dbConstants.STATUS }, new string[4] { "INTEGER", "TEXT UNIQUE", "LONGTEXT", "TEXT" }, dbConstants.GUID ); db.InsertData(dbConstants.table_name + "_c", new string[3] { dbConstants.STATUS, dbConstants.XML, dbConstants.GUID }, new object[3] { "boo status", "boo xml", "GUID_C" }); // get rid of full text database too db.DropTableIfExists("fulltextsearch"); //not sure how to set this test up. Force File Write? Then test if file exists? // or shoudl this return a Stream? string result = db.BackupDatabase(); _w.output(result.Length); _w.output(result); db.DropTableIfExists(dbConstants.table_name + "_b"); db.DropTableIfExists(dbConstants.table_name + "_c"); db.Dispose(); Assert.AreEqual(526, result.Length); //Assert.False (true); }
public void TableDoesExist() { FAKE_SqlLiteDatabase db = new FAKE_SqlLiteDatabase (test_database_name); db.DropTableIfExists(dbConstants.table_name); _w.output ("here1"); Assert.False (db.TableExists (dbConstants.table_name)); _w.output ("here"); 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"}); Assert.True (db.TableExists (dbConstants.table_name)); } catch (Exception) { } }
public void CreateFakeDatabaseAndBackup() { SqlLiteDatabase db =CreateTestDatabase(String.Format ("{0}", dbConstants.GUID)); db.InsertData (dbConstants.table_name, new string[3] { dbConstants.STATUS,dbConstants.XML,dbConstants.GUID }, new object[3] {"boo status", "boo xml", "GUID_A"}); db.InsertData (dbConstants.table_name, new string[3] { dbConstants.STATUS,dbConstants.XML,dbConstants.GUID }, new object[3] {"boo status2", "boo xml2", "GUID_A2"}); db.Dispose(); db = new FAKE_SqlLiteDatabase (test_database_name); try { db.DropTableIfExists(dbConstants.table_name+"_b"); } catch (Exception ex) { _w.output (String.Format ("Unable to drop table {0}", ex.ToString())); } db.CreateTableIfDoesNotExist (dbConstants.table_name+"_b", new string[4] {dbConstants.ID, dbConstants.GUID, dbConstants.XML, dbConstants.STATUS}, new string[4] { "INTEGER", "TEXT UNIQUE", "LONGTEXT", "TEXT" }, dbConstants.GUID ); db.InsertData (dbConstants.table_name+"_b", new string[3] { dbConstants.STATUS,dbConstants.XML,dbConstants.GUID }, new object[3] {"boo status", "boo xml", "GUID_B"}); db.Dispose(); db = new FAKE_SqlLiteDatabase (test_database_name); try { db.DropTableIfExists(dbConstants.table_name+"_c"); } catch (Exception ex) { _w.output (String.Format ("Unable to drop table {0}", ex.ToString())); } db.CreateTableIfDoesNotExist (dbConstants.table_name+"_c", new string[4] {dbConstants.ID, dbConstants.GUID, dbConstants.XML, dbConstants.STATUS}, new string[4] { "INTEGER", "TEXT UNIQUE", "LONGTEXT", "TEXT" }, dbConstants.GUID ); db.InsertData (dbConstants.table_name+"_c", new string[3] { dbConstants.STATUS,dbConstants.XML,dbConstants.GUID }, new object[3] {"boo status", "boo xml", "GUID_C"}); // get rid of full text database too db.DropTableIfExists("fulltextsearch"); //not sure how to set this test up. Force File Write? Then test if file exists? // or shoudl this return a Stream? string result = db.BackupDatabase(); _w.output(result.Length); _w.output(result); db.DropTableIfExists(dbConstants.table_name+"_b"); db.DropTableIfExists(dbConstants.table_name+"_c"); db.Dispose(); Assert.AreEqual(526, result.Length); //Assert.False (true); }