rdfapi-php-interest

[Rdfapi-php-interest] ORDER BY dateTime Problem in RAP0.9.5?

[Tom H. <tom...@gm...>]

Hi all,

I'm experimenting with RAP V0.9.5 before rolling it out. First
impressions are that the SparqlEngine is much much faster, which is
great. However, I've hit a problem, and I don't know if it's a bug or
me just being stupid. Any help much appreciated.

I have this SPARQL query:

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX rev: <http://purl.org/stuff/rev#>
SELECT DISTINCT ?review ?title ?reviewer ?createdOn
WHERE
{
  ?resource rdfs:label ?title .
  ?resource rev:hasReview ?review .
  ?review rev:createdOn ?createdOn .
  ?review rev:reviewer ?reviewer .
}
ORDER BY DESC(?createdOn)
LIMIT 10

to get the 10 latest reviews from the triplestore, ordered by
?createdOn, the values for which are of datatype
<http://www.w3.org/2001/XMLSchema#dateTime> in the triplestore. This
query worked ok in 0.9.4, but fails in 0.9.5 with the following error:

Fatal error: Uncaught exception 'Exception' with message 'Unsupported
cast type in order by: http://www.w3.org/2001/XMLSchema#dateTime' in
C:\htdocs\revyu\rdfapi-php\api\sparql\SparqlEngineDb\TypeSorter.php:389
Stack trace: #0
C:\htdocs\revyu\rdfapi-php\api\sparql\SparqlEngineDb\TypeSorter.php(365):
SparqlEngineDb_TypeSorter::getCastMethod('http://www.w3.o...',
't2.object') #1
C:\htdocs\revyu\rdfapi-php\api\sparql\SparqlEngineDb\TypeSorter.php(118):
SparqlEngineDb_TypeSorter->getSqlOrderBy(Array) #2
C:\htdocs\revyu\rdfapi-php\api\sparql\SparqlEngineDb.php(136):
SparqlEngineDb_TypeSorter->getOrderifiedSqls(Array) #3
C:\htdocs\revyu\rdfapi-php\api\model\Model.php(897):
SparqlEngineDb->queryModel(Object(DatasetMem), Object(Query), false)
#4 C:\htdocs\revyu\....php(38): Model->sparqlQuery('??PREFIX rdfs:
...') #5 C:\htdocs\revyu\index.php(47): include('C:\htdocs\revyu...')
#6 {main} thrown in
C:\htdocs\revyu\rdfapi-php\api\sparql\SparqlEngineDb\TypeSorter.php on
line 389

Any ideas? Pointers/fixes/suggestions much appreciated!

Cheers,

Tom.

Re: [Rdfapi-php-interest] ORDER BY dateTime Problem in RAP0.9.5?

[Christian W. <cw...@cw...>]

Tom,



> great. However, I've hit a problem, and I don't know if it's a bug or
> me just being stupid. Any help much appreciated.
> ORDER BY DESC(?createdOn)
> Fatal error: Uncaught exception 'Exception' with message 'Unsupported
> cast type in order by: http://www.w3.org/2001/XMLSchema#dateTime' in

This is a missing feature. I'll fix it next week.



--=20
Mit freundlichen Gr=FC=DFen/Regards,
Christian Weiske

Re: [Rdfapi-php-interest] ORDER BY dateTime Problem in RAP0.9.5?

[Tom H. <tom...@gm...>]

On 15/06/07, Christian Weiske <cw...@cw...> wrote:
> Tom,
>
> > great. However, I've hit a problem, and I don't know if it's a bug or
> > me just being stupid. Any help much appreciated.
> > ORDER BY DESC(?createdOn)
> > Fatal error: Uncaught exception 'Exception' with message 'Unsupported
> > cast type in order by: http://www.w3.org/2001/XMLSchema#dateTime' in
>
> This is a missing feature. I'll fix it next week.

Brilliant, thanks Christian, look forward to it :)

BTW, I also managed to generate this error doing a DESCRIBE query:

=============

Warning: Invalid argument supplied for foreach() in
C:\htdocs\revyu\rdfapi-php\api\sparql\SparqlEngineDb\SqlGenerator.php
on line 174

Warning: Invalid argument supplied for foreach() in
C:\htdocs\revyu\rdfapi-php\api\sparql\SparqlEngineDb\SqlGenerator.php
on line 212

Fatal error: Uncaught exception 'Exception' with message 'Unsupported
result form: describe' in
C:\htdocs\revyu\rdfapi-php\api\sparql\SparqlEngineDb\ResultRenderer\Default.php:95
Stack trace: #0
C:\htdocs\revyu\rdfapi-php\api\sparql\SparqlEngineDb\ResultConverter.php(61):
SparqlEngineDb_ResultRenderer_Default->convertFromDbResults(Array,
Object(Query), Object(SparqlEngineDb)) #1
C:\htdocs\revyu\rdfapi-php\api\sparql\SparqlEngineDb.php(140):
SparqlEngineDb_ResultConverter::convertFromDbResults(Array,
Object(SparqlEngineDb), false) #2
C:\htdocs\revyu\rdfapi-php\api\model\Model.php(897):
SparqlEngineDb->queryModel(Object(DatasetMem), Object(Query), false)
#3 C:\htdocs\revyu\...(10): Model->sparqlQuery('DESCRIBE <thing...')
#4 C:\htdocs\revyu\...(54): include('C:\htdocs\revyu...') #5 {main}
thrown in C:\htdocs\revyu\rdfapi-php\api\sparql\SparqlEngineDb\ResultRenderer\Default.php
on line 95

=============

Let me know if you need any more info!

Tom.