public SqlLiteFunctionTests()
{
dstore = SqlLiteDataConnection.GetDataStore(Path.GetTempFileName());
InitHelper.AttachEvents(dstore);
List<DBObject> data = dstore.SchemaValidator.ViewValidator.GetObjects().Where(R => R.Name != "sqlite_sequence").ToList();
while (data.Count != 0)
{
foreach (DBObject t in data)
{
if (t.Name.Equals("sqlite_sequence")) continue;
SQLiteCommand cmd = new SQLiteCommand();
cmd.CommandText = string.Format("DROP VIEW {0}", t.Name);
try { dstore.ExecuteCommand(cmd); }
catch { }
}
data = dstore.SchemaValidator.ViewValidator.GetObjects(true).Where(R => R.Name != "sqlite_sequence").ToList();
}
data = dstore.SchemaValidator.TableValidator.GetObjects().Where(R => R.Name != "sqlite_sequence").ToList();
while (data.Count != 0)
{
foreach (DBObject t in data)
{
if (t.Name.Equals("sqlite_sequence")) continue;
SQLiteCommand cmd = new SQLiteCommand();
cmd.CommandText = string.Format("DROP TABLE {0}", t.Name);
try { dstore.ExecuteCommand(cmd); }
catch { }
}
data = dstore.SchemaValidator.TableValidator.GetObjects(true).Where(R => R.Name != "sqlite_sequence").ToList();
}
}
public override void Test_DB_Types_Come_Back_Right()
{
dstore.LoadEntireTable <DBTypeTestObject>();
IEnumerable <DBObject> objects = dstore.SchemaValidator.TableValidator.GetObjects(true);
Assert.IsTrue(objects != null);
DBObject obj = objects.Where(r => r.Name.Equals("DBTypeTestObjects", StringComparison.InvariantCultureIgnoreCase)).FirstOrDefault();
Assert.IsTrue(obj != null);
//to test this.. I'm going to pass the object back through the validator.... no columns should require modification
dstore = SqlLiteDataConnection.GetDataStore(@"C:\TestFile.sqlite");
dstore.SchemaValidator.TableValidator.OnObjectModified += (sender, args) =>
{
Assert.IsTrue(false);
};
dstore.LoadEntireTable <DBTypeTestObject>();
}
public IDataStore GetConnection()
{
return(SqlLiteDataConnection.GetDataStore(File.Text));
}
public override IDataStore GetDataStore()
{
return(SqlLiteDataConnection.GetDataStore(Path.GetTempFileName()));
}
