More info; The mapping below is working perfectly. To me it sounds like a
problem with uriSqlExpression,what do you think?
map:documentAuthor1 a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:Document;
d2rq:property :documentAuthor;
d2rq:refersToClassMap map:User1;
d2rq:condition "users.universal_id is not null";
d2rq:join "documents.responsible = users.user_id";
.
map:documentAuthor2 a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:Document;
d2rq:property :documentAuthor;
d2rq:refersToClassMap map:User2;
d2rq:condition "users.universal_id is null";
d2rq:join "documents.responsible = users.user_id";
.
map:User1 a d2rq:ClassMap;
d2rq:dataStorage map:Database;
d2rq:class :User;
d2rq:condition "users.universal_id is not null";
d2rq:uriPattern "
http://www.cipe.accamargo.org.br/ontologias/h2tc.owl#usersUNIV@@users.universal_id@@
";
.
map:User2 a d2rq:ClassMap;
d2rq:dataStorage map:Database;
d2rq:class :User;
d2rq:condition "users.universal_id is null";
d2rq:uriPattern "
http://www.cipe.accamargo.org.br/ontologias/h2tc.owl#usersEHR@@users.user_id@@
";
.
--
diogo patrão
On Thu, Apr 11, 2013 at 9:40 AM, Diogo FC Patrao <djogopat...@gmail.com>wrote:
> Hi Richard
>
> Did another couple of tests and the problem is not really related to
> SERVICE.
>
> This time, I issued the following query directly to D2R-Server:
>
> SELECT * WHERE { ?document <
> http://www.cipe.accamargo.org.br/ontologias/h2tc.owl#documentAuthor>
> ?author . } limit 5
>
> The results for ?author are still hex-coded. However, take a look on
> map:documentAuthor:
>
> map:documentAuthor a d2rq:PropertyBridge;
> d2rq:belongsToClassMap map:Document;
> d2rq:property :documentAuthor;
> #d2rq:refersToClassMap map:User;
> d2rq:join "documents.responsible = users.user_id";
> d2rq:uriSqlExpression "CONCAT('
> http://www.cipe.accamargo.org.br/ontologias/h2tc.owl#users',if(
> users.universal_id is null, concat('EHR',users.user_id),
> concat('UNIV',users.universal_id) ) )";
> .
>
> Does this point to something?
>
> thanks!
>
>
>
>
> --
> diogo patrão
>
>
>
>
> On Wed, Apr 10, 2013 at 1:33 PM, Richard Cyganiak <rich...@cyganiak.de>wrote:
>
>> --debug should print the query that ARQ sent. Run that query yourself in
>> D2RQ. And I'm pretty sure it's either Joseki or ARQ messing up the result,
>> and both are Jena products :-)
>>
>> Richard
>>
>>
>> On 10 Apr 2013, at 14:12, Diogo FC Patrao <djogopat...@gmail.com> wrote:
>>
>> BTW2, how can I be sure that those results are coming out of D2R or are
>> being messed up by ARQ client? I turned on --debug on my d2r-server,
>> however it won print results.
>>
>> Thanks again
>>
>> --
>> diogo patrão
>>
>>
>>
>>
>> On Wed, Apr 10, 2013 at 10:10 AM, Diogo FC Patrao
>> <djogopat...@gmail.com>wrote:
>>
>>> Hi Richard
>>>
>>> I'm writing to them right now. Are you in that list too?
>>>
>>> BTW, Arq is in 2.10.1 version right now; do you think D2R 0.8.1 would
>>> work with that version?
>>>
>>> Thanks
>>>
>>> --
>>> diogo patrão
>>>
>>>
>>>
>>>
>>> On Wed, Apr 10, 2013 at 3:18 AM, Richard Cyganiak
>>> <rich...@cyganiak.de>wrote:
>>>
>>>> Off the top of my head I can't think of a reason why this might be
>>>> happening. I suggest you also try asking on the Jena list, mentioning that
>>>> the D2R endpoint uses the Joseki server code.
>>>>
>>>> Richard
>>>>
>>>>
>>>> On 9 Apr 2013, at 21:59, Diogo FC Patrao <djogopat...@gmail.com> wrote:
>>>>
>>>> Hello
>>>>
>>>> I noticed a strange effect happening when I issue the following query:
>>>>
>>>> SELECT DISTINCT *
>>>> WHERE
>>>> {
>>>> SERVICE <http://0.0.0.0:2020/sparql> { ?document
>>>> <http://www.cipe.accamargo.org.br/ontologias/h2tc.owl#documentType>
>>>> "exam request" . }
>>>> SERVICE <http://0.0.0.0:2020/sparql> { ?document
>>>> <http://www.cipe.accamargo.org.br/ontologias/h2tc.owl#documentAuthor>
>>>> ?author . }
>>>> }
>>>> 0.0.0.0:2020/sparql points to a d2r-server instance. This query was
>>>> issued not directly to this instance, but rather by a command line ARQ
>>>> over an empty graph.
>>>>
>>>> This query is part of a bigger query that refers to several d2r-server
>>>> instances, and I know that I could join both of them in one SERVICE only
>>>> for optimization, but that's not the point.
>>>>
>>>> The point is, instead of getting proper URIs for ?author, I'm getting
>>>> those huge hex data, like
>>>>
>>>>
>>>> <687474703A2F2F7777772E636970652E616363616D6172676F2E6F72672E62722F6F6E746F6C6F676961732F683274632E6F776C237573657273554E495636363837353234353636>
>>>>
>>>> Interestingly enough, converting consecutive pairs of those bytes to
>>>> chars, it turns into a URI!
>>>>
>>>> http://www.cipe.accamargo.org.br/ontologias/h2tc.owl#usersUNIV6687524566
>>>>
>>>> Which is a valid answer to ?author.
>>>>
>>>> I have verified that a query without those SERVICE keywords works
>>>> perfectly, when issued directly to D2R-server.
>>>>
>>>>
>>>> I'm not really sure whose fault is this, ARQ or D2R.
>>>>
>>>> Any help in order to get things straight will be appreciated.
>>>>
>>>> Thanks,
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> diogo patrão
>>>>
>>>>
>>>>
>>>> ------------------------------------------------------------------------------
>>>> Precog is a next-generation analytics platform capable of advanced
>>>> analytics on semi-structured data. The platform includes APIs for
>>>> building
>>>> apps and a phenomenal toolset for data science. Developers can use
>>>> our toolset for easy data analysis & visualization. Get a free account!
>>>> http://www2.precog.com/precogplatform/slashdotnewsletter
>>>>
>>>> _______________________________________________
>>>> d2rq-map-devel mailing list
>>>> d2rq-map-devel@lists.sourceforge.net
>>>> https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
>>>>
>>>>
>>>
>>
>
------------------------------------------------------------------------------
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
_______________________________________________
d2rq-map-devel mailing list
d2rq-map-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
