haskelldb-users

[Haskelldb-users] Wrapping / Escaping Identifiers

[Guenther S. <gue...@we...>]

Hi all,

in my SQLite backend there are some unfortunately chosen Table and Field 
names like: some-table, some-column.

This requires the generated SQL to wrap these table names in quotes.

I cannot simple wrap the table and field names in the haskell table 
definition because when the result comes back the result column names 
can't be matched (because of the quotes). How can I make the 
SQLGenerator wrap the table and field names?

Günther

Re: [Haskelldb-users] Wrapping / Escaping Identifiers

[Justin B. <jgb...@gm...>]

Unfortunately I don't think you can do it w/o writing your own pretty
printer (in Database.HaskellDB.Sql.Print) and your own version of
query (from Database.HaskellDB) to use your pretty-printer.

On Tue, Apr 7, 2009 at 11:04 AM, Guenther Schmidt <gue...@we...> wrote:
> Hi all,
>
> in my SQLite backend there are some unfortunately chosen Table and Field
> names like: some-table, some-column.
>
> This requires the generated SQL to wrap these table names in quotes.
>
> I cannot simple wrap the table and field names in the haskell table
> definition because when the result comes back the result column names
> can't be matched (because of the quotes). How can I make the
> SQLGenerator wrap the table and field names?
>
> Günther
>
>
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by:
> High Quality Requirements in a Collaborative Environment.
> Download a free trial of Rational Requirements Composer Now!
> http://p.sf.net/sfu/www-ibm-com
> _______________________________________________
> Haskelldb-users mailing list
> Has...@li...
> https://lists.sourceforge.net/lists/listinfo/haskelldb-users
>