private void DeleteAllData()
{
var databaseName = ConnectionUtil.GetDatabaseName();
if (File.Exists(databaseName))
{
File.Delete(databaseName);
}
}
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();
}
}
}
protected DatabaseTestHost()
{
_services = new ServiceCollection();
_services.AddOptions();
_services.AddLogging();
_services.AddCap(options =>
{
options.UseSqlite(ConnectionUtil.GetConnectionString());
});
_serviceProvider = _services.BuildServiceProvider();
Logger = new Mock <ILogger <SqliteDataStorage> >().Object;
CapOptions = GetRequiredService <IOptions <CapOptions> >();
SqliteOptions = GetRequiredService <IOptions <SqliteOptions> >();
InitializeDatabase();
}
public SqliteStorageTest()
{
_dbConnectionString = ConnectionUtil.GetConnectionString();
}
