public async Task TestAddJsonColumnAsync() { await _spannerFixture.RunWithTemporaryDatabaseAsync(async databaseId => { await _spannerFixture.CreateVenuesTableAndInsertDataAsync(databaseId); AddJsonColumnAsyncSample addColumnSample = new AddJsonColumnAsyncSample(); await addColumnSample.AddJsonColumnAsync(_spannerFixture.ProjectId, _spannerFixture.InstanceId, databaseId); }); }
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 _spannerFixture.Retryable.Eventually(async() => 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); }); }