public void Members_DifferentArguments_HaveExpectedProps()
{
// Arrange
IUtilityFactory utilityFactory = SQLiteUtilityFactory.Instance;
// get SQLite stuff loaded.
using (new SQLiteConnection())
{
}
// Act
var dbProviderName = utilityFactory.DbProviderName;
IDbConnection connection = utilityFactory.CreateConnection();
var tuple = DbUtils.CreateSQLiteConnectionString();
var filePath = tuple.Item1;
var connectionString = tuple.Item2;
connection.ConnectionString = connectionString;
connection.Open();
IDialect dialect = utilityFactory.GetDialect();
IScriptBuilder scriptBuilder = utilityFactory.CreateScriptBuilder();
IDbInspector dbInspector = utilityFactory.CreateDbInspector(connection);
ITableInspector tableInspector = utilityFactory.CreateTableInspector(connection, "language");
ICruder cruder = utilityFactory.CreateCruder(connection);
IDbSerializer dbSerializer = utilityFactory.CreateDbSerializer(connection);
// Assert
Assert.That(dbProviderName, Is.EqualTo("SQLite"));
Assert.That(connection, Is.TypeOf <SQLiteConnection>());
Assert.That(dialect, Is.SameAs(SQLiteDialect.Instance));
Assert.That(scriptBuilder, Is.TypeOf <SQLiteScriptBuilder>());
Assert.That(scriptBuilder.CurrentOpeningIdentifierDelimiter, Is.EqualTo('['));
Assert.That(dbInspector, Is.TypeOf <SQLiteInspector>());
Assert.That(tableInspector, Is.TypeOf <SQLiteTableInspector>());
Assert.That(cruder, Is.TypeOf <SQLiteCruder>());
Assert.That(dbSerializer, Is.TypeOf <SQLiteSerializer>());
// Finalize
connection.Dispose();
try
{
File.Delete(filePath);
}
catch
{
// dismiss
}
}
protected virtual void OneTimeSetUpImpl()
{
this.Connection = new SqlConnection(TestHelper.ConnectionString);
this.Connection.Open();
this.DbInspector = new SqlServerInspector(Connection);
this.DbInspector.DropAllTables();
this.ExecuteDbCreationScript();
}
public ApiController(ILogger <ApiController> logger, IDbInspector dbInspector, IDbConnectionProvider dbConnectionProvider,
FormCreator formsCreator, IHttpContextAccessor httpContextAccessor, DbMutator dbMutator, ILinkManager linkManager)
{
_logger = logger;
_dbInspector = dbInspector;
_dbConnectionProvider = dbConnectionProvider;
_formsCreator = formsCreator;
_httpContextAccessor = httpContextAccessor;
_dbMutator = dbMutator;
_linkManager = linkManager;
}
public static void DeleteDataFromAllTables(this IDbInspector dbInspector)
{
var tableNames = dbInspector.GetTableNames(false);
var scriptBuilder = dbInspector.Factory.CreateScriptBuilder();
foreach (var tableName in tableNames)
{
var sql = scriptBuilder.BuildDeleteScript(tableName);
dbInspector.Connection.ExecuteSingleSql(sql);
}
}
public static IList <TableMold> GetTables(
this IDbInspector dbInspector,
bool?independentFirst = null,
Func <string, bool> tableNamePredicate = null)
{
return(dbInspector
.GetTableNames(independentFirst)
.Where(tableNamePredicate ?? (x => true))
.Select(x => dbInspector
.Factory
.CreateTableInspector(dbInspector.Connection, x)
.GetTable())
.ToList());
}
protected virtual void OneTimeSetUpImpl()
{
var tuple = DbUtils.CreateSQLiteConnectionString();
this.TempDbFilePath = tuple.Item1;
this.ConnectionString = tuple.Item2;
this.Connection = new SQLiteConnection(this.ConnectionString);
this.Connection.Open();
((SQLiteConnection)this.Connection).BoostSQLiteInsertions();
this.DbInspector = new SQLiteInspector(Connection);
this.ExecuteDbCreationScript();
}
public void Members_DifferentArguments_HaveExpectedProps()
{
// Arrange
IUtilityFactory utilityFactory = SqlServerUtilityFactory.Instance;
// Act
var dbProviderName = utilityFactory.DbProviderName;
IDbConnection connection = utilityFactory.CreateConnection();
connection.ConnectionString = TestHelper.ConnectionString;
connection.Open();
IDialect dialect = utilityFactory.GetDialect();
IScriptBuilder scriptBuilder = utilityFactory.CreateScriptBuilder();
IDbInspector dbInspector = utilityFactory.CreateDbInspector(connection);
ITableInspector tableInspector = utilityFactory.CreateTableInspector(connection, "language");
ICruder cruder = utilityFactory.CreateCruder(connection);
IDbSerializer dbSerializer = utilityFactory.CreateDbSerializer(connection);
// Assert
Assert.That(dbProviderName, Is.EqualTo("SqlServer"));
Assert.That(connection, Is.TypeOf <SqlConnection>());
Assert.That(dialect, Is.SameAs(SqlServerDialect.Instance));
Assert.That(scriptBuilder, Is.TypeOf <SqlServerScriptBuilder>());
Assert.That(scriptBuilder.CurrentOpeningIdentifierDelimiter, Is.EqualTo('['));
Assert.That(dbInspector, Is.TypeOf <SqlServerInspector>());
Assert.That(tableInspector, Is.TypeOf <SqlServerTableInspector>());
Assert.That(cruder, Is.TypeOf <SqlServerCruder>());
Assert.That(dbSerializer, Is.TypeOf <SqlServerSerializer>());
}
public DbMutator(IDbInspector dbInspector, IDbConnectionProvider connectionProvider)
{
_dbInspector = dbInspector;
_connectionProvider = connectionProvider;
}
public FormCreator(IDbInspector dbInspector, IDbConnectionProvider connectionProvider, ILinkManager linkManager)
{
_dbInspector = dbInspector;
_connectionProvider = connectionProvider;
_linkManager = linkManager;
}
public ItemSerializer(IDbInspector dbInspector, ILinkManager linkManager)
{
_dbInspector = dbInspector;
_linkManager = linkManager;
}
