// Only 1 public constructor is allowed for test fixture.
internal SqlDataStoreTestsFixture(string databaseName)
{
EnsureArg.IsNotNullOrEmpty(databaseName, nameof(databaseName));
_databaseName = databaseName;
string initialConnectionString = Environment.GetEnvironmentVariable("SqlServer:ConnectionString") ?? LocalConnectionString;
_masterConnectionString = new SqlConnectionStringBuilder(initialConnectionString)
{
InitialCatalog = "master"
}.ToString();
TestConnectionString = new SqlConnectionStringBuilder(initialConnectionString)
{
InitialCatalog = _databaseName
}.ToString();
var config = new SqlServerDataStoreConfiguration
{
ConnectionString = TestConnectionString,
Initialize = true,
SchemaOptions = new SqlServerSchemaOptions
{
AutomaticUpdatesEnabled = true,
},
};
var scriptProvider = new ScriptProvider <SchemaVersion>();
var baseScriptProvider = new BaseScriptProvider();
var mediator = Substitute.For <IMediator>();
var sqlConnectionStringProvider = new DefaultSqlConnectionStringProvider(config);
var sqlConnectionFactory = new DefaultSqlConnectionFactory(sqlConnectionStringProvider);
var schemaManagerDataStore = new SchemaManagerDataStore(sqlConnectionFactory);
var schemaUpgradeRunner = new SchemaUpgradeRunner(scriptProvider, baseScriptProvider, NullLogger <SchemaUpgradeRunner> .Instance, sqlConnectionFactory, schemaManagerDataStore);
var schemaInformation = new SchemaInformation(SchemaVersionConstants.Min, SchemaVersionConstants.Max);
_schemaInitializer = new SchemaInitializer(config, schemaUpgradeRunner, schemaInformation, sqlConnectionFactory, sqlConnectionStringProvider, mediator, NullLogger <SchemaInitializer> .Instance);
SqlTransactionHandler = new SqlTransactionHandler();
SqlConnectionWrapperFactory = new SqlConnectionWrapperFactory(SqlTransactionHandler, new SqlCommandWrapperFactory(), sqlConnectionFactory);
SqlIndexDataStoreFactory = new SqlIndexDataStoreFactory(
schemaInformation,
new[] { new SqlIndexDataStoreV1(SqlConnectionWrapperFactory), new SqlIndexDataStoreV2(SqlConnectionWrapperFactory) });
InstanceStore = new SqlInstanceStore(SqlConnectionWrapperFactory);
ExtendedQueryTagStore = new SqlExtendedQueryTagStore(SqlConnectionWrapperFactory, schemaInformation, NullLogger <SqlExtendedQueryTagStore> .Instance);
TestHelper = new SqlIndexDataStoreTestHelper(TestConnectionString);
}
public SqlDataStoreTestsFixture()
{
string initialConnectionString = Environment.GetEnvironmentVariable("SqlServer:ConnectionString") ?? LocalConnectionString;
_databaseName = $"DICOMINTEGRATIONTEST_{DateTimeOffset.UtcNow.ToUnixTimeSeconds()}_{BigInteger.Abs(new BigInteger(Guid.NewGuid().ToByteArray()))}";
_masterConnectionString = new SqlConnectionStringBuilder(initialConnectionString)
{
InitialCatalog = "master"
}.ToString();
TestConnectionString = new SqlConnectionStringBuilder(initialConnectionString)
{
InitialCatalog = _databaseName
}.ToString();
var config = new SqlServerDataStoreConfiguration
{
ConnectionString = TestConnectionString,
Initialize = true,
SchemaOptions = new SqlServerSchemaOptions
{
AutomaticUpdatesEnabled = true,
},
};
var scriptProvider = new ScriptProvider <SchemaVersion>();
var baseScriptProvider = new BaseScriptProvider();
var mediator = Substitute.For <IMediator>();
var sqlConnectionStringProvider = new DefaultSqlConnectionStringProvider(config);
var sqlConnectionFactory = new DefaultSqlConnectionFactory(sqlConnectionStringProvider);
var schemaManagerDataStore = new SchemaManagerDataStore(sqlConnectionFactory);
var schemaUpgradeRunner = new SchemaUpgradeRunner(scriptProvider, baseScriptProvider, mediator, NullLogger <SchemaUpgradeRunner> .Instance, sqlConnectionFactory, schemaManagerDataStore);
var schemaInformation = new SchemaInformation((int)SchemaVersion.V1, (int)SchemaVersion.V1);
_schemaInitializer = new SchemaInitializer(config, schemaUpgradeRunner, schemaInformation, sqlConnectionFactory, sqlConnectionStringProvider, NullLogger <SchemaInitializer> .Instance);
var dicomSqlIndexSchema = new SqlIndexSchema(schemaInformation, NullLogger <SqlIndexSchema> .Instance);
SqlTransactionHandler = new SqlTransactionHandler();
SqlConnectionWrapperFactory = new SqlConnectionWrapperFactory(SqlTransactionHandler, new SqlCommandWrapperFactory(), sqlConnectionFactory);
IndexDataStore = new SqlIndexDataStore(
dicomSqlIndexSchema,
SqlConnectionWrapperFactory);
InstanceStore = new SqlInstanceStore(SqlConnectionWrapperFactory);
TestHelper = new SqlIndexDataStoreTestHelper(TestConnectionString);
}
public static IEnumerable <OrchestrationState> GetInstancesByState(this SqlInstanceStore instanceStore, OrchestrationStatus status)
{
List <OrchestrationState> instances = new List <OrchestrationState>();
var byNameQuery = new OrchestrationStateQuery();
byNameQuery.AddStatusFilter(status);
return(instanceStore.QueryOrchestrationStatesAsync(byNameQuery).Result);
}
public static ServiceHost CreateMicroserviceHost(string serviceBusConnectionString, string storageConnectionString, string hubName,
bool recreateHubAndStore, out List <OrchestrationState> runningInstances, ILoggerFactory loggerFactory = null)
{
IOrchestrationServiceInstanceStore instanceStore;
//
// Try to determine if ConnectionString is SQL or TableStorage
if (storageConnectionString.ToLower().Contains("server="))
{
instanceStore = new SqlInstanceStore(hubName, storageConnectionString);
}
else
{
instanceStore = new AzureTableInstanceStore(hubName, storageConnectionString);
}
ServiceBusOrchestrationService orchestrationServiceAndClient =
new ServiceBusOrchestrationService(serviceBusConnectionString, hubName, instanceStore, null, null);
ServiceHost host;
host = new ServiceHost(orchestrationServiceAndClient, orchestrationServiceAndClient, instanceStore, recreateHubAndStore, loggerFactory);
try
{
//if (purgeStore)
//{
// instanceStore.InitializeStoreAsync(false).Wait();
// instanceStore.PurgeOrchestrationHistoryEventsAsync(DateTime.Now.AddYears(1), OrchestrationStateTimeRangeFilterType.OrchestrationCreatedTimeFilter).Wait();
//}
// Not available on interface yet.
if (instanceStore is AzureTableInstanceStore)
{
runningInstances = ((AzureTableInstanceStore)instanceStore).GetRunningInstances();
}
else
{
runningInstances = ((SqlInstanceStore)instanceStore).GetRunningInstances();
}
}
catch (Exception)
{
runningInstances = new List <OrchestrationState>();
// This will fail if the store is not created already
}
return(host);
}
public static List <OrchestrationState> GetRunningInstances(this SqlInstanceStore instanceStore)
{
List <OrchestrationState> instances = new List <OrchestrationState>();
var byNameQuery = new OrchestrationStateQuery();
byNameQuery.AddStatusFilter(OrchestrationStatus.Running);
instances.AddRange(GetInstancesByState(instanceStore, OrchestrationStatus.Running));
// instances.AddRange(GetInstancesByState(instanceStore, OrchestrationStatus.ContinuedAsNew));
instances.AddRange(GetInstancesByState(instanceStore, OrchestrationStatus.Pending));
return(instances);
}
public static IOrchestrationServiceInstanceStore CreateInstanceStore(string hubName, string storageConnectionString, bool purgeStore = false)
{
IOrchestrationServiceInstanceStore instanceStore;
if (storageConnectionString.ToLower().Contains("server="))
{
instanceStore = new SqlInstanceStore(hubName, storageConnectionString);
}
else
{
instanceStore = new AzureTableInstanceStore(hubName, storageConnectionString);
}
if (purgeStore)
{
instanceStore.InitializeStoreAsync(false).Wait();
instanceStore.PurgeOrchestrationHistoryEventsAsync(DateTime.Now.AddYears(-1), OrchestrationStateTimeRangeFilterType.OrchestrationCreatedTimeFilter).Wait();
}
return(instanceStore);
}
public static ServiceClient CreateMicroserviceClient(string serviceBusConnectionString, string storageConnectionString, string hubName, ILogger logger = null)
{
IOrchestrationServiceInstanceStore instanceStore;
if (storageConnectionString.ToLower().Contains("server="))
{
instanceStore = new SqlInstanceStore(hubName, storageConnectionString);
}
else
{
instanceStore = new AzureTableInstanceStore(hubName, storageConnectionString);
}
ServiceBusOrchestrationService orchestrationServiceAndClient =
new ServiceBusOrchestrationService(serviceBusConnectionString, hubName, instanceStore, null, null);
ServiceClient client;
client = new ServiceClient(orchestrationServiceAndClient);
return(client);
}
internal SqlDataStoreTestsFixture(string databaseName, SchemaInformation schemaInformation)
{
DatabaseName = EnsureArg.IsNotNullOrEmpty(databaseName, nameof(databaseName));
SchemaInformation = EnsureArg.IsNotNull(schemaInformation, nameof(schemaInformation));
IConfiguration environment = new ConfigurationBuilder()
.AddEnvironmentVariables()
.Build();
string initialConnectionString = environment["SqlServer:ConnectionString"] ?? LocalConnectionString;
_masterConnectionString = new SqlConnectionStringBuilder(initialConnectionString)
{
InitialCatalog = "master"
}.ToString();
TestConnectionString = new SqlConnectionStringBuilder(initialConnectionString)
{
InitialCatalog = DatabaseName
}.ToString();
var config = new SqlServerDataStoreConfiguration
{
ConnectionString = TestConnectionString,
Initialize = true,
SchemaOptions = new SqlServerSchemaOptions
{
AutomaticUpdatesEnabled = true,
},
};
IOptions <SqlServerDataStoreConfiguration> configOptions = Options.Create(config);
var scriptProvider = new ScriptProvider <SchemaVersion>();
var baseScriptProvider = new BaseScriptProvider();
var mediator = Substitute.For <IMediator>();
var sqlConnectionStringProvider = new DefaultSqlConnectionStringProvider(configOptions);
var sqlConnectionFactory = new DefaultSqlConnectionFactory(sqlConnectionStringProvider);
var schemaManagerDataStore = new SchemaManagerDataStore(sqlConnectionFactory, configOptions, NullLogger <SchemaManagerDataStore> .Instance);
SchemaUpgradeRunner = new SchemaUpgradeRunner(scriptProvider, baseScriptProvider, NullLogger <SchemaUpgradeRunner> .Instance, sqlConnectionFactory, schemaManagerDataStore);
_schemaInitializer = new SchemaInitializer(configOptions, schemaManagerDataStore, SchemaUpgradeRunner, SchemaInformation, sqlConnectionFactory, sqlConnectionStringProvider, mediator, NullLogger <SchemaInitializer> .Instance);
SqlTransactionHandler = new SqlTransactionHandler();
SqlConnectionWrapperFactory = new SqlConnectionWrapperFactory(SqlTransactionHandler, new SqlCommandWrapperFactory(), sqlConnectionFactory);
var schemaResolver = new PassthroughSchemaVersionResolver(SchemaInformation);
IndexDataStore = new SqlIndexDataStore(new VersionedCache <ISqlIndexDataStore>(
schemaResolver,
new[]
{
new SqlIndexDataStoreV1(SqlConnectionWrapperFactory),
new SqlIndexDataStoreV2(SqlConnectionWrapperFactory),
new SqlIndexDataStoreV3(SqlConnectionWrapperFactory),
new SqlIndexDataStoreV4(SqlConnectionWrapperFactory),
new SqlIndexDataStoreV5(SqlConnectionWrapperFactory),
new SqlIndexDataStoreV6(SqlConnectionWrapperFactory),
}));
InstanceStore = new SqlInstanceStore(new VersionedCache <ISqlInstanceStore>(
schemaResolver,
new[]
{
new SqlInstanceStoreV1(SqlConnectionWrapperFactory),
new SqlInstanceStoreV4(SqlConnectionWrapperFactory),
new SqlInstanceStoreV6(SqlConnectionWrapperFactory),
}));
PartitionStore = new SqlPartitionStore(new VersionedCache <ISqlPartitionStore>(
schemaResolver,
new[]
{
new SqlPartitionStoreV6(SqlConnectionWrapperFactory),
}));
ExtendedQueryTagStore = new SqlExtendedQueryTagStore(new VersionedCache <ISqlExtendedQueryTagStore>(
schemaResolver,
new[]
{
new SqlExtendedQueryTagStoreV1(),
new SqlExtendedQueryTagStoreV2(SqlConnectionWrapperFactory, NullLogger <SqlExtendedQueryTagStoreV2> .Instance),
new SqlExtendedQueryTagStoreV4(SqlConnectionWrapperFactory, NullLogger <SqlExtendedQueryTagStoreV4> .Instance),
new SqlExtendedQueryTagStoreV8(SqlConnectionWrapperFactory, NullLogger <SqlExtendedQueryTagStoreV8> .Instance),
}));
ExtendedQueryTagErrorStore = new SqlExtendedQueryTagErrorStore(new VersionedCache <ISqlExtendedQueryTagErrorStore>(
schemaResolver,
new[]
{
new SqlExtendedQueryTagErrorStoreV1(),
new SqlExtendedQueryTagErrorStoreV4(SqlConnectionWrapperFactory, NullLogger <SqlExtendedQueryTagErrorStoreV4> .Instance),
new SqlExtendedQueryTagErrorStoreV6(SqlConnectionWrapperFactory, NullLogger <SqlExtendedQueryTagErrorStoreV6> .Instance),
}));
IndexDataStoreTestHelper = new SqlIndexDataStoreTestHelper(TestConnectionString);
ExtendedQueryTagStoreTestHelper = new ExtendedQueryTagStoreTestHelper(TestConnectionString);
ExtendedQueryTagErrorStoreTestHelper = new ExtendedQueryTagErrorStoreTestHelper(TestConnectionString);
}