public static Task DropPrimaryIndexAsync(this IQueryIndexManager queryIndexManager, string bucketName, Action <DropPrimaryQueryIndexOptions> configureOptions)
{
var options = new DropPrimaryQueryIndexOptions();
configureOptions(options);
return(queryIndexManager.DropPrimaryIndexAsync(bucketName, options));
}
public static string CreateDropPrimaryIndexStatement(string bucketName, DropPrimaryQueryIndexOptions options)
{
if (options.ScopeNameValue == null)
{
return $"DROP PRIMARY INDEX ON {bucketName.EscapeIfRequired()} USING GSI;";
}
return $"DROP PRIMARY INDEX ON {bucketName.EscapeIfRequired()}.{options.ScopeNameValue.EscapeIfRequired()}.{options.CollectionNameValue.EscapeIfRequired()} USING GSI;";
}
public async Task DropPrimaryIndexAsync(string bucketName, DropPrimaryQueryIndexOptions options)
{
Logger.LogInformation($"Attempting to drop primary query index on bucket {bucketName}");
try
{
var statement = $"DROP PRIMARY INDEX ON {bucketName} USING GSI;";
await _queryClient.QueryAsync <dynamic>(statement,
queryOptions => queryOptions.WithCancellationToken(options.CancellationToken)
);
}
catch (Exception exception)
{
Logger.LogError(exception, $"Error trying to drop query index on {bucketName}");
throw;
}
}
