public async Task TestAddNumericColumn()
{
await _spannerFixture.CreateVenuesTableAndInsertDataAsync();
AddNumericColumnAsyncSample addColumnSample = new AddNumericColumnAsyncSample();
await addColumnSample.AddNumericColumnAsync(_spannerFixture.ProjectId, _spannerFixture.InstanceId, _spannerFixture.DatabaseId);
await _spannerFixture.DeleteVenuesTable();
}
public async Task TestAddNumericColumnAsync()
{
var databaseId = $"my-db-{DateTimeOffset.UtcNow.ToUnixTimeMilliseconds()}";
CreateDatabaseAsyncSample sample = new CreateDatabaseAsyncSample();
await sample.CreateDatabaseAsync(_spannerFixture.ProjectId, _spannerFixture.InstanceId, databaseId);
await _spannerFixture.CreateVenuesTableAndInsertDataAsync(databaseId);
AddNumericColumnAsyncSample addNumericColumnAsyncSample = new AddNumericColumnAsyncSample();
await addNumericColumnAsyncSample.AddNumericColumnAsync(_spannerFixture.ProjectId, _spannerFixture.InstanceId, databaseId);
}
public async Task TestQueryDataWithNumericParameter()
{
await _spannerFixture.CreateVenuesTableAndInsertDataAsync();
AddNumericColumnAsyncSample addColumnSample = new AddNumericColumnAsyncSample();
await addColumnSample.AddNumericColumnAsync(_spannerFixture.ProjectId, _spannerFixture.InstanceId, _spannerFixture.DatabaseId);
UpdateDataWithNumericAsyncSample updateNumericSample = new UpdateDataWithNumericAsyncSample();
await updateNumericSample.UpdateDataWithNumericAsync(_spannerFixture.ProjectId, _spannerFixture.InstanceId, _spannerFixture.DatabaseId);
QueryDataWithNumericParameterAsyncSample queryNumericSample = new QueryDataWithNumericParameterAsyncSample();
var venues = await queryNumericSample.QueryDataWithNumericParameterAsync(_spannerFixture.ProjectId, _spannerFixture.InstanceId, _spannerFixture.DatabaseId);
Assert.Contains(venues, v => v.VenueId == 4);
await _spannerFixture.DeleteVenuesTable();
}