/// <summary>
/// Retrieves comments for a particular database view.
/// </summary>
/// <param name="viewName">The name of a database view.</param>
/// <param name="cancellationToken">The cancellation token.</param>
/// <returns>An <see cref="T:LanguageExt.OptionAsync`1" /> instance which holds the value of the view's comments, if available.</returns>
/// <exception cref="ArgumentNullException"><paramref name="viewName"/> is <c>null</c>.</exception>
public OptionAsync <IDatabaseViewComments> GetViewComments(Identifier viewName, CancellationToken cancellationToken = default)
{
if (viewName == null)
{
throw new ArgumentNullException(nameof(viewName));
}
return(QueryViewCommentProvider.GetViewComments(viewName, cancellationToken)
| MaterializedViewCommentProvider.GetViewComments(viewName, cancellationToken));
}
/// <summary>
/// Retrieves all database view comments defined within a database.
/// </summary>
/// <param name="cancellationToken">The cancellation token.</param>
/// <returns>A collection of view comments.</returns>
public async IAsyncEnumerable <IDatabaseViewComments> GetAllViewComments([EnumeratorCancellation] CancellationToken cancellationToken = default)
{
var queryViewsTask = QueryViewCommentProvider.GetAllViewComments(cancellationToken).ToListAsync(cancellationToken).AsTask();
var materializedViewsTask = MaterializedViewCommentProvider.GetAllViewComments(cancellationToken).ToListAsync(cancellationToken).AsTask();
await Task.WhenAll(queryViewsTask, materializedViewsTask).ConfigureAwait(false);
var queryViews = await queryViewsTask.ConfigureAwait(false);
var materializedViews = await materializedViewsTask.ConfigureAwait(false);
var viewComments = queryViews
.Concat(materializedViews)
.OrderBy(v => v.ViewName.Schema)
.ThenBy(v => v.ViewName.LocalName);
foreach (var comment in viewComments)
{
yield return(comment);
}
}
