// For test/dev purposes only - read and print uploaded data
private async Task TestReadSubcasesAsync(DocumentClient documentClient)
{
var cosmosDataProvider = new CosmosDataProvider(documentClient, _loggerFactory.CreateLogger("CosmosDataProvider"));
var products = await cosmosDataProvider.GetProductsAsync();
foreach (var product in products)
{
_logger.LogInformation($"Read product {product}");
var subcases = await cosmosDataProvider.GetSubcasesAsync(product);
foreach (var subcase in subcases)
{
_logger.LogInformation($"Subcase {subcase.Id} {subcase.Title}");
}
}
}
static async Task MainAsync()
{
// Setting up file to write to
FileStream ostrm;
StreamWriter writer;
TextWriter oldOut = Console.Out;
try
{
string filename = String.Format("{0:yyyy-MM-dd_hh-mm-ss-tt}_DESC", DateTime.Now);
ostrm = new FileStream($"../../output/{filename}.txt", FileMode.CreateNew, FileAccess.Write);
writer = new StreamWriter(ostrm);
}
catch (Exception e)
{
Console.WriteLine("Cannot create file for writing");
Console.WriteLine(e.Message);
return;
}
Console.SetOut(writer);
var provider = new CosmosDataProvider();
/**
* This is for the DESC query
* We do have null created dates due to data masking agents we run in our apps background.
* Thus why we have to check for null here
*/
var descQuery = "SELECT * from m WHERE m.createdDateTimeUtc != null ORDER BY m.createdDateTimeUtc DESC";
ConsoleShowQueryHeader(descQuery);
string contToken = null;
do
{
var descResp = await provider.ExecuteQueryAsync <object>(
collectionUri.ToString(),
descQuery,
new FeedOptions()
{
EnableCrossPartitionQuery = true,
PopulateQueryMetrics = true,
MaxItemCount = 100,
RequestContinuation = contToken
});
ConsoleShowQueryContToken(contToken);
ConsoleShowQueryRU(descResp.RuCharge);
foreach (KeyValuePair <string, QueryMetrics> kvp in descResp.Metrics)
{
ConsoleShowQueryMetrics(kvp.Key, kvp.Value);
}
contToken = descResp.ContToken;
} while (!string.IsNullOrEmpty(contToken));
Console.SetOut(oldOut);
writer.Close();
ostrm.Close();
try
{
string filename = String.Format("{0:yyyy-MM-dd_hh-mm-ss-tt}_ASC", DateTime.Now);
ostrm = new FileStream($"../../output/{filename}.txt", FileMode.CreateNew, FileAccess.Write);
writer = new StreamWriter(ostrm);
}
catch (Exception e)
{
Console.WriteLine("Cannot create file for writing");
Console.WriteLine(e.Message);
return;
}
Console.SetOut(writer);
/**
* This is for the ASC query
* We do have null created dates due to data masking agents we run in our apps background.
* Thus why we have to check for null here
*/
var ascQuery = "SELECT * from m WHERE m.createdDateTimeUtc != null ORDER BY m.createdDateTimeUtc ASC";
ConsoleShowQueryHeader(ascQuery);
contToken = null;
do
{
var ascResp = await provider.ExecuteQueryAsync <object>(
collectionUri.ToString(),
ascQuery,
new FeedOptions()
{
EnableCrossPartitionQuery = true,
PopulateQueryMetrics = true,
MaxItemCount = 100,
RequestContinuation = contToken
});
ConsoleShowQueryContToken(contToken);
ConsoleShowQueryRU(ascResp.RuCharge);
foreach (KeyValuePair <string, QueryMetrics> kvp in ascResp.Metrics)
{
ConsoleShowQueryMetrics(kvp.Key, kvp.Value);
}
contToken = ascResp.ContToken;
} while (!string.IsNullOrEmpty(contToken));
Console.SetOut(oldOut);
writer.Close();
ostrm.Close();
}
