Quote column names when generating SQL about webpy HOT 5 CLOSED

I don't think I want to make quoting columns as default option. It makes the generated queries ugly. One way to support it is to set a flag to enable quoting columns.

db.quoting_columns = True

or have a web.config setting.

I'm willing to support this if someone sends a patch. Any takers?

from webpy.

i think its idiot to make it work like that, not only is it to support a bad programming practice, cause it would allow for reserved words to be used, it could also bit developers in the ass years from now who needs to migrate the data-sets to another database environment. Making webpy forgive this "error", would not be preferred by me.

ps. sorry for digging up a issue 2 years ago, just wanted to put in my 2 cents ;-)

from webpy.

Actually, it causes error in mysql 5.5, . A syntax error is raised by mysql when INSERT is made without quoting the column names.

from webpy.

Isn't it fixed yet? Coz i didn't find any fix in web.db code =( Anyway, to be able to use db.insert i use some unpleasant 'hack':

    db.insert('tablename',**{'"field1"':'value1','"field2"':'value2'})

from webpy.

Do you guys still have this issue? I personally didn't experience this issue at all with the latest web.py-0.39.

Please try web.py-0.39 first, if still not work, please share some code snippet to help reproduce this issue.

from webpy.