private void CreateSqLiteDatabaseWithWrongTablename()
{
var query = "DROP TABLE IF EXISTS[MonitoringTable]; " +
"CREATE TABLE IF NOT EXISTS [WrongTable] " +
"(id INTEGER PRIMARY KEY AUTOINCREMENT, " +
"'Author' TEXT);";
ExecuteQuery(query);
_sqLiteRepository = new JobHistorySqLiteRepository(_assemblyHelper, _osHelper, _dbPathProvider);
}
private void CreateSqLiteDatabase()
{
var query = "CREATE TABLE IF NOT EXISTS [MonitoringTable] " +
"(id INTEGER PRIMARY KEY AUTOINCREMENT, " +
"'Author' TEXT, " +
"'Keywords' TEXT, " +
"'PrintJobAuthor' TEXT, " +
"'PrintJobName' TEXT, " +
"'ComputerName' TEXT, " +
"'Producer' TEXT, " +
"'Subject' TEXT, " +
"'Title' TEXT, " +
"'ElapsedTime' NUMERIC, " +
"'Format' TEXT, " +
"'Pages' INTEGER, " +
"'SizeInByte' INTEGER, " +
"'Result' TEXT, " +
"'Date' TEXT);";
ExecuteQuery(query);
_sqLiteRepository = new JobHistorySqLiteRepository(_assemblyHelper, _osHelper, _dbPathProvider);
}
