public void _SetupForLayoutPanelTests(bool BreakAppearanceOnPurpose, string OverrideDatabaseName) { LayoutDetails.Instance.UpdateAfterLoadList.Clear(); SetupForAnyTest(); LayoutDetails.Instance.YOM_DATABASE = TESTDATABASE; if ("" != OverrideDatabaseName) { LayoutDetails.Instance.YOM_DATABASE = OverrideDatabaseName; } LayoutDetails.Instance.OverridePath = Environment.CurrentDirectory; _w.output(LayoutDetails.Instance.YOM_DATABASE); if (false == BreakAppearanceOnPurpose) { LayoutDetails.Instance.GetAppearanceFromStorage = GetAppearanceFromStorage; } else { LayoutDetails.Instance.GetAppearanceFromStorage = null; } LayoutDetails.Instance.AddToList(typeof(FAKE_NoteDataXML_Panel), "testingpanel"); LayoutDetails.Instance.AddToList(typeof(FAKE_NoteDataXML_Text), "testingtext"); FakeLayoutDatabase layout = new FakeLayoutDatabase("testguid"); FAKE_SqlLiteDatabase db = new FAKE_SqlLiteDatabase(layout.GetDatabaseName()); LayoutDetails.Instance.TransactionsList = new Transactions.TransactionsTable(MasterOfLayouts.GetDatabaseType(LayoutDetails.Instance.YOM_DATABASE)); foreach (string s in ListOfTablesToDrop) { db.DropTableIfExists(s); // db.DropTableIfExists("system"); _w.output("dropping table " + s); } }
private FAKE_SqlLiteDatabase CreateTestDatabase(string primarykey) { FAKE_SqlLiteDatabase db = new FAKE_SqlLiteDatabase(test_database_name); try { // There was a lock on deleting the database but I realized that the call to new would // clear the database if paired with a delete? // We have to clear memory when deleting because the database might be lingering //GC.Collect(); //System.IO.File.Delete (test_database_name); } catch (Exception ex) { _w.output("Unable to delete file " + ex.ToString()); } try { db.DropTableIfExists(dbConstants.table_name); } catch (Exception ex) { _w.output(String.Format("Unable to drop table {0}", ex.ToString())); } db.CreateTableIfDoesNotExist(dbConstants.table_name, new string[6] { dbConstants.ID, dbConstants.GUID, dbConstants.XML, dbConstants.STATUS, dbConstants.NAME, dbConstants.SUBPANEL }, new string[6] { "INTEGER", "TEXT UNIQUE", "LONGTEXT", "TEXT", "TEXT", "BOOLEAN" }, primarykey ); return(db); }
private TransactionsTable SetupForEventTests() { lg.Instance.OutputToConstoleToo = true; FAKE_SqlLiteDatabase db = new FAKE_SqlLiteDatabase(_TestSingleTon.TESTDATABASE); db.DropTableIfExists("events"); db.Dispose(); TransactionsTable eventTable = new TransactionsTable(MasterOfLayouts.GetDatabaseType(_TestSingleTon.TESTDATABASE)); return(eventTable); }
protected void _SetupForLayoutPanelTests() { // just to make sure we are calling any other essential setters we call the Singleton, even though we are doign some custom stuff here to _TestSingleTon.Instance._SetupForLayoutPanelTests(); LayoutDetails.Instance.YOM_DATABASE = "yom_test_database.s3db"; LayoutDetails.Instance.AddToList(typeof(FAKE_NoteDataXML_Panel), "testingpanel"); LayoutDetails.Instance.AddToList(typeof(FAKE_NoteDataXML_Text), "testingtext"); FakeLayoutDatabase layout = new FakeLayoutDatabase("testguid"); FAKE_SqlLiteDatabase db = new FAKE_SqlLiteDatabase(layout.GetDatabaseName()); db.DropTableIfExists(Layout.data.dbConstants.table_name); _w.output("dropping table " + Layout.data.dbConstants.table_name); }
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 CreateTableIfDoesNotExist_CreateUnevenTable() { FAKE_SqlLiteDatabase db = new FAKE_SqlLiteDatabase(test_database_name); try { db.DropTableIfExists(dbConstants.table_name); } catch (Exception ex) { _w.output(String.Format("Unable to drop table {0}", ex.ToString())); } db.CreateTableIfDoesNotExist(dbConstants.table_name, new string[4] { dbConstants.ID, dbConstants.GUID, dbConstants.XML, dbConstants.STATUS }, new string[3] { "INTEGER", "TEXT UNIQUE", "LONGTEXT" }, dbConstants.GUID ); db.Dispose(); }
protected void _SetupForLayoutPanelTests() { // just to make sure we are calling any other essential setters we call the Singleton, even though we are doign some custom stuff here to _TestSingleTon.Instance._SetupForLayoutPanelTests(); LayoutDetails.Instance.YOM_DATABASE = "yom_test_database.s3db"; LayoutDetails.Instance.AddToList(typeof(FAKE_NoteDataXML_Panel),"testingpanel"); LayoutDetails.Instance.AddToList(typeof(FAKE_NoteDataXML_Text),"testingtext"); FakeLayoutDatabase layout = new FakeLayoutDatabase("testguid"); FAKE_SqlLiteDatabase db = new FAKE_SqlLiteDatabase(layout.GetDatabaseName ()); db.DropTableIfExists(Layout.data.dbConstants.table_name); _w.output ("dropping table " + Layout.data.dbConstants.table_name); }
public void _SetupForLayoutPanelTests(bool BreakAppearanceOnPurpose, string OverrideDatabaseName) { LayoutDetails.Instance.UpdateAfterLoadList.Clear (); SetupForAnyTest (); LayoutDetails.Instance.YOM_DATABASE = TESTDATABASE; if ("" != OverrideDatabaseName) { LayoutDetails.Instance.YOM_DATABASE = OverrideDatabaseName; } LayoutDetails.Instance.OverridePath = Environment.CurrentDirectory; _w.output (LayoutDetails.Instance.YOM_DATABASE); if (false == BreakAppearanceOnPurpose) LayoutDetails.Instance.GetAppearanceFromStorage = GetAppearanceFromStorage; else LayoutDetails.Instance.GetAppearanceFromStorage = null; LayoutDetails.Instance.AddToList (typeof(FAKE_NoteDataXML_Panel), "testingpanel"); LayoutDetails.Instance.AddToList (typeof(FAKE_NoteDataXML_Text), "testingtext"); FakeLayoutDatabase layout = new FakeLayoutDatabase ("testguid"); FAKE_SqlLiteDatabase db = new FAKE_SqlLiteDatabase (layout.GetDatabaseName ()); LayoutDetails.Instance.TransactionsList = new Transactions.TransactionsTable (MasterOfLayouts.GetDatabaseType (LayoutDetails.Instance.YOM_DATABASE)); foreach (string s in ListOfTablesToDrop) { db.DropTableIfExists (s); // db.DropTableIfExists("system"); _w.output ("dropping table " + s); } }
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); }
private FAKE_SqlLiteDatabase CreateTestDatabase(string primarykey) { FAKE_SqlLiteDatabase db = new FAKE_SqlLiteDatabase (test_database_name); try { // There was a lock on deleting the database but I realized that the call to new would // clear the database if paired with a delete? // We have to clear memory when deleting because the database might be lingering //GC.Collect(); //System.IO.File.Delete (test_database_name); } catch (Exception ex) { _w.output ("Unable to delete file " + ex.ToString ()); } try { db.DropTableIfExists(dbConstants.table_name); } catch (Exception ex) { _w.output (String.Format ("Unable to drop table {0}", ex.ToString())); } db.CreateTableIfDoesNotExist (dbConstants.table_name, new string[6] {dbConstants.ID, dbConstants.GUID, dbConstants.XML, dbConstants.STATUS, dbConstants.NAME, dbConstants.SUBPANEL}, new string[6] { "INTEGER", "TEXT UNIQUE", "LONGTEXT", "TEXT","TEXT","BOOLEAN" }, primarykey ); return db; }
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 CreateTableIfDoesNotExist_CreateUnevenTable() { FAKE_SqlLiteDatabase db = new FAKE_SqlLiteDatabase (test_database_name); try { db.DropTableIfExists(dbConstants.table_name); } catch (Exception ex) { _w.output (String.Format ("Unable to drop table {0}", ex.ToString())); } db.CreateTableIfDoesNotExist (dbConstants.table_name, new string[4] {dbConstants.ID, dbConstants.GUID, dbConstants.XML, dbConstants.STATUS}, new string[3] { "INTEGER", "TEXT UNIQUE", "LONGTEXT" }, dbConstants.GUID ); db.Dispose(); }
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); }