public void SetUp()
{
Factory = new OracleDbFactory();
Connection = Factory.CreateConnection(IntegrationTestOptions.Oracle.ConnectionString);
Quoter = new OracleQuoter();
Processor = new OracleProcessor(Connection, new OracleGenerator(), new TextWriterAnnouncer(System.Console.Out), new ProcessorOptions(), Factory);
}
public void SetUp()
{
if (!IntegrationTestOptions.SqlServerCe.IsEnabled)
{
Assert.Ignore();
}
if (!HostUtilities.ProbeSqlServerCeBehavior())
{
Assert.Ignore("SQL Server CE binaries not found");
}
_tempDataDirectory = Path.Combine(Path.GetTempPath(), Guid.NewGuid().ToString("N"));
Directory.CreateDirectory(_tempDataDirectory);
AppDomain.CurrentDomain.SetData("DataDirectory", _tempDataDirectory);
var csb = new SqlCeConnectionStringBuilder(IntegrationTestOptions.SqlServerCe.ConnectionString);
DatabaseFilename = HostUtilities.ReplaceDataDirectory(csb.DataSource);
RecreateDatabase();
Connection = new SqlCeConnection(IntegrationTestOptions.SqlServerCe.ConnectionString);
Processor = new SqlServerCeProcessor(Connection, new SqlServerCeGenerator(), new TextWriterAnnouncer(TestContext.Out), new ProcessorOptions(), new SqlServerCeDbFactory());
Quoter = new SqlServer2000Quoter();
Connection.Open();
Processor.BeginTransaction();
}
public void SetUp()
{
Connection = new NpgsqlConnection(IntegrationTestOptions.Postgres.ConnectionString);
Processor = new PostgresProcessor(Connection, new PostgresGenerator(), new TextWriterAnnouncer(System.Console.Out), new ProcessorOptions(), new PostgresDbFactory());
Quoter = new PostgresQuoter();
Connection.Open();
}
/// <summary>
/// Initializes a new instance of the <see cref="FirebirdDDLLockTracker"/> class.
/// </summary>
/// <param name="quoter">The Firebird quoter</param>
public FirebirdDDLLockTracker(IQuoter quoter)
{
var comparer = new FirebirdIdentifierComparer(quoter);
_ddlTables = new HashSet <string>(comparer);
_ddlColumns = new Dictionary <string, ISet <string> >(comparer);
}
public ExtendedOracleMigrationGenerator(
OracleQuoterBase quoter,
IDbMigrationConfig dbMigrationConfig)
{
Quoter = quoter;
DbMigrationConfig = dbMigrationConfig;
}
public ExtendedPostgresGenerator(
PostgresQuoter quoter,
IDbConfig dbConfig)
{
Quoter = quoter;
DbConfig = dbConfig;
}
public void SetUp()
{
Connection = new NpgsqlConnection(IntegrationTestOptions.Postgres.ConnectionString);
Processor = new PostgresProcessor(Connection, new PostgresGenerator(), new TextWriterAnnouncer(System.Console.Out), new ProcessorOptions(), new PostgresDbFactory());
Quoter = new PostgresQuoter();
Connection.Open();
}
public void DisableForceQuoteRemovesQuotes()
{
_quoter = new PostgresQuoter(new PostgresOptions()
{
ForceQuote = false
});
_quoter.Quote("TableName").ShouldBe("TableName");
}
protected GenericGenerator(IColumn column,
IQuoter quoter,
IDescriptionGenerator descriptionGenerator,
GeneratorOptions generatorOptions)
: base(column, quoter, descriptionGenerator)
{
CompatibilityMode = generatorOptions.CompatibilityMode ?? CompatibilityMode.LOOSE;
}
public SqlServerCeTestTable(SqlServerCeProcessor processor, params string[] columnDefinitions)
{
Connection = (SqlCeConnection)processor.Connection;
Quoter = new SqlServerQuoter();
Name = "TestTable";
Create(columnDefinitions);
}
protected SqlServer2008Generator(
[NotNull] IColumn column,
[NotNull] IQuoter quoter,
[NotNull] IDescriptionGenerator descriptionGenerator,
[NotNull] IOptions <GeneratorOptions> generatorOptions)
: base(column, quoter, descriptionGenerator, generatorOptions)
{
}
public void SetUp()
{
Connection = new HanaConnection(IntegrationTestOptions.Hana.ConnectionString);
Processor = new HanaProcessor(Connection, new HanaGenerator(), new TextWriterAnnouncer(System.Console.Out), new ProcessorOptions(), new HanaDbFactory());
Quoter = new HanaQuoter();
Connection.Open();
Processor.BeginTransaction();
}
public static string FormatDefaultValue(object defaultValue, IQuoter quoter)
{
if (DefaultValueIsSqlFunction(defaultValue))
{
return(defaultValue.ToString());
}
return(quoter.QuoteValue(defaultValue));
}
public SqlServerCeTestTable(SqlServerCeProcessor processor, QuoterOptions quoterOptions, params string[] columnDefinitions)
{
Connection = (SqlCeConnection)processor.Connection;
Quoter = new SqlServer2000Quoter(new OptionsWrapper <QuoterOptions>(quoterOptions));
Name = "TestTable";
Create(columnDefinitions);
}
public void SetUp()
{
Connection = new SqlConnection(IntegrationTestOptions.SqlServer2012.ConnectionString);
Processor = new SqlServerProcessor(Connection, new SqlServer2012Generator(), new TextWriterAnnouncer(System.Console.Out), new ProcessorOptions(), new SqlServerDbFactory());
Quoter = new SqlServerQuoter();
Connection.Open();
Processor.BeginTransaction();
}
public ColumnBase(ITypeMap typeMap, IQuoter quoter)
{
_typeMap = typeMap;
_quoter = quoter;
ClauseOrder = new List <Func <ColumnDefinition, string> > {
FormatString, FormatType, FormatNullable, FormatDefaultValue, FormatPrimaryKey, FormatIdentity
};
}
public void SetUp()
{
Connection = new HanaConnection(IntegrationTestOptions.Hana.ConnectionString);
Processor = new HanaProcessor(Connection, new HanaGenerator(), new TextWriterAnnouncer(System.Console.Out), new ProcessorOptions(), new HanaDbFactory());
Quoter = new HanaQuoter();
Connection.Open();
Processor.BeginTransaction();
}
public void SetUp()
{
Connection = new SqlConnection(IntegrationTestOptions.SqlServer2012.ConnectionString);
Processor = new SqlServerProcessor(Connection, new SqlServer2012Generator(), new TextWriterAnnouncer(System.Console.Out), new ProcessorOptions(), new SqlServerDbFactory());
Quoter = new SqlServerQuoter();
Connection.Open();
Processor.BeginTransaction();
}
public SqlServerCeTestTable(SqlServerCeProcessor processor, params string[] columnDefinitions)
{
Connection = (SqlCeConnection)processor.Connection;
Quoter = new SqlServer2000Quoter();
Name = "TestTable";
Create(columnDefinitions);
}
public void SetUp()
{
Factory = new OracleDbFactory();
Connection = Factory.CreateConnection(IntegrationTestOptions.Oracle.ConnectionString);
Quoter = new OracleQuoter();
Processor = new OracleProcessor(Connection, new OracleGenerator(), new TextWriterAnnouncer(System.Console.Out), new ProcessorOptions(), Factory);
Connection.Open();
}
public SqlServerProcessor(IEnumerable <string> databaseTypes, IDbConnection connection, GenericGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options, IDbFactory factory)
: base(connection, factory, generator, announcer, options)
{
var dbTypes = databaseTypes.ToList();
DatabaseType = dbTypes.First();
DatabaseTypeAliases = dbTypes.Skip(1).ToList();
Quoter = generator?.Quoter;
}
public void SetUp()
{
if (!IntegrationTestOptions.Postgres.IsEnabled)
Assert.Ignore();
Connection = new NpgsqlConnection(IntegrationTestOptions.Postgres.ConnectionString);
Processor = new PostgresProcessor(Connection, new PostgresGenerator(), new TextWriterAnnouncer(TestContext.Out), new ProcessorOptions(), new PostgresDbFactory());
Quoter = new PostgresQuoter();
Connection.Open();
}
public void SetUp()
{
DatabaseFilename = "TestDatabase.sdf";
RecreateDatabase();
Connection = new SqlCeConnection(IntegrationTestOptions.SqlServerCe.ConnectionString);
Processor = new SqlServerCeProcessor(Connection, new SqlServerCeGenerator(), new TextWriterAnnouncer(System.Console.Out), new ProcessorOptions(), new SqlServerCeDbFactory());
Quoter = new SqlServerQuoter();
Connection.Open();
Processor.BeginTransaction();
}
public SqlServerTestTable(SqlServerProcessor processor, string schemaName, params string[] columnDefinitions)
{
_schemaName = schemaName;
Connection = (SqlConnection)processor.Connection;
Transaction = (SqlTransaction)processor.Transaction;
_quoter = processor.Quoter;
Name = "TestTable";
Create(processor, columnDefinitions);
}
public void DisableForceQuoteQuotesReservedKeyword()
{
_quoter = new PostgresQuoter(new PostgresOptions()
{
ForceQuote = false
});
_quoter.Quote("between").ShouldBe(@"""between""");
_quoter.Quote("BETWEEN").ShouldBe(@"""BETWEEN""");
}
public Db2Column(IQuoter quoter)
: base(new Db2TypeMap(), quoter)
{
this.ClauseOrder = new List <Func <ColumnDefinition, string> > {
FormatString, FormatType, this.FormatCCSID, this.FormatNullable, this.FormatDefaultValue, this.FormatIdentity
};
this.AlterClauseOrder = new List <Func <ColumnDefinition, string> > {
FormatType, this.FormatCCSID, this.FormatNullable, this.FormatDefaultValue, this.FormatIdentity
};
}
public void SetUp()
{
DatabaseFilename = "TestDatabase.sdf";
RecreateDatabase();
Connection = new SqlCeConnection(IntegrationTestOptions.SqlServerCe.ConnectionString);
Processor = new SqlServerCeProcessor(Connection, new SqlServerCeGenerator(), new TextWriterAnnouncer(System.Console.Out), new ProcessorOptions(), new SqlServerCeDbFactory());
Quoter = new SqlServerQuoter();
Connection.Open();
Processor.BeginTransaction();
}
public void SetUp()
{
FbDatabase.CreateDatabase(IntegrationTestOptions.Firebird.ConnectionString);
Connection = new FbConnection(IntegrationTestOptions.Firebird.ConnectionString);
var options = FirebirdOptions.AutoCommitBehaviour();
Processor = new FirebirdProcessor(Connection, new FirebirdGenerator(options), new TextWriterAnnouncer(System.Console.Out), new ProcessorOptions(), new FirebirdDbFactory(), options);
Quoter = new FirebirdQuoter();
Connection.Open();
Processor.BeginTransaction();
}
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 void SetUp()
{
if (!IntegrationTestOptions.Hana.IsEnabled)
{
Assert.Ignore();
}
Connection = new HanaConnection(IntegrationTestOptions.Hana.ConnectionString);
Processor = new HanaProcessor(Connection, new HanaGenerator(), new TextWriterAnnouncer(TestContext.Out), new ProcessorOptions(), new HanaDbFactory());
Quoter = new HanaQuoter();
Connection.Open();
Processor.BeginTransaction();
}
public void SetUp()
{
if (!IntegrationTestOptions.SqlServer2012.IsEnabled)
{
Assert.Ignore();
}
Connection = new SqlConnection(IntegrationTestOptions.SqlServer2012.ConnectionString);
Processor = new SqlServerProcessor(new[] { "SqlServer2012" }, Connection, new SqlServer2012Generator(), new TextWriterAnnouncer(TestContext.Out), new ProcessorOptions(), new SqlServerDbFactory());
Quoter = new SqlServer2008Quoter();
Connection.Open();
Processor.BeginTransaction();
}
public OracleTestTable(IDbConnection connection, IQuoter quoter, string schema, params string[] columnDefinitions)
{
Connection = connection;
Quoter = quoter;
Factory = new OracleDbFactory();
_schema = schema;
if (Connection.State != ConnectionState.Open)
Connection.Open();
Name = "TestTable";
Create(columnDefinitions);
}
public void SetUp()
{
if (!System.IO.File.Exists("fbtest.fdb"))
{
FbConnection.CreateDatabase(IntegrationTestOptions.Firebird.ConnectionString);
}
Connection = new FbConnection(IntegrationTestOptions.Firebird.ConnectionString);
var options = FirebirdOptions.AutoCommitBehaviour();
Processor = new FirebirdProcessor(Connection, new FirebirdGenerator(options), new TextWriterAnnouncer(System.Console.Out), new ProcessorOptions(), new FirebirdDbFactory(), options);
Quoter = new FirebirdQuoter();
Connection.Open();
Processor.BeginTransaction();
}
public OracleColumn(IQuoter quoter)
: base(new OracleTypeMap(), quoter)
{
int a = ClauseOrder.IndexOf(FormatDefaultValue);
int b = ClauseOrder.IndexOf(FormatNullable);
// Oracle requires DefaultValue before nullable
if (a > b)
{
ClauseOrder[b] = FormatDefaultValue;
ClauseOrder[a] = FormatNullable;
}
}
/// <summary>
///
/// </summary>
/// <param name="logger"></param>
/// <param name="generator"></param>
/// <param name="options"></param>
/// <param name="connectionStringAccessor"></param>
/// <param name="factory"></param>
/// <param name="quoter"></param>
/// <param name="serviceProvider"></param>
public SybaseAseProcessor(
[NotNull] ILogger <SybaseAseProcessor> logger,
[NotNull] SybaseAse2000Generator generator,
[NotNull] IOptionsSnapshot <ProcessorOptions> options,
[NotNull] IConnectionStringAccessor connectionStringAccessor,
[NotNull] SybaseAseDbFactory factory,
[NotNull] IQuoter quoter,
[NotNull] IServiceProvider serviceProvider)
: base(() => factory.Factory, generator, logger, options?.Value, connectionStringAccessor)
{
_serviceProvider = serviceProvider;
Quoter = quoter;
}
public OracleColumn(IQuoter quoter)
: base(new OracleTypeMap(), quoter)
{
int a = ClauseOrder.IndexOf(FormatDefaultValue);
int b = ClauseOrder.IndexOf(FormatNullable);
// Oracle requires DefaultValue before nullable
if (a > b)
{
ClauseOrder[b] = FormatDefaultValue;
ClauseOrder[a] = FormatNullable;
}
}
public HanaColumn(IQuoter quoter)
: base(new HanaTypeMap(), quoter)
{
var a = ClauseOrder.IndexOf(FormatDefaultValue);
var b = ClauseOrder.IndexOf(FormatNullable);
// Hana requires DefaultValue before nullable
if (a <= b) return;
ClauseOrder[b] = FormatDefaultValue;
ClauseOrder[a] = FormatNullable;
}
public OracleTestTable(IDbConnection connection, IQuoter quoter, string schema, params string[] columnDefinitions)
{
Connection = connection;
Quoter = quoter;
Factory = new OracleDbFactory();
_schema = schema;
if (Connection.State != ConnectionState.Open)
{
Connection.Open();
}
Name = "TestTable";
Create(columnDefinitions);
}
public HanaColumn(IQuoter quoter)
: base(new HanaTypeMap(), quoter)
{
var a = ClauseOrder.IndexOf(FormatDefaultValue);
var b = ClauseOrder.IndexOf(FormatNullable);
// Hana requires DefaultValue before nullable
if (a <= b)
{
return;
}
ClauseOrder[b] = FormatDefaultValue;
ClauseOrder[a] = FormatNullable;
}
public void SetUp()
{
if (!IntegrationTestOptions.Firebird.IsEnabled)
{
Assert.Ignore();
}
_temporaryDatabase = new TemporaryDatabase(
IntegrationTestOptions.Firebird,
_prober);
Connection = new FbConnection(_temporaryDatabase.ConnectionString);
var options = FirebirdOptions.AutoCommitBehaviour();
Processor = new FirebirdProcessor(Connection, new FirebirdGenerator(options), new TextWriterAnnouncer(TestContext.Out), new ProcessorOptions(), new FirebirdDbFactory(), options);
Quoter = new FirebirdQuoter(false);
Connection.Open();
Processor.BeginTransaction();
}
public MockGenerator(IColumn column, IQuoter quoter, IEvaluator evaluator)
: base(column, quoter, evaluator)
{
}
public GenericGenerator(IColumn column, IQuoter quoter)
: base(column, quoter)
{
compatabilityMode = CompatabilityMode.LOOSE;
}
public void SetUp()
{
quoter = new GenericQuoter();
}
public void SetUp()
{
quoter = new MySqlQuoter();
}
public ColumnBase(ITypeMap typeMap, IQuoter quoter)
{
_typeMap = typeMap;
_quoter = quoter;
ClauseOrder = new List<Func<ColumnDefinition, string>> { FormatString, FormatType, FormatNullable, FormatDefaultValue, FormatPrimaryKey, FormatIdentity };
}
public GeneratorBase(IColumn column, IQuoter quoter, IDescriptionGenerator descriptionGenerator)
{
_column = column;
_quoter = quoter;
_descriptionGenerator = descriptionGenerator;
}
public GeneratorBase(IColumn column, IQuoter quoter, IEvaluator evaluator)
{
_column = column;
_quoter = quoter;
_evaluator = evaluator;
}
public PostgresDescriptionGenerator()
{
_quoter = new PostgresQuoter();
}
public void SetUp()
{
_quoter = new OracleQuoter();
}
public GeneratorBase(IColumn column, IQuoter quoter)
{
_column = column;
_quoter = quoter;
}
public GenericGenerator(IColumn column, IQuoter quoter, IDescriptionGenerator descriptionGenerator)
: base(column, quoter, descriptionGenerator)
{
compatabilityMode = CompatabilityMode.LOOSE;
}
public PostgresColumn(IQuoter quoter)
: base(new PostgresTypeMap(), quoter)
{
AlterClauseOrder = new List<Func<ColumnDefinition, string>> { FormatAlterType, FormatAlterNullable };
}
public MockGenerator(IColumn column, IQuoter quoter)
: base(column, quoter)
{
}
