[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