static void Main(string[] args)
{
// open a dummy connection to satisfy licensing requirements
var oracleConnection = Environment.GetEnvironmentVariable("ORACLE_CONNECTION");
var devartLicenseKey = Environment.GetEnvironmentVariable("DEVART_LICENSE_KEY");
var connection = new OracleConnection($"{oracleConnection};License Key={devartLicenseKey}");
connection.Open();
var sql = @"
;
CREATE TABLE foo(
new_col CHAR(2 BYTE) NOT NULL,
CONSTRAINT countries_pk PRIMARY KEY (new_col)
);
";
var script = new OracleScript(sql);
foreach (OracleSqlStatement statement in script.Statements)
{
Console.WriteLine("--------------");
Console.WriteLine(statement.Text);
}
}
/// <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)
{
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))
{
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("CREATE EXTENSION postgis;", conn)
{
CommandTimeout = 60
})
cmd.ExecuteNonQuery();
string[] commands = PostgresScript.Split(new[] { ';' }, StringSplitOptions.RemoveEmptyEntries);
foreach (var command in commands)
{
using (var cmd = new NpgsqlCommand(command, conn))
{
cmd.ExecuteNonQuery();
}
}
_dataServices.Add(CreatePostgresDataService($"{ConnectionStringPostgres};Database={_databaseName}"));
}
}
if (!string.IsNullOrWhiteSpace(MssqlScript))
{
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();
}
_dataServices.Add(CreateMssqlDataService($"{ConnectionStringMssql};Database={_databaseName}"));
}
}
if (!string.IsNullOrWhiteSpace(OracleScript))
{
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.
_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";
command.ExecuteNonQuery();
// "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();
}
}
_dataServices.Add(CreateOracleDataService($"{ConnectionStringOracleDataSource};User Id={_tmpUserNameOracle};Password={_tmpUserNameOracle};"));
}
}
}
}
/// <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);
}