public SqlServerProcessor(SqlConnection connection, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options)
: base(generator, announcer, options)
{
Connection = connection;
connection.Open();
Transaction = connection.BeginTransaction();
}
public ComparisonWriter(SqlType sqlType)
{
_sqlType = sqlType;
var ddlFactory = new DdlGeneratorFactory(sqlType);
_migration = ddlFactory.MigrationGenerator();
}
public SqlServerProcessor(SqlConnection connection, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options)
: base(generator, announcer, options)
{
Connection = connection;
connection.Open();
Transaction = connection.BeginTransaction();
}
protected GenericProcessorBase(IDbConnection connection, IDbFactory factory
, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options)
: base(generator, announcer, options)
{
Connection = connection;
Factory = factory;
}
public ExtendedOracleProcessorBase(OracleBaseDbFactory factory,
IMigrationGenerator generator,
ILogger logger,
IOptionsSnapshot <ProcessorOptions> options,
IOptionsSnapshot <RunnerOptions> runnerOptions,
IConnectionStringAccessor connectionStringAccessor,
IExtendedMigrationGenerator <ExtendedOracleMigrationGenerator> extendedGenerator,
IDbMigrationConfig migrationConfig,
IMigrationSourceItem migrationSourceItem = null,
IVersionTableMetaData versionTableMetaData = null,
IOptions <FluentMigratorLoggerOptions> loggerGenOptions = null,
IOptions <LogFileFluentMigratorLoggerOptions> logFileOptions = null) : base(ProcessorIds.OracleProcessorId, factory, generator, logger, options, connectionStringAccessor)
{
RunnerOptions = runnerOptions;
MigrationConfig = migrationConfig;
VersionTableMetaData = versionTableMetaData;
LoggerOptions = loggerGenOptions?.Value;
LoggerFileOptions = logFileOptions?.Value;
IsSqlLogEnabled = (LoggerOptions?.ShowSql ?? false) || (LoggerFileOptions?.ShowSql ?? false);
ExtendedGenerator = extendedGenerator;
MigrationMetadata = new MigrationMetadata(migrationSourceItem).InitMetadata(MigrationConfig);
ConnectionStringFunc = () => connectionStringAccessor.ConnectionString;
Initialize();
}
public ConnectionlessProcessor(IMigrationGenerator generator, IRunnerContext context, IMigrationProcessorOptions options)
{
Generator = generator;
Context = context;
Announcer = Context.Announcer;
Options = options;
}
public AzureProcessor(IDbConnection connection, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options, IDbFactory factory)
: base(generator, announcer, options)
{
this.factory = factory;
Connection = connection;
connection.Open();
}
public ConnectionlessProcessor(IMigrationGenerator generator, IRunnerContext context, IMigrationProcessorOptions options)
{
Generator = generator;
Context = context;
Announcer = Context.Announcer;
Options = options;
}
protected GenericProcessorBase(IDbConnection connection, IDbFactory factory
, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options)
: base(generator, announcer, options)
{
Connection = connection;
Factory = factory;
}
public PostgresProcessor(NpgsqlConnection connection, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options)
: base(generator, announcer, options)
{
Connection = connection;
connection.Open();
Transaction = connection.BeginTransaction();
}
public JetProcessor(OleDbConnection connection, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options)
: base(generator, announcer, options)
{
Connection = connection;
connection.Open();
BeginTransaction();
}
public SqlServerProcessor(IDbConnection connection, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options, IDbFactory factory)
: base(generator, announcer, options)
{
this.factory = factory;
Connection = connection;
connection.Open();
BeginTransaction();
}
public OracleProcessor(OracleConnection connection, IMigrationGenerator generator)
{
this.generator = generator;
Connection = connection;
//oracle does not support ddl transactions
//this.Transaction = this.Connection.BeginTransaction();
}
public SqlServerProcessor(DbConnection connection, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options, IDbFactory factory)
: base(generator, announcer, options)
{
this.factory = factory;
Connection = connection;
connection.Open();
BeginTransaction();
}
private static void WriteSqlFile(IMigrationContext migrationContext, IMigrationGenerator migrationGenerator, string sqlScriptsDirectory, IMigrationInfo migration)
{
IEnumerable <string> sqlExpressions = migration.GetSqlExpressions(migrationContext, migrationGenerator);
string fileName = $"{migration.GetName().Replace(": ", "_")}.sql";
string path = Path.Combine(sqlScriptsDirectory, fileName);
File.WriteAllLines(path, sqlExpressions);
}
public MonoSQLiteProcessor(IDbConnection connection,
IMigrationGenerator generator,
IAnnouncer announcer,
IMigrationProcessorOptions options,
IDbFactory factory)
: base(connection, generator, announcer, options, factory)
{
}
protected ProcessorBase(IMigrationGenerator generator,
ILogger logger,
ProcessorOptions options)
{
Generator = generator;
Options = options;
Logger = logger;
}
public OracleProcessor(IDbConnection connection, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options)
: base(generator, announcer, options)
{
Connection = connection;
//oracle does not support ddl transactions
//this.Transaction = this.Connection.BeginTransaction();
}
public ConnectionlessProcessorFactory(
[NotNull] IGeneratorAccessor generatorAccessor,
[NotNull] IRunnerContext runnerContext)
{
_generator = generatorAccessor.Generator;
_databaseId = runnerContext.Database;
Name = _generator.GetName();
}
public OracleProcessor(IDbConnection connection, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options, OracleDbFactory factory)
: base(generator, announcer, options)
{
Connection = connection;
_factory = factory;
//oracle does not support ddl transactions
//this.Transaction = this.Connection.BeginTransaction();
}
public ExtendedOracleProcessorBase(OracleBaseDbFactory factory,
IMigrationGenerator generator,
ILogger logger,
IOptionsSnapshot <ProcessorOptions> options,
IConnectionStringAccessor connectionStringAccessor,
IExtendedMigrationGenerator <ExtendedOracleMigrationGenerator> extendedGenerator) : base(ProcessorIds.OracleProcessorId, factory, generator, logger, options, connectionStringAccessor)
{
ExtendedGenerator = extendedGenerator;
}
public OracleProcessor(
IDbConnection connection,
IMigrationGenerator generator,
IAnnouncer announcer,
IMigrationProcessorOptions options,
IDbFactory factory)
: base("Oracle", connection, generator, announcer, options, factory)
{
}
public SqlTasks(SqlType sqlType)
{
m_sqlType = sqlType;
m_migrationGenerator = new DdlGeneratorFactory(sqlType).MigrationGenerator();
if (m_mapping.Count == 0)
{
InitMapping();
}
}
public JetProcessor(OleDbConnection connection, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options)
: base(generator, announcer, options)
{
Connection = connection;
// Prefetch connectionstring as after opening the security info could no longer be present
// for instance on sql server
connectionString = connection.ConnectionString;
}
public JetProcessor(OleDbConnection connection, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options)
: base(generator, announcer, options)
{
Connection = connection;
// Prefetch connectionstring as after opening the security info could no longer be present
// for instance on sql server
connectionString = connection.ConnectionString;
}
public SQLiteProcessor(
IDbConnection connection,
IMigrationGenerator generator,
IAnnouncer announcer,
[NotNull] IMigrationProcessorOptions options,
IDbFactory factory)
: base(connection, factory, generator, announcer, options)
{
}
protected MySqlProcessor(
[NotNull] MySqlDbFactory factory,
[NotNull] IMigrationGenerator generator,
[NotNull] ILogger <MySqlProcessor> logger,
[NotNull] IOptionsSnapshot <ProcessorOptions> options,
[NotNull] IConnectionStringAccessor connectionStringAccessor)
: base(() => factory.Factory, generator, logger, options.Value, connectionStringAccessor)
{
}
public SQLiteProcessor(
IDbConnection connection,
IMigrationGenerator generator,
IAnnouncer announcer,
[NotNull] IMigrationProcessorOptions options,
IDbFactory factory)
: base(connection, factory, generator, announcer, options)
{
_batchParserFactory = new SQLiteBatchParserFactory(null);
}
public PostgresProcessor(IDbConnection connection, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options, IDbFactory factory)
: base(generator, announcer, options)
{
this.factory = factory;
Connection = connection;
connection.Open();
Announcer.Say("Beginning Transaction");
Transaction = Connection.BeginTransaction();
}
public SqlServerProcessor(IEnumerable <string> databaseTypes, IMigrationGenerator generator, ILogger logger,
ProcessorOptions options)
: base(() => SqlClientFactory.Instance, generator, logger, options)
{
batchParser = new SqlServerBatchParser();
var dbTypes = databaseTypes.ToList();
DatabaseType = dbTypes.First();
DatabaseTypeAliases = dbTypes.Skip(1).ToList();
}
public PostgresProcessor(IDbConnection connection, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options, IDbFactory factory)
: base(generator, announcer, options)
{
this.factory = factory;
Connection = connection;
connection.Open();
Announcer.Say("Beginning Transaction");
Transaction = Connection.BeginTransaction();
}
public FirebirdProcessor(IDbConnection connection, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options, IDbFactory factory, FirebirdOptions fbOptions)
: base(connection, factory, generator, announcer, options)
{
FBOptions = fbOptions ?? throw new ArgumentNullException(nameof(fbOptions));
_firebirdVersionFunc = new Lazy <Version>(GetFirebirdVersion);
_quoter = new FirebirdQuoter(fbOptions.ForceQuote);
truncator = new FirebirdTruncator(FBOptions.TruncateLongNames, FBOptions.PackKeyNames);
ClearLocks();
ClearDDLFollowers();
}
protected SqlServerProcessor(
[NotNull, ItemNotNull] IEnumerable <string> databaseTypes,
[NotNull] IMigrationGenerator generator,
[NotNull] IQuoter quoter,
[NotNull] ILogger logger,
[NotNull] IOptionsSnapshot <ProcessorOptions> options,
[NotNull] IConnectionStringAccessor connectionStringAccessor,
[NotNull] IServiceProvider serviceProvider)
: this(databaseTypes, SqlClientFactory.Instance, generator, quoter, logger, options, connectionStringAccessor, serviceProvider)
{
}
public ExtendedOracleProcessorBase(
IDbConfig dbConfig,
OracleBaseDbFactory factory,
IMigrationGenerator generator,
ILogger logger,
IOptionsSnapshot <ProcessorOptions> options,
IConnectionStringAccessor connectionStringAccessor,
IExtendedMigrationGenerator <ExtendedOracleMigrationGenerator> extendedGenerator) : base(dbConfig.DbType.GetProcessorId(), factory, generator, logger, options, connectionStringAccessor)
{
ExtendedGenerator = extendedGenerator;
}
protected OracleProcessorBase(
[NotNull] string databaseType,
IDbConnection connection,
IMigrationGenerator generator,
IAnnouncer announcer,
IMigrationProcessorOptions options,
IDbFactory factory)
: base(connection, factory, generator, announcer, options)
{
DatabaseType = databaseType;
}
public PostgresProcessor(IDbConnection connection, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options, IDbFactory factory,
[NotNull] PostgresOptions pgOptions)
: base(connection, factory, generator, announcer, options)
{
if (pgOptions == null)
{
throw new ArgumentNullException(nameof(pgOptions));
}
_quoter = new PostgresQuoter(pgOptions);
}
protected OracleProcessorBase(
[NotNull] string databaseType,
[NotNull] OracleBaseDbFactory factory,
[NotNull] IMigrationGenerator generator,
[NotNull] ILogger logger,
[NotNull] IOptionsSnapshot <ProcessorOptions> options,
[NotNull] IConnectionStringAccessor connectionStringAccessor)
: base(() => factory.Factory, generator, logger, options.Value, connectionStringAccessor)
{
DatabaseType = databaseType;
}
protected ProcessorBase(
[NotNull] IMigrationGenerator generator,
[NotNull] IAnnouncer announcer,
[NotNull] ProcessorOptions options)
{
Generator = generator;
Announcer = announcer;
Options = options;
_legacyOptions = options;
Logger = new AnnouncerFluentMigratorLogger(announcer);
}
public ConnectionlessProcessor(
IMigrationGenerator generator,
IRunnerContext context,
IMigrationProcessorOptions options)
{
_logger = new AnnouncerFluentMigratorLogger(context.Announcer);
_legacyOptions = options;
DatabaseType = context.Database;
Generator = generator;
Announcer = context.Announcer;
Options = options.GetProcessorOptions(connectionString: null);
}
protected GenericProcessorBase(IDbConnection connection, IDbFactory factory
, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options)
: base(generator, announcer, options)
{
Connection = connection;
// Prefetch connectionstring as after opening the security info could no longer be present
// for instance on sql server
connectionString = connection.ConnectionString;
Factory = factory;
}
public FirebirdProcessor(IDbConnection connection, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options, IDbFactory factory, FirebirdOptions fbOptions)
: base(generator, announcer, options)
{
FBOptions = fbOptions;
truncator = new FirebirdTruncator(FBOptions.TruncateLongNames);
Factory = factory;
Connection = connection;
connection.Open();
BeginTransaction();
}
protected GenericProcessorBase(IDbConnection connection, IDbFactory factory
, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options)
: base(generator, announcer, options)
{
Connection = connection;
// Prefetch connectionstring as after opening the security info could no longer be present
// for instance on sql server
connectionString = connection.ConnectionString;
Factory = factory;
}
public JetProcessor(OleDbConnection connection, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options)
: base(generator, announcer, options)
{
Connection = connection;
}
public ComparisonWriter(SqlType sqlType)
{
_sqlType = sqlType;
var ddlFactory = new DdlGeneratorFactory(sqlType);
_migration = ddlFactory.MigrationGenerator();
}
public FileProcessor(string dumpFilename, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options)
: base(generator, announcer, options)
{
DumpFilename = string.Format("{0}.{1}.sql", dumpFilename, FormattedDateTime);
File.Delete(DumpFilename);
}
public void Setup()
{
generator = new SqlServer2012Generator();
}
public SqlServerProcessor(SqlConnection connection, IMigrationGenerator generator)
{
this.generator = generator;
Connection = connection;
Transaction = Connection.BeginTransaction();
}
protected ProcessorBase(IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options)
{
Generator = generator;
Announcer = announcer;
Options = options;
}
public DotConnectOracleProcessor(IDbConnection connection, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options, DotConnectOracleDbFactory factory)
: base(connection, factory, generator, announcer, options)
{
}
public PostgresProcessor(DbConnection connection, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options, IDbFactory factory)
: base(connection, factory, generator, announcer, options)
{
}
public SqlServerProcessor(SqlConnection connection, IMigrationGenerator generator)
{
this.generator = generator;
Connection = connection;
}
public Db2Processor(DbConnection connection, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options, IDbFactory factory)
: base(connection, factory, generator, announcer, options)
{
this.Quoter = new Db2Quoter();
}
public SqliteProcessor(IDbConnection connection, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options, DbFactoryBase factory)
: base(generator, announcer, options)
{
this.factory = factory;
Connection = connection;
}
public SqliteProcessor(SQLiteConnection connection, IMigrationGenerator generator)
{
this.generator = generator;
Connection = connection;
}
public MySqlProcessor(MySqlConnection connection, IMigrationGenerator generator)
{
this.generator = generator;
Connection = connection;
}
public SqliteProcessor(SQLiteConnection connection, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options)
: base(generator, announcer, options)
{
Connection = connection;
}
public SqlServerCeProcessor(IDbConnection connection, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options, IDbFactory factory)
: base(connection, factory, generator, announcer, options)
{
}
public FileProcessor(string dumpFilename, IMigrationGenerator generator)
{
this.generator = generator;
DumpFilename = string.Format("{0}.{1}.sql", dumpFilename, FormattedDateTime);
File.Delete(DumpFilename);
}
public MySqlProcessor(MySqlConnection connection, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options)
: base(generator, announcer, options)
{
Connection = connection;
}
public void Setup()
{
Generator = new SqlServer2008Generator();
}
