[Dbix-class] Issue with sql names

Ash Berlin ash at cpan.org
Thu Dec 7 17:18:07 GMT 2006


Marc Espie wrote:
> On Thu, Dec 07, 2006 at 05:20:36PM +0100, Robert 'phaylon' Sedlacek wrote:
>> Marc Espie wrote:
>>> The requests generated by DBIx::Class do not quote field names by default.
>>> Is there a way to get them quoted ? Even though this generates less readable
>>> SQL, this can be useful in some cases...
>> It's even in the documentation:
>> http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/Manual/Cookbook.pod#Setting_quoting_for_the_generated_SQL.
> 
> Thanks! next question, is there any way to do that automatically ? I come
> from the old DBI, which often knows about the correct quote chars for
> the database... I don't quite understand why this is not automatic ?
> 
> I assume some dbd back-ends might have issues, but in that case, the storage
> could do stuff correctly on at least common db formats, like sqlite or pg... ?
> 

Mainly because no one has got around to writing it yet. Its been on my 
todo list for about two months, more important things keep getting in 
the way.

Ash



More information about the Dbix-class mailing list