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(); }