public override void SetupDatabase()
{
using (var db = new CommerceRepositoryImpl(_connectionStringName, _container.Resolve<AuditableInterceptor>()))
{
var initializer = new SetupDatabaseInitializer<CommerceRepositoryImpl, VirtoCommerce.CoreModule.Data.Migrations.Configuration>();
initializer.InitializeDatabase(db);
}
}
public override void SetupDatabase()
{
using (var db = new CommerceRepositoryImpl("VirtoCommerce"))
{
var initializer = new SetupDatabaseInitializer<CommerceRepositoryImpl, VirtoCommerce.CoreModule.Data.Migrations.Configuration>();
initializer.InitializeDatabase(db);
}
}
public static void Cleanup()
{
const string sql =
@"IF OBJECT_ID('dbo.UniqueSequence', 'U') IS NOT NULL
DROP TABLE [dbo].[UniqueSequence]";
var repository = new CommerceRepositoryImpl("VirtoCommerce");
repository.Database.ExecuteSqlCommand(sql);
}
public static void Initialize(TestContext context)
{
const string sql =
@"IF OBJECT_ID('dbo.UniqueSequence', 'U') IS NULL
CREATE TABLE [dbo].[UniqueSequence]([Sequence] [nvarchar](255) NOT NULL,CONSTRAINT [PK_UniqueSequence] PRIMARY KEY CLUSTERED ([Sequence] ASC)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON))";
var repository = new CommerceRepositoryImpl("VirtoCommerce");
repository.Database.ExecuteSqlCommand(sql);
}
public void SetupDatabase(SampleDataLevel sampleDataLevel)
{
using (var db = new CommerceRepositoryImpl("VirtoCommerce"))
{
IDatabaseInitializer<CommerceRepositoryImpl> initializer;
switch (sampleDataLevel)
{
case SampleDataLevel.Full:
case SampleDataLevel.Reduced:
initializer = new SqlCommerceSampleDatabaseInitializer();
break;
default:
initializer = new SetupDatabaseInitializer<CommerceRepositoryImpl, VirtoCommerce.CoreModule.Data.Migrations.Configuration>();
break;
}
initializer.InitializeDatabase(db);
}
}
public void RunSequencesPerformance()
{
var repository = new CommerceRepositoryImpl("VirtoCommerce");
var sequence = new SequenceUniqueNumberGeneratorServiceImpl(() => repository);
for (var i = 1; i < SequenceUniqueNumberGeneratorServiceImpl.SequenceReservationRange; i++)
{
var result = sequence.GenerateNumber("CO{0:yyMMdd}-{1:D5}");
Debug.WriteLine(result);
//This would fail if any duplicate generated
Assert.IsFalse(GlobalNumbers.ContainsKey(result));
GlobalNumbers.Add(result, result);
const string sql = "INSERT UniqueSequence VALUES(@p0);";
//This would fail if any duplicate generated beause we use primary key
var sqlResult = repository.Database.ExecuteSqlCommand(sql, result);
Assert.AreEqual(1, sqlResult);
}
}
private static IСommerceRepository GetCommerceRepository()
{
var result = new CommerceRepositoryImpl("VirtoCommerce", new EntityPrimaryKeyGeneratorInterceptor(), new AuditableInterceptor());
return result;
}
