Functions for creating JDBC DB specs for a given driver. Only databases that are supported as application DBs should have functions in this namespace; otherwise, similar functions are only needed by drivers, and belong in those namespaces. | (ns metabase.db.spec (:require [clojure.string :as str] [metabase.config :as config])) |
Create a [[clojure.java.jdbc]] spec map from broken-out database | (defmulti spec
{:arglists '([db-type details])}
(fn [db-type _details]
(keyword db-type))) |
(defmethod spec :h2
[_ {:keys [db]
:or {db "h2.db"}
:as opts}]
(merge {:classname "org.h2.Driver"
:subprotocol "h2"
:subname db}
(dissoc opts :db))) | |
Make a subname for the given | (defn make-subname
{:arglists '([host port db]), :added "0.39.0"}
[host port db]
(str "//" (when-not (str/blank? host) (str host ":" port)) (if-not (str/blank? db) (str "/" db) "/"))) |
(defmethod spec :postgres
[_ {:keys [host port db]
:or {host "localhost", port 5432, db ""}
:as opts}]
(merge
{:classname "org.postgresql.Driver"
:subprotocol "postgresql"
:subname (make-subname host (or port 5432) db)
;; I think this is done to prevent conflicts with redshift driver registering itself to handle postgres://
:OpenSourceSubProtocolOverride true
:ApplicationName config/mb-version-and-process-identifier}
(dissoc opts :host :port :db))) | |
(defmethod spec :mysql
[_ {:keys [host port db]
:or {host "localhost", port 3306, db ""}
:as opts}]
(merge
{:classname "org.mariadb.jdbc.Driver"
:subprotocol "mysql"
:subname (make-subname host (or port 3306) db)}
(dissoc opts :host :port :db))) | |
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !! !! !! Don't put database spec functions for new drivers in this namespace. These ones are only here because they !! !! can also be used for the application DB in metabase.driver. Put functions like these for new drivers in the !! !! driver namespace itself. !! !! !! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! | |