psql.core — net.clojars.savya/psql-clj 2.0.1

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]})

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 env)

Keywordize an environment-style map. With no argument, reads (System/getenv). Accepts any map-like input so callers can pass a plain map in tests.

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 a database spec for PostgreSQL. Uses PG* environment variables by default and accepts overrides in the form: (spec :dbname ... :host ... :port ... :user ... :password ...)

The password is resolved with libpq-style precedence: an explicit :password option, then the PGPASSWORD environment variable, then a ~/.pgpass match.

tables clj

(tables db)

Return the set of table names (as keywords) visible in the database DB.

xml clj

(xml s)

Make PostgreSQL XML object