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; }