Hi Toni,
No, there isn't any way of doing this beside d2rq:uriSqlExpression. Column
functions have to be bijective (inputs map to outputs one to one), and lower
casing isn't.
D2RQ doesn't try to be an abstract layer that hides different SQL dialects.
Trying to make the same mapping work on different engines is not a good idea,
in my opinion. Doing that seriously limits what you can do in a mapping.
You could have two variants of the mapping, one for testing and one for
production. Perhaps both can be generated from a single source mapping file
(e.g., with SPARQL CONSTRUCT that removes a few statements) as both will be
very similar.
Best,
Richard
> On 24 Apr 2014, at 11:48, Toni Cebrián <toni.cebr...@softonic.com> wrote:
>
> Hi,
>
> I’d like to convert some fields in the DB to lower case
> before creating the URI because that way URIs will have a unified format. I’m
> looking to something similar to @@Table.field|encode@@ but for lower casing
> results or doing other transformations. I could do this by using
> d2rq:uriSqlExpression but then it breaks my integration tests running SQlite
> because the CONCAT function from MySQL is not supported in the SQLite
> database.
> Is there a “native” D2RQ way of doing this lower casing when
> creating URIs? And more generally, some string manipulation basic numeric
> manipulation?
>
> Best regards
> Toni.
>
> Toni Cebrián
> Data Scientist
> toni.cebr...@softonic.com
> <image001.png>
> http://www.softonic.com
> Edificio Meridian C/ Rosselló i Porcel, 21, planta 17 - 08016 Barcelona
> (SPAIN)
> Tel+34 936 012 700 Fax+34 933 969 292
> Ranked #1 European company in global online audience
>
> <image002.gif>
> Este mensaje y los documentos que, en su caso, lleve anexos, pueden contener
> información confidencial. Por ello, se informa a quien lo reciba por error
> que la información contenida en el mismo es reservada y su uso no autorizado
> está prohibido legalmente, por lo que en tal caso le rogamos que nos lo
> comunique por la misma vía o por teléfono, se abstenga de realizar copias o
> remitirlo o entregarlo a terceras personas y proceda a borrarlo de inmediato.
>
> ------------------------------------------------------------------------------
> Start Your Social Network Today - Download eXo Platform
> Build your Enterprise Intranet with eXo Platform Software
> Java Based Open Source Intranet - Social, Extensible, Cloud Ready
> Get Started Now And Turn Your Intranet Into A Collaboration Platform
> http://p.sf.net/sfu/ExoPlatform
> _______________________________________________
> d2rq-map-devel mailing list
> d2rq-map-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
------------------------------------------------------------------------------
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
_______________________________________________
d2rq-map-devel mailing list
d2rq-map-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
