public async Task <IEnumerable <ApiResource> > FetchAllApiResourcesAsync()
{
var sql = $"SELECT* FROM c";
var apiResources = (await _apiResourceGrantCosmosStore.QueryMultipleAsync(sql));
var query = from item in apiResources
select item.ToModel();
return(query);
}
public async Task <IEnumerable <PersistedGrant> > GetAllAsync(string subjectId)
{
Guard.ForNull(subjectId, nameof(subjectId));
var sql = $"SELECT* FROM c where c.SubjectId = \"{subjectId}\"";
var persistedGrants = (await _persistedGrantCosmosStore.QueryMultipleAsync(sql)).ToList();
var model = persistedGrants.Select(x => x.ToModel());
_logger.LogDebug($"{persistedGrants.Count} persisted grants found for {subjectId}");
return(model);
}
public async Task <IEnumerable <IdentityResource> > FindIdentityResourcesByScopeAsync(IEnumerable <string> scopeNames)
{
/*
* SELECT DISTINCT VALUE c FROM c
* WHERE ARRAY_CONTAINS(["1d2e3da2-76e3-4a58-99d2-c2c04bdeaf4d/a", "strawberries", "bananas"],c.name,false)
*
*/
const string sqlTemplate = "SELECT DISTINCT VALUE c FROM c WHERE ARRAY_CONTAINS([{0}],c.name,false)";
var query = from item in scopeNames
let c = $"'{item}'"
select c;
var sql = string.Format(sqlTemplate, string.Join(',', query));
var result = await _identityResourceGrantCosmosStore.QueryMultipleAsync(sql);
var q2 = from item in result
select item.ToModel();
return(q2);
}
public Task <IEnumerable <Device> > GetAll()
{
return(_deviceStore.QueryMultipleAsync("SELECT * FROM c"));
}