korma.db — sql.dsl/korma 0.4.2

Functions for creating and managing database specifications.

*current-conn* clj

*current-db* clj

_default clj

c3p0-enabled? clj

connection-pool clj

(connection-pool {:keys [connection-uri subprotocol subname classname
                         excess-timeout idle-timeout initial-pool-size
                         minimum-pool-size maximum-pool-size
                         test-connection-query idle-connection-test-period
                         test-connection-on-checkin test-connection-on-checkout]
                  :or {maximum-pool-size 15
                       idle-timeout (* 3 60 60)
                       excess-timeout (* 30 60)
                       idle-connection-test-period 0
                       test-connection-query nil
                       test-connection-on-checkin false
                       test-connection-on-checkout false
                       initial-pool-size 3
                       minimum-pool-size 3}
                  :as spec})

Create a connection pool for the given database spec.

create-db clj

(create-db spec)

Create a db connection object manually instead of using defdb. This is often useful for creating connections dynamically, and probably should be followed up with:

(default-connection my-new-conn)

If the spec includes :make-pool? true makes a connection pool from the spec.

default-connection clj

(default-connection conn)

Set the database connection that Korma should use by default when no alternative is specified.

defdb clj macro

(defdb db-name spec)

Define a database specification. The last evaluated defdb will be used by default for all queries where no database is specified by the entity.

delay-pool clj

(delay-pool spec)

Return a delay for creating a connection pool for the given spec.

do-query clj

(do-query {:keys [db] :as query})

extract-options clj

(extract-options {:keys [naming delimiters alias-delimiter]})

firebird clj

(firebird
  {:keys [host port db] :or {host "localhost" port 3050 db ""} :as opts})

Create a database specification for a FirebirdSQL database. Opts should include keys for :db, :user, :password. You can also optionally set host, port and make-pool?

get-connection clj

(get-connection db)

Get a connection from the potentially delayed connection object.

h2 clj

(h2 {:keys [db] :or {db "h2.db"} :as opts})

Create a database specification for a h2 database. Opts should include a key for :db which is the path to the database file.

is-rollback? clj

(is-rollback?)

Returns true if the current transaction will be rolled back

msaccess clj

(msaccess {:keys [db] :or {db ""} :as opts})

Create a database specification for a Microsoft Access database. Opts should include keys for :db and optionally :make-pool?.

mssql clj

(mssql {:keys [user password db host port]
        :or
          {user "dbuser" password "dbpassword" db "" host "localhost" port 1433}
        :as opts})

Create a database specification for a mssql database. Opts should include keys for :db, :user, and :password. You can also optionally set host and port.

mysql clj

(mysql {:keys [host port db] :or {host "localhost" port 3306 db ""} :as opts})

Create a database specification for a mysql database. Opts should include keys for :db, :user, and :password. You can also optionally set host and port. Delimiters are automatically set to "`".

odbc clj

(odbc {:keys [dsn] :or {dsn ""} :as opts})

Create a database specification for an ODBC DSN. Opts should include keys for :dsn and optionally :make-pool?.

oracle clj

(oracle {:keys [host port] :or {host "localhost" port 1521} :as opts})

Create a database specification for an Oracle database. Opts should include keys for :user and :password. You can also optionally set host and port.

postgres clj

(postgres
  {:keys [host port db] :or {host "localhost" port 5432 db ""} :as opts})

Create a database specification for a postgres database. Opts should include keys for :db, :user, and :password. You can also optionally set host and port.

resolve-new clj macro

(resolve-new class)

rollback clj

(rollback)

Tell this current transaction to rollback.

sqlite3 clj

(sqlite3 {:keys [db] :or {db "sqlite.db"} :as opts})

Create a database specification for a SQLite3 database. Opts should include a key for :db which is the path to the database file.

transaction clj macro

(transaction body)

(transaction options & body)

Execute all queries within the body in a single transaction. Optionally takes as a first argument a map to specify the :isolation and :read-only? properties of the transaction.

vertica clj

(vertica {:keys [host port db] :or {host "localhost" port 5433 db ""} :as opts})

Create a database specification for a vertica database. Opts should include keys for :db, :user, and :password. You can also optionally set host and port. Delimiters are automatically set to "`".

with-db clj macro

(with-db db & body)

Execute all queries within the body using the given db spec