public async Task TestUpdateDataWithJsonAsync()
{
await _spannerFixture.RunWithTemporaryDatabaseAsync(async databaseId =>
{
await _spannerFixture.CreateVenuesTableAndInsertDataAsync(databaseId);
AddJsonColumnAsyncSample addColumnSample = new AddJsonColumnAsyncSample();
await addColumnSample.AddJsonColumnAsync(_spannerFixture.ProjectId, _spannerFixture.InstanceId, databaseId);
var updateJsonSample = new UpdateDataWithJsonAsyncSample();
await updateJsonSample.UpdateDataWithJsonAsync(_spannerFixture.ProjectId, _spannerFixture.InstanceId, databaseId);
});
}
public async Task TestQueryDataWithJsonParameterAsync()
{
await _spannerFixture.RunWithTemporaryDatabaseAsync(async databaseId =>
{
await _spannerFixture.CreateVenuesTableAndInsertDataAsync(databaseId);
AddJsonColumnAsyncSample addColumnSample = new AddJsonColumnAsyncSample();
await addColumnSample.AddJsonColumnAsync(_spannerFixture.ProjectId, _spannerFixture.InstanceId, databaseId);
var updateJsonSample = new UpdateDataWithJsonAsyncSample();
await updateJsonSample.UpdateDataWithJsonAsync(_spannerFixture.ProjectId, _spannerFixture.InstanceId, databaseId);
var queryJsonSample = new QueryDataWithJsonParameterAsyncSample();
var venues = await queryJsonSample.QueryDataWithJsonParameterAsync(_spannerFixture.ProjectId, _spannerFixture.InstanceId, databaseId);
Assert.Contains(venues, v => v.VenueId == 19);
});
}
