vellum-postmodern

# vellum-postmodern

This system adds a basic support for constructing vellum tables from the queries to the postgres database. S-SQL syntax is supported.

Example
``` common-lisp
(vellum:copy-from :postmodern
`(:select 'primary_dgns_cd 'anchip_icd10d_codes
          'pac1 'readm_90_days 'death_in_postdisch
          'history_d_10
      :from 'lds2019
      :inner-join 'first_pacs
      :on (:= (:type 'lds2019.episode_id varchar)
               'first_pacs.episode_id)
      :where (:and (:= 'mdc ,mdc)
                   (:not 'death_in_anchor)))
 :columns '(primary-dgns-cd anchip-icd10d-codes pac1 readm-90-days death-in-postdisch history-d-10))
```

Prepare statements are also supported.

``` common-lisp
(postmodern:with-connection *connection-parameters*
  (cl-postgres:prepare-query postmodern:*database* "test" "select * from test;")
  (vellum:copy-from :postmodern "test" :columns '(id name) :prepared t))
```

You can also pass arguments to the prepared statement with :parameters option.



alexandria

cl-postgres

documentation-utils-extensions

iterate

postmodern

serapeum

s-sql

vellum

Postgres support for Vellum Data Frames (via postmodern).

vellum-postmodern

Upstream URL

License

vellum-postmodern

Version:

License:

Authors:

Dependencies:

Dependencies (0)

Dependents (0)