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 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); }
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 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); }