MySQL and quoting

[jartur]

There is an issue with MySQL which is more on MySQL side but still. The thing is that MySQL doesn't by default use double quotes to quote field names. It uses backtiks. And double quotes are reserved for string literals. So, basically out of the box Korma doesn't work with MySQL. There is a workaround which is to run (exec-raw "set sql_mode='ANSI_QUOTES'") before executing any queries. But I'm not sure if this will work with multiple connections from pool, unless one would run the aforementioned query before executing any other query. Also it may be possible to change this in MySQL config but that is not always an option. So, what I would like to see is an ability to set quoting character in Korma itself. And maybe even predefined quoting characters for different database types.

[ibdknox]

(korma.core/set-delimiters "`") should do the trick :)

0.3.0-alpha2 has the change.

[jartur]

Thanks for such short reaction time.

[gberenfield]

I think this is an issue again with 0.3.0-alpha5. The delimiter atom is changed but doesn't seem to be picked up in the actual delimit-str call (using korma.config/set-delimiters).

[ibdknox]

Are you setting it before you define you do (defdb)? If so, just move it after and it should work (I'll make that smarter). A much better, and brand new, solution is to do it as part of your defdb:

(defdb prod (mysql {:db "blah" :user "blah" :password "hey" :delimiters "`"}))

[gberenfield]

That did it, ty :)