in Amazon.QLDB.DMVSample.LedgerSetup/SampleData.cs [110:137]
private async Task InsertDriversLicenses(List<string> peopleDocumentIds)
{
List<DriversLicense> licenses = new List<DriversLicense>
{
new DriversLicense { LicenseNumber = "LEWISR261LL", LicenseType = "Learner",
ValidFromDate = DateTime.Parse("2016-12-20"), ValidToDate = DateTime.Parse("2020-11-15") },
new DriversLicense { LicenseNumber = "LOGANB486CG", LicenseType = "Probationary",
ValidFromDate = DateTime.Parse("2016-04-06"), ValidToDate = DateTime.Parse("2020-11-15") },
new DriversLicense { LicenseNumber = "744 849 301", LicenseType = "Full",
ValidFromDate = DateTime.Parse("2017-12-06"), ValidToDate = DateTime.Parse("2022-10-15") },
new DriversLicense { LicenseNumber = "P626-168-229-765", LicenseType = "Learner",
ValidFromDate = DateTime.Parse("2017-08-16"), ValidToDate = DateTime.Parse("2021-11-15") },
new DriversLicense { LicenseNumber = "S152-780-97-415-0", LicenseType = "Probationary",
ValidFromDate = DateTime.Parse("2015-08-15"), ValidToDate = DateTime.Parse("2021-08-21") }
};
for (int i = 0; i < peopleDocumentIds.Count; i++)
{
licenses[i].PersonId = peopleDocumentIds[i];
}
Console.WriteLine("Inserting driver's license data");
await qldbDriver.Execute(async transactionExecutor =>
{
await Insert(transactionExecutor, "DriversLicense", licenses);
});
Console.WriteLine("Driver's license data inserted");
}