psql.core — net.clojars.savya/psql-clj 2.1.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 PGTARGETSESSIONATTRS]
           :as env})

Get a db spec from libpq PG* environment variables, translated to pgjdbc property names where needed. PGHOSTADDR, PGCLIENTENCODING, PGREQUIREPEER, PGSSLCRL/SNI/min-max-proto, and the Unix-socket default host are unsupported.

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 service env] :as opts})

Create a PostgreSQL database spec with libpq-style layering: explicit options override a :service/PGSERVICE definition, which overrides ordinary PG* environment values, which override built-in defaults. Accepts overrides: (spec :dbname ... :host ... :port ... :user ... :password ...)

Password precedence follows the same layers, then falls back to ~/.pgpass. Pass :env with a plain environment map for deterministic use in tests.

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