public void GetMetaDataSQLiteTests()
{
string testDbPath = AppDomain.CurrentDomain.BaseDirectory + @"\Files\test.sqlite.db";
// To enable tests in a virtual machine (change the letter accordingly)
if (!Char.IsLetter(testDbPath.First()))
{
testDbPath = "Z:" + testDbPath.Substring(10);
}
ConnectionParameters conParams = new ConnectionParameters("SQLite", "SQLite Connection", "", testDbPath);
Assert.IsTrue(DBWorker.ConfigureDBConnection(conParams), "SQLite connection configured");
Assert.IsNotNull(DBWorker.GetMetaData(DBWorker.SqlCreator.FactTableName, DBWorker.SqlCreator.EventTableName), "Load MetaData for Oracle");
DBWorker.Reset();
}
public void GetMetaDataMSSQLTests()
{
ConnectionParameters conParams = new ConnectionParameters
{
Type = "MS-SQL",
Name = "MS-SQL Connection",
Host = Settings.Default.mssql_host,
Database = Settings.Default.mssql_database,
Port = Settings.Default.mssql_port,
User = Settings.Default.mssql_user,
Password = Settings.Default.mssql_password
};
Assert.IsTrue(DBWorker.ConfigureDBConnection(conParams), "MS-SQL connection configured");
Assert.IsNotNull(DBWorker.GetMetaData(DBWorker.SqlCreator.FactTableName, DBWorker.SqlCreator.EventTableName), "Load MetaData for Oracle");
DBWorker.Reset();
}