clj-postgresql.core — clj-postgresql 0.7.0

Allow using PostgreSQL from Clojure as effortlessly as possible by reading connection parameter defaults from PostgreSQL environment variables PGDATABASE, PGHOST, PGPORT, PGUSER and by reading password from ~/.pgpass if available.

box clj

(box obj)

(box p1 p2)

(box x1 y1 x2 y2)

Create a PGbox object

circle clj

(circle obj)

(circle center-point r)

(circle x y r)

Create a PGcircle object

close! clj

(close! {:keys [datasource] :as db-spec})

Close db-spec if possible. Return true if the datasource was closeable and closed.

default-spec clj

(default-spec)

Reasonable defaults as with the psql command line tool. Use username for user and db. Don't use host.

env-spec clj

(env-spec {:keys [PGDATABASE PGHOST PGPORT PGUSER] :as env})

Get db spec by reading PG* variables from the environment.

getenv->map clj

(getenv->map)

(getenv->map x)

Convert crazy non-map thingy which comes from (System/getenv) into a keywordized map. If no argument given, fetch env with (System/getenv).

interval clj

(interval &
          {:keys [years months days hours minutes seconds]
           :or {years 0 months 0 days 0 hours 0 minutes 0 seconds 0.0}})

Create a PGinterval. (pg/interval :hours 2)

line clj

(line obj)

(line p1 p2)

(line x1 y1 x2 y2)

Create a PGline object

lseg clj

(lseg obj)

(lseg p1 p2)

(lseg x1 y1 x2 y2)

Create a PGlseg object

money clj

(money amount)

Create PGmoney object

object clj

(object type value)

Make a custom PGobject, e.g. (pg/object "json" "{}")

path clj

(path obj)

(path points open?)

Create a PGpath object

point clj

(point obj)

(point x y)

Create a PGpoint object

polygon clj

(polygon points-or-str)

Create a PGpolygon object

pool clj

(pool & rest)

spec clj

(spec & {:keys [password] :as opts})

Create database spec for PostgreSQL. Uses PG* environment variables by default and acceps options in the form: (pg-spec :dbname ... :host ... :port ... :user ... :password ...)

tables clj

(tables db)

xml clj

(xml s)

Make PostgreSQL XML object