private string GetUserBaseUriFromFilter(string filterpredicate) { var uri = GetPropertyFromFilter(filterpredicate, "UserProfileUri"); uri = DataProviderHelper.GetWebIdRootURL(uri); return(uri); }
protected override void DoDelete(VisitedPlaceDataObject entity, LambdaExpression securityFilterExpression, IObjectsDataSet context, Dictionary <string, object> parameters) { var userUri = DataProviderHelper.GetWebIdRootURL(entity.UserProfileUri); string visitedPlaceDocumentName = "myvisitedplaces.ttl"; string visitedPlaceDocumentUri = $"{userUri}/public/{visitedPlaceDocumentName}"; StringBuilder sb; string payload = ""; if (!entity.IsNew) { // existing entity => we need to delete existing entry, before inserting modified one var existingEntity = DoGet(entity, securityFilterExpression, null, context, parameters); sb = new StringBuilder(); sb.AppendLine($":{entity.Id} "); sb.AppendLine($" a <http://generativeobjects.com/apps#VisitedPlace> ;"); sb.AppendLine($" <http://schema.org/startDate> \"{existingEntity.Date.ToString("yyyy-MM-dd")}\" ;"); sb.AppendLine($" <http://schema.org/description> \"\"\"{existingEntity.Description}\"\"\" ; "); sb.AppendLine($" <http://generativeobjects.com/apps#VisitedPlaceType> \"{existingEntity.Typeofplace.ToString()}\" ; "); if (existingEntity.Typeofplace == PlaceTypesEnum.Country && entity.CountryURI != null) { sb.AppendLine($" <http://dbpedia.org/class/yago/WikicatMemberStatesOfTheUnitedNations> <{existingEntity.CountryURI}> . "); } else { sb.AppendLine($" <http://dbpedia.org/ontology/Place> <{existingEntity.PlaceURI}> . "); } payload += $"DELETE DATA {{{sb.ToString()}}} "; } var token = DataProviderHelper.GetSolidToken(); var statusPatch = DataProviderHelper.SendPatch(visitedPlaceDocumentUri, payload, token); if (statusPatch != HttpStatusCode.OK) { throw new GOServerException("Failed to delete the visited place information"); } }
protected override UserProfileDataObject DoGet(UserProfileDataObject entity, LambdaExpression securityFilterExpression, List <string> includes, IObjectsDataSet context, Dictionary <string, object> parameters) { var userProfileUri = entity.Uri; var result = new UserProfileDataObject(); result.Uri = entity.Uri; var dataset = ApplicationSettings.Container.Resolve <IObjectsDataSet>(); dataset.AddObject(result); string tempfile = null; try { tempfile = DataProviderHelper.DownloadFile(userProfileUri, ".ttl"); var g = new Graph(); g.LoadFromFile(tempfile); //UriLoader.Load(g, new Uri(userProfileUri)); // NOT WORKING ... ??? SOMEHOW SHOULD WORK var query = @"SELECT * WHERE { ?me a <http://xmlns.com/foaf/0.1/Person> . OPTIONAL { ?me <http://www.w3.org/2006/vcard/ns#fn> ?Name . } OPTIONAL { ?me <http://www.w3.org/2006/vcard/ns#organization-name> ?OrganizationName . } OPTIONAL { ?me <http://www.w3.org/2006/vcard/ns#role> ?Role . } }"; var returned = ((SparqlResultSet)g.ExecuteQuery(query)).SingleOrDefault(); if (returned == null) { return(null); } result.Role = returned.HasValue("Role") ? returned["Role"].ToString() : null; result.OrganizationName = returned.HasValue("OrganizationName") ? returned["OrganizationName"].ToString() : null; result.Name = returned.HasValue("Name") ? returned["Name"].ToString() : null; result.IsNew = false; result.IsDirty = false; return(result); } finally { if (File.Exists(tempfile)) { File.Delete(tempfile); } } }
protected override int DoCount(LambdaExpression securityFilterExpression, string filterPredicate, object[] filterArguments, IObjectsDataSet context, Dictionary <string, object> parameters) { var userUri = GetUserBaseUriFromFilter(filterPredicate); if (userUri == null) { // search all the users registered in application var userNames = DataFacade.GOUserDataProvider.GetCollection(null).Select(u => u.UserName); int count = 0; foreach (var userName in userNames) { try { var userfilter = $"UserProfileUri == \"{userName}\" && {filterPredicate}"; count += DoCount(securityFilterExpression, userfilter, filterArguments, context, parameters); } catch (Exception e) { } } return(count); } string visitedPlaceDocumentName = "myvisitedplaces.ttl"; string visitedPlaceDocumentUri = $"{userUri}/public/{visitedPlaceDocumentName}"; string tempfile = null; var placeUriFilter = GetPropertyFromFilter(filterPredicate, "PlaceURI"); var countryUriFilter = GetPropertyFromFilter(filterPredicate, "CountryURI"); try { tempfile = DataProviderHelper.DownloadFile(visitedPlaceDocumentUri, ".ttl"); var g = new Graph(); g.LoadFromFile(tempfile); //UriLoader.Load(g, new Uri(visitedPlaceDocumentUri)); // NOT WORKING ... ??? SOMEHOW SHOULD WORK var query = new SparqlParameterizedString(); query.Namespaces.AddNamespace("go", new Uri("http://generativeobjects.com/apps#")); query.Namespaces.AddNamespace("schem", new Uri("http://schema.org")); if (placeUriFilter == null && countryUriFilter == null) { query.CommandText = @"SELECT count(?visitedplace) AS ?count WHERE { ?visitedplace a go:VisitedPlace } "; } else if (placeUriFilter != null) { query.CommandText = @"SELECT count(?visitedplace) AS ?count WHERE { ?visitedplace a go:VisitedPlace ; <http://dbpedia.org/ontology/Place> @PlaceUri . } "; query.SetUri("@PlaceUri", new Uri(placeUriFilter)); } else { query.CommandText = @"SELECT count(?visitedplace) AS ?count WHERE { ?visitedplace a go:VisitedPlace ; <http://dbpedia.org/class/yago/WikicatMemberStatesOfTheUnitedNations> @CountryURI . } "; query.SetUri("@CountryURI", new Uri(countryUriFilter)); } var results = (SparqlResultSet)g.ExecuteQuery(query); var res = results.Single(); var count = Convert.ToInt32((res.Single().Value as BaseLiteralNode).Value); return(count); } finally { if (File.Exists(tempfile)) { File.Delete(tempfile); } } }
protected override DataObjectCollection <VisitedPlaceDataObject> DoGetCollection(LambdaExpression securityFilterExpression, string filterPredicate, object[] filterArguments, string orderByPredicate, int pageNumber, int pageSize, List <string> includes, IObjectsDataSet context, Dictionary <string, object> parameters) { var userUri = GetUserBaseUriFromFilter(filterPredicate); if (userUri == null) { // search all the users registered in application var userNames = DataFacade.GOUserDataProvider.GetCollection(null).Select(u => u.UserName); var toReturn = new DataObjectCollection <VisitedPlaceDataObject>(); toReturn.ObjectsDataSet = ApplicationSettings.Container.Resolve <IObjectsDataSet>(); foreach (var userName in userNames) { try { var userfilter = $"UserProfileUri == \"{userName}\" && {filterPredicate}"; var subvisitedplaces = DoGetCollection(securityFilterExpression, userfilter, filterArguments, orderByPredicate, 0, 0, includes, context, parameters); foreach (var subvisitedplace in subvisitedplaces) { toReturn.Add(subvisitedplace); } } catch (Exception e) { } } return(toReturn); } string visitedPlaceDocumentName = "myvisitedplaces.ttl"; string visitedPlaceDocumentUri = $"{userUri}/public/{visitedPlaceDocumentName}"; string tempfile = null; var placeUriFilter = GetPropertyFromFilter(filterPredicate, "PlaceURI"); var countryUriFilter = GetPropertyFromFilter(filterPredicate, "CountryURI"); try { tempfile = DataProviderHelper.DownloadFile(visitedPlaceDocumentUri, ".ttl"); var g = new Graph(); g.LoadFromFile(tempfile); //UriLoader.Load(g, new Uri(visitedPlaceDocumentUri)); // NOT WORKING ... ??? SOMEHOW SHOULD WORK var query = new SparqlParameterizedString(); if (placeUriFilter == null && countryUriFilter == null) { query.CommandText = @"SELECT * WHERE { ?VisitedPlace a <http://generativeobjects.com/apps#VisitedPlace> ; <http://schema.org/startDate> ?Date; <http://schema.org/description> ?Description . OPTIONAL { ?VisitedPlace <http://generativeobjects.com/apps#VisitedPlaceType> ?PlaceOrCountry . } OPTIONAL { ?VisitedPlace <http://dbpedia.org/ontology/Place> ?PlaceURI . } OPTIONAL { ?VisitedPlace <http://dbpedia.org/class/yago/WikicatMemberStatesOfTheUnitedNations> ?CountryURI . } } "; ////<http://dbpedia.org/class/yago/WikicatMemberStatesOfTheUnitedNations> ?CountryURI ; if (pageNumber != 0 || pageSize != 0) { query.CommandText += $"LIMIT {pageSize} OFFSET {(pageNumber - 1) * pageSize}"; } } else if (placeUriFilter != null) { query.CommandText = @"SELECT * WHERE { ?VisitedPlace a <http://generativeobjects.com/apps#VisitedPlace> ; <http://dbpedia.org/ontology/Place> @PlaceUri ; <http://schema.org/startDate> ?Date; <http://schema.org/description> ?Description . OPTIONAL { ?VisitedPlace <http://generativeobjects.com/apps#VisitedPlaceType> ?PlaceOrCountry . } } "; query.SetUri("@PlaceUri", new Uri(placeUriFilter)); } else { query.CommandText = @"SELECT * WHERE { ?VisitedPlace a <http://generativeobjects.com/apps#VisitedPlace> ; <http://dbpedia.org/class/yago/WikicatMemberStatesOfTheUnitedNations> @CountryURI ; <http://schema.org/startDate> ?Date; <http://schema.org/description> ?Description . OPTIONAL { ?VisitedPlace <http://generativeobjects.com/apps#VisitedPlaceType> ?PlaceOrCountry . } } "; query.SetUri("@CountryURI", new Uri(countryUriFilter)); } var results = (SparqlResultSet)g.ExecuteQuery(query); var toReturn = new DataObjectCollection <VisitedPlaceDataObject>(); toReturn.ObjectsDataSet = ApplicationSettings.Container.Resolve <IObjectsDataSet>(); foreach (var result in results) { var visitedPlace = MapSparqlResultToVisitedPlace(result); visitedPlace.UserProfileUri = GetPropertyFromFilter(filterPredicate, "UserProfileUri"); toReturn.Add(visitedPlace); } return(toReturn); } finally { if (File.Exists(tempfile)) { File.Delete(tempfile); } } }
protected override VisitedPlaceDataObject DoGet(VisitedPlaceDataObject entity, LambdaExpression securityFilterExpression, List <string> includes, IObjectsDataSet context, Dictionary <string, object> parameters) { var userUri = DataProviderHelper.GetWebIdRootURL(entity.UserProfileUri); string visitedPlaceDocumentName = "myvisitedplaces.ttl"; string visitedPlacesDocumentUri = $"{userUri}/public/{visitedPlaceDocumentName}"; //string visitedPlaceUri = $"{visitedPlacesDocumentUri}#{entity.Id}"; // to be used with UriLoader.Load string tempfile = null; try { tempfile = DataProviderHelper.DownloadFile(visitedPlacesDocumentUri, ".ttl"); var g = new Graph(); g.LoadFromFile(tempfile); //UriLoader.Load(g, new Uri(visitedPlaceDocumentUri)); // NOT WORKING ... ??? SOMEHOW SHOULD WORK var query = new SparqlParameterizedString(); query.CommandText = @"SELECT * WHERE { @VisitedPlace <http://schema.org/startDate> ?Date ; <http://schema.org/description> ?Description. OPTIONAL { @VisitedPlace <http://generativeobjects.com/apps#VisitedPlaceType> ?PlaceOrCountry . } OPTIONAL { @VisitedPlace <http://dbpedia.org/ontology/Place> ?PlaceURI . } OPTIONAL { @VisitedPlace <http://dbpedia.org/class/yago/WikicatMemberStatesOfTheUnitedNations> ?CountryURI . } }"; // <http://dbpedia.org/class/yago/WikicatMemberStatesOfTheUnitedNations> ?CountryURI ; string visitedPlaceLocalFileUri = $"file://////{tempfile}#{entity.Id}"; query.SetUri("VisitedPlace", new Uri(visitedPlaceLocalFileUri)); var results = (SparqlResultSet)g.ExecuteQuery(query); var result = results.SingleOrDefault(); if (result == null) { throw new GOServerException("Cannot load the VisitedPlace"); } var visitedPlace = MapSparqlResultToVisitedPlace(result, mapId: false); visitedPlace.Id = entity.Id; visitedPlace.UserProfileUri = entity.UserProfileUri; var dataset = ApplicationSettings.Container.Resolve <IObjectsDataSet>(); dataset.AddObject(visitedPlace); return(visitedPlace); } finally { if (File.Exists(tempfile)) { File.Delete(tempfile); } } }
public static void EnsurePublicTypeRegistration(string userUri, string registrationName, string registrationType, string registrationLocation) { // going too fast to publicTypeIndex. should follow this : https://github.com/solid/solid/blob/master/proposals/data-discovery.md var publicTypeIndexUri = $"{userUri}/settings/publicTypeIndex.ttl"; var g = new Graph(); UriLoader.Load(g, new Uri(publicTypeIndexUri)); var query = new SparqlParameterizedString(); query.Namespaces.AddNamespace("s", new Uri("http://www.w3.org/ns/solid/terms#")); query.Namespaces.AddNamespace("schem", new Uri("http://schema.org")); // ?reg < http://www.w3.org/ns/solid/terms#forClass> <http://schema.org/TextDigitalDocument>. // ?reg < http://www.w3.org/ns/solid/terms#instance> <file:///C:/public/visitedplaces.ttl>. query.CommandText = @"SELECT ?reg WHERE { ?reg s:forClass @type . ?reg s:instance @location . }"; // file:///C:/public/notes.ttl => the URI contains file:///C: because it is made relative to where the document is, and here we downloaded it to local file ... query.SetUri("location", new Uri($"file:///C:/public/{registrationLocation}")); query.SetUri("type", new Uri(registrationType)); var registrationExists = ((SparqlResultSet)g.ExecuteQuery(query)).Any(); var token = GetSolidToken(); if (!registrationExists) { // create the type registration string payload = $"INSERT DATA {{:{registrationName} a <http://www.w3.org/ns/solid/terms#TypeRegistration>; <http://www.w3.org/ns/solid/terms#forClass> <http://schema.org/TextDigitalDocument> ; <http://www.w3.org/ns/solid/terms#instance> </public/{registrationLocation}> . }}"; var statusPatch = DataProviderHelper.SendPatch(publicTypeIndexUri, payload, token); if (statusPatch != HttpStatusCode.OK) { throw new GOServerException("PATCH Failed"); } } var documentUri = $"{userUri}/public/{registrationLocation}"; // verify the document exists var status = DataProviderHelper.SendHead(documentUri, token); if (status != HttpStatusCode.OK) { // create the document file otherwise /* string payload = @"@prefix : <#>. * @prefix schem: <http://schema.org/>. * @prefix XML: <http://www.w3.org/2001/XMLSchema#>. * @prefix go: <http://generativeobjects.com/apps#>."; */ status = DataProviderHelper.SendPost($"{userUri}/public/", registrationLocation, null, token); if (status != HttpStatusCode.OK) { throw new GOServerException("POST Failed"); } } }