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);
}
}
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);
}
}
public void Can_run_sequences_performance()
{
var repository = GetRepository();
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.False(GlobalNumbers.ContainsKey(result));
GlobalNumbers.Add(result, result);
/* don't need second checks here
* 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.Equal(1, sqlResult);
*/
}
}