Allow korma to specify extra parameters to defdb

[mprokopov]

I faced to following issue with local timezone using mysql
http://stackoverflow.com/questions/26515700/mysql-jdbc-driver-5-1-33-time-zone-issue

And I did some workaround for that:

(def db-params (mysql {:host "localhost"
                      :db "itservice"
                      :user "root"}))

(def extra-params {:useLegacyDatetimeCode false
               :serverTimezone "UTC"
               :useSSL false})

(def subparams (->> (map (fn [[k v]] (str (name k) "=" v)) extra-params)
                (clojure.string/join "&")
                (str "?")))
(def new-params (update db-params :subname #(str % subparams)))
(defdb my-db new-params)

so params string should look something like "//localhost:3306/itservice?useLegacyDatetimeCode=false&serverTimezone=UTC&useSSL=false", and there is no support for such extra parameters for db-params.

[ls4f]

Will mysql accept those extra parameters as properties (instead of URL params)? Korma does pass on any extra keys you might've set to the data source.

[mprokopov]

I've created pull request for proper support of extra parameters.

#374

[ls4f]

While I'm not a maintainer, if the functionality is needed (some drivers might indeed require options be set via the URL), it seems better to handle it in defdb and make it work for any and all possible databases.

[venantius]

I've commented on your PR, but I appreciate that both it and this issue are quite old.

Is this still a priority issue?

If there hasn't been a response to this issue in 2 weeks, I'll close the ticket.

[Janderio]

I had the same problem (timezone) until configure the server correct, the parameters would be great addition if possible to work even if you can't access the servers config.