public void GetOraConnectionTest()
{
OracleDataService ds = CreateOracleDataServiceForTests();
IDbConnection cnn = ds.GetConnection();
Assert.NotNull(cnn);
}
/// <summary>
/// Метод для создания OracleDataService для целей тестирования.
/// </summary>
/// <returns>Сконструированный OracleDataService.</returns>
public static OracleDataService CreateOracleDataServiceForTests()
{
var ds = new OracleDataService();
ds.CustomizationString = "Data Source=dbserver-oracle;User ID=ora_tester;Password=pwd;";
return(ds);
}
public IMigrationService Create(string platform)
{
switch (platform.ToLower())
{
case SUPPORTED_DATABASES.SQLSERVER:
{
var dataService = new SqlServerDataService(_traceService);
var bulkImportService = new SqlServerBulkImportService(_traceService);
return(CreateInternal(dataService, bulkImportService));
}
case SUPPORTED_DATABASES.POSTGRESQL:
{
var dataService = new PostgreSqlDataService(_traceService);
var bulkImportService = new PostgreSqlBulkImportService(_traceService);
return(CreateInternal(dataService, bulkImportService));
}
case SUPPORTED_DATABASES.MYSQL:
{
var dataService = new MySqlDataService(_traceService);
var bulkImportService = new MySqlBulkImportService(_traceService);
return(CreateInternal(dataService, bulkImportService));
}
case SUPPORTED_DATABASES.MARIADB:
{
var dataService = new MySqlDataService(_traceService);
var bulkImportService = new MySqlBulkImportService(_traceService);
return(CreateInternal(dataService, bulkImportService));
}
case SUPPORTED_DATABASES.SNOWFLAKE:
{
var dataService = new SnowflakeDataService(_traceService);
var bulkImportService = new SnowflakeBulkImportService(_traceService);
return(CreateInternal(dataService, bulkImportService));
}
case SUPPORTED_DATABASES.REDSHIFT:
{
var dataService = new RedshiftDataService(_traceService);
var bulkImportService = new RedshiftBulkImportService(_traceService);
return(CreateInternal(dataService, bulkImportService));
}
case SUPPORTED_DATABASES.ORACLE:
{
var dataService = new OracleDataService(_traceService);
var bulkImportService = new OracleBulkImportService(_traceService);
return(CreateInternal(dataService, bulkImportService));
}
default:
throw new NotSupportedException($"The target database platform {platform} is not supported or plugins location was not correctly configured. " +
$"See WIKI for supported database platforms and usage guide.");
}
}
/// <summary>
/// Initializes a new instance of the <see cref="BaseIntegratedTest" /> class.
/// </summary>
/// <param name="tempDbNamePrefix">Prefix for temp database name.</param>
protected BaseIntegratedTest(string tempDbNamePrefix)
{
Configuration configuration = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
string connectionStringsConfigSectionName = "connectionStrings";
ConnectionStringsSection connectionStringsSection = (ConnectionStringsSection)configuration.GetSection(connectionStringsConfigSectionName);
if (!(tempDbNamePrefix != null))
{
throw new ArgumentNullException();
}
if (!(tempDbNamePrefix != string.Empty))
{
throw new ArgumentException();
}
if (!tempDbNamePrefix.All(char.IsLetterOrDigit))
{
throw new ArgumentException();
}
_tempDbNamePrefix = tempDbNamePrefix;
_databaseName = _tempDbNamePrefix + "_" + DateTime.Now.ToString("yyyyMMddHHmmssff") + "_" + Guid.NewGuid().ToString("N");
if (!string.IsNullOrWhiteSpace(PostgresScript) && ConnectionStringPostgres != poolingFalseConst)
{
if (!(tempDbNamePrefix.Length <= 12)) // Max length is 63 (-18 -32).
{
throw new ArgumentException();
}
if (!char.IsLetter(tempDbNamePrefix[0])) // Database names must have an alphabetic first character.
{
throw new ArgumentException();
}
using (var conn = new NpgsqlConnection(ConnectionStringPostgres))
{
conn.Open();
using (var cmd = new NpgsqlCommand(string.Format("CREATE DATABASE \"{0}\" ENCODING = 'UTF8' CONNECTION LIMIT = -1;", _databaseName), conn))
cmd.ExecuteNonQuery();
}
using (var conn = new NpgsqlConnection($"{ConnectionStringPostgres};Database={_databaseName}"))
{
conn.Open();
using (var cmd = new NpgsqlCommand(PostgresScript, conn))
cmd.ExecuteNonQuery();
string connStr = $"{ConnectionStringPostgres};Database={_databaseName}";
PostgresDataService dataService = CreatePostgresDataService(connStr);
_dataServices.Add(dataService);
InitAuditService(dataService);
connectionStringsSection.ConnectionStrings.Add(new ConnectionStringSettings($"{dataService.AuditService.AppSetting.AppName}_{dataService.AuditService.AppSetting.AuditConnectionStringName}", connStr));
}
}
if (!string.IsNullOrWhiteSpace(MssqlScript) && ConnectionStringMssql != poolingFalseConst)
{
if (!(tempDbNamePrefix.Length <= 64))// Max is 128.
{
throw new ArgumentException();
}
using (var connection = new SqlConnection(ConnectionStringMssql))
{
connection.Open();
using (var command = new SqlCommand($"CREATE DATABASE {_databaseName} COLLATE Cyrillic_General_CI_AS", connection))
command.ExecuteNonQuery();
}
using (var connection = new SqlConnection($"{ConnectionStringMssql};Database={_databaseName}"))
{
connection.Open();
using (var command = new SqlCommand(MssqlScript, connection))
{
command.CommandTimeout = 180;
command.ExecuteNonQuery();
}
string connStr = $"{ConnectionStringMssql};Database={_databaseName}";
MSSQLDataService dataService = CreateMssqlDataService(connStr);
_dataServices.Add(dataService);
InitAuditService(dataService);
connectionStringsSection.ConnectionStrings.Add(new ConnectionStringSettings($"{dataService.AuditService.AppSetting.AppName}_{dataService.AuditService.AppSetting.AuditConnectionStringName}", connStr));
}
}
if (!string.IsNullOrWhiteSpace(OracleScript) && ConnectionStringOracle != poolingFalseConst)
{
if (!(tempDbNamePrefix.Length <= 8)) // Max length is 30 (-18 -4).
{
throw new ArgumentException();
}
using (var connection = new OracleConnection(ConnectionStringOracle))
{
connection.Open();
using (var command = connection.CreateCommand())
{
// "CREATE USER" privileges required.
var doWhile = true;
while (doWhile)
{
_tmpUserNameOracle = tempDbNamePrefix + "_" + DateTime.Now.ToString("yyyyMMddHHmmssff") + "_" + new Random().Next(9999);
command.CommandText = $"CREATE USER {_tmpUserNameOracle} IDENTIFIED BY {_tmpUserNameOracle} DEFAULT TABLESPACE users quota unlimited on users TEMPORARY TABLESPACE temp";
try
{
command.ExecuteNonQuery();
}
catch (OracleException ex)
{
Thread.Sleep(1000);
if (ex.Message.Contains("conflicts with another user or role name "))
{
continue;
}
throw;
}
doWhile = false;
}
// "CREATE SESSION WITH ADMIN OPTION" privileges required.
command.CommandText = $"GRANT CREATE SESSION TO {_tmpUserNameOracle}";
command.ExecuteNonQuery();
command.CommandText = $"GRANT CREATE TABLE TO {_tmpUserNameOracle}";
command.ExecuteNonQuery();
}
}
using (var connection = new OracleConnection($"{ConnectionStringOracleDataSource};User Id={_tmpUserNameOracle};Password={_tmpUserNameOracle};"))
{
connection.Open();
using (var command = connection.CreateCommand())
{
foreach (var cmdText in OracleScript.Split(new[] { ';' }, StringSplitOptions.RemoveEmptyEntries))
{
command.CommandText = cmdText.Trim();
if (!string.IsNullOrWhiteSpace(command.CommandText))
{
command.ExecuteNonQuery();
}
}
string connStr = $"{ConnectionStringOracleDataSource};User Id={_tmpUserNameOracle};Password={_tmpUserNameOracle};";
OracleDataService dataService = CreateOracleDataService(connStr);
_dataServices.Add(dataService);
InitAuditService(dataService);
connectionStringsSection.ConnectionStrings.Add(new ConnectionStringSettings($"{dataService.AuditService.AppSetting.AppName}_{dataService.AuditService.AppSetting.AuditConnectionStringName}", connStr));
}
}
}
configuration.Save();
ConfigurationManager.RefreshSection(connectionStringsConfigSectionName);
}
