public OleDBMigrator(IDBIO db, IDBMigrationStepProvider migratorProvider)
{
this._db = db;
this._migrationSteps = (migratorProvider.GetSteps() ?? Enumerable.Empty <IDBMigrationStep>())
.ToDictionary(m => m.ForVersion);
this._tableName = $"{migratorProvider.TablePrefix ?? ""}{kVersionTableName}";
}
public static int Set(this IDBIO dbio, IEnumerable <string> queries, bool throwOnException = true)
{
return(dbio.Set(cmd =>
{
Result <int> queryExecutionResult;
int affectedRows;
affectedRows = 0;
foreach (string query in queries.notEmpty())
{
cmd.CommandText = query;
queryExecutionResult = new Result <int>(cmd.ExecuteNonQuery);
if (queryExecutionResult.Ok)
{
affectedRows += queryExecutionResult.Value;
}
else if (throwOnException)
{
throw queryExecutionResult.Exception;
}
}
return affectedRows;
}));
}
private static IEnumerable <T> prv_get <T>(IDBIO dbio, IDBQuery query, Func <IDataRecord, T> buildDelegate)
{
QueryCompilation queryCompilation;
queryCompilation = query.Compile();
return(prv_get <T>(dbio, queryCompilation.Query, queryCompilation.Parameters, buildDelegate));
}
public static void Set(this IDBIO dbio, Action <IDbCommand> instructions)
{
dbio.Set(cmd =>
{
instructions(cmd);
return(0);
});
}
public DefaultQueryExecutor(IDBIO db, IQueryFactory queryFactory)
{
Asserts.isNotNull(db);
Asserts.isNotNull(queryFactory);
this.db = db;
this.queryFactory = queryFactory;
}
public static int Set(this IDBIO dbio, IDBQuery query)
{
QueryCompilation queryCompilation;
queryCompilation = query.Compile();
return(prv_set(dbio, queryCompilation.Query, queryCompilation.Parameters));
}
public CreateDrop(string connectionString = null, IDBIO db = null)
{
this._connectionString = connectionString ?? System.Configuration.ConfigurationManager.ConnectionStrings["tests"]?.ConnectionString;
if (string.IsNullOrWhiteSpace(this._connectionString))
{
throw new ArgumentException($"Empty or invalid 'tests' connection string in app.config", "tests");
}
this._db = db ?? new SQLServerDBIO(this._connectionString);
}
public OleDBMigrationTests()
{
this.connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["tests"]?.ConnectionString;
if (string.IsNullOrWhiteSpace(this.connectionString))
{
throw new ArgumentException($"Empty or invalid 'tests' connection string in app.config", "tests");
}
this.db = new OleDBIO(this.connectionString);
this.createDrop = new CreateDrop(this.connectionString, this.db);
}
private static int prv_set(IDBIO dbio, string query, IEnumerable <KeyValuePair <string, object> > parameters)
{
return(dbio.Set(cmd =>
{
cmd.CommandText = query;
cmd.addParameters(parameters);
return cmd.ExecuteNonQuery();
}));
}
public static IEnumerable <T> Get <T>(this IDBIO dbio, string query, IEnumerable <KeyValuePair <string, object> > parameters) where T : new()
{
return(prv_get <T>(dbio, query, parameters, AutoMapExtension.AutoMap <T>));
}
int IDBMigrationStep.Upgrade(IDBIO db)
{
return(Upgrade(db));
}
private static IEnumerable <T> prv_get <T>(IDBIO dbio, string query, IEnumerable <KeyValuePair <string, object> > parameters, Func <IDataRecord, T> buildDelegate)
{
return(dbio.Get <T>(query, parameters, buildDelegate));
}
void IDBMigrationStep.Downgrade(IDBIO db)
{
Downgrade?.Invoke(db);
}
public static string getDBEngine(this IDBIO db)
{
return(prv_getDBEngine(db));
}
public static int execute(this IDBQuery query, IDBIO db)
{
return(db.Set(query));
}
public static int Set(this IDBIO dbio, string query)
{
return(prv_set(dbio, query, emptyParameterCollection));
}
public static IEnumerable <T> Get <T>(this IDBIO dbio, string query) where T : new()
{
return(prv_get <T>(dbio, query, emptyParameterCollection, AutoMapExtension.AutoMap <T>));
}
public static IEnumerable <T> Get <T>(this IDBIO dbio, string query, Func <IDataRecord, T> buildDelegate)
{
return(prv_get <T>(dbio, query, emptyParameterCollection, buildDelegate));
}
public static int Set(this IDBIO dbio, string query, IEnumerable <KeyValuePair <string, object> > parameters)
{
return(prv_set(dbio, query, parameters));
}
public static IEnumerable <T> Get <T>(this IDBIO dbio, IDBQuery query) where T : new()
{
return(prv_get <T>(dbio, query, AutoMapExtension.AutoMap <T>));
}
public static DataSet Get(this IDBIO dbio, string query)
{
return(dbio.Get(query, emptyParameterCollection));
}
public static IEnumerable <T> Get <T>(this IDBIO dbio, IDBQuery query, Func <IDataRecord, T> buildDelegate)
{
return(prv_get <T>(dbio, query, buildDelegate));
}
public static T GetScalar <T>(this IDBIO dbio, string query) where T : struct
{
return(dbio.GetScalar <T>(query, emptyParameterCollection));
}
private void DropTableCliente(IDBIO db)
{
db.Set($@"DROP TABLE cliente");
}
