public void DatabaseTable_IsExists(string tableName)
{
using (var connection = ConnectionUtil.CreateConnection(_dbConnectionString))
{
var sql = $"SELECT name FROM sqlite_master where type='table' and name='{tableName}'";
var result = connection.QueryFirstOrDefault <string>(sql);
Assert.NotNull(result);
Assert.Equal(tableName, result);
}
}
private void InitializeDatabase()
{
var sqliteConn = ConnectionUtil.GetConnectionString();
var databaseName = ConnectionUtil.GetDatabaseName();
if (!File.Exists(databaseName))
{
using (var connection = ConnectionUtil.CreateConnection(sqliteConn))
{
connection.Open();
var storage = _serviceProvider.GetService <IStorageInitializer>();
var token = new CancellationTokenSource().Token;
storage.InitializeAsync(token).GetAwaiter().GetResult();
connection.Close();
}
}
}