public override void SetUp()
{
base.SetUp();
var config = new RelationalStoreConfiguration(ConnectionString);
config.DocumentMaps.Register(new BigObjectMap(Format));
store = new RelationalStore(config);
readTransaction = store.BeginReadTransaction();
using var writer = store.BeginWriteTransaction();
var rand = new Random(42);
var randomString = new Func <string>(() =>
{
var buffer = new byte[3];
rand.NextBytes(buffer);
return(Convert.ToBase64String(buffer));
});
var historyEntries = Enumerable.Range(1, DocumentSize / 256).Select(n => new BigObjectHistoryEntry
{
Id = Guid.NewGuid(), Comment = randomString(), LuckyNumbers = Enumerable.Range(0, rand.Next(130, 330)).ToArray(), Date = DateTime.Today.AddDays(n)
});
writer.Insert(new BigObject {
Id = "BigObject-1", History = historyEntries.OfType <object>().ToList()
});
writer.Commit();
}
int GetNextMaxValue()
{
using (var transaction = store.BeginWriteTransaction(IsolationLevel.Serializable))
{
var parameters = new CommandParameterValues
{
{ "collectionName", collectionName },
{ "blockSize", blockSize }
};
parameters.CommandType = CommandType.StoredProcedure;
var result = transaction.ExecuteScalar <int>("GetNextKeyBlock", parameters);
transaction.Commit();
return(result);
}
}
public override void SetUp()
{
base.SetUp();
var config = new RelationalStoreConfiguration(ConnectionString);
config.DocumentMaps.Register(new BigObjectMap(JsonStorageFormat.TextOnly));
store = new RelationalStore(config);
readTransaction = store.BeginReadTransaction();
using var writer = store.BeginWriteTransaction();
var history = GenerateHistory();
var doc1 = history.Take(1).ToList();
var doc10 = history.Take(10).ToList();
var doc100 = history.Take(100).ToList();
var doc500 = history.Take(500).ToList();
var rand = new Random(42);
for (var i = 0; i < 1000; i++)
{
var doc = new BigObject {
Name = "Document " + i
};
var distribution = rand.Next(1, 100);
if (distribution < 70)
{
doc.History = doc1;
}
else if (distribution < 85)
{
doc.History = doc10;
}
else if (distribution < 95)
{
doc.History = doc100;
}
else if (distribution <= 100)
{
doc.History = doc500;
}
writer.Insert(doc, new InsertOptions {
CommandTimeout = TimeSpan.FromSeconds(180)
});
if (i % 100 == 0)
{
Console.WriteLine($"Inserted: {i} history: {doc.History.Count} rand: {distribution}");
}
}
foreach (var item in writer.Stream <(long?Bucket, int?Count)>(
"select len([JSON]) as Bucket, count(*) from BigObject group by len([JSON]) order by len([JSON])"))
{
Console.WriteLine($"{item.Bucket} bytes: {item.Count} documents");
}
writer.Commit();
}