paneer.core documentation

add-column
macro
(add-column command & columns)
Internally used by alter macro

Source
add-column*
(add-column* command & col-options)
Adds a column as part of a ALTER TABLE Command

Source
alter
macro
(alter form)(alter _ tbl-name _ new-name)(alter _ tbl-name [action & args])
Nice wrapper for altering tables. Allows you to write:
(alter
  (table :users :rename-to :lusers))

(alter
  (table :users 
         (add-column (varchar :api-key 255 :not-null))))

(alter 
  (table :users 
          (rename (column :email)
                  (to :shpemail))))

(alter
  (table :users
          (drop-column :email)))
Source
alter*
(alter* & opts)
Starts an ALTER TABLE command

Source
bigint
(bigint command col-name & options)
Creates a bigint column

Source
boolean
(boolean command col-name & options)
Creates a boolean column

Source
column
(column command col-name & [col-type & options])
Adds a column to a command map

Source
create
macro
(create [_ tbl-name & columns])
Allows you to wrap a table definition together as in
(create
  (table :users
         (serial :id :primary-key)
         (varchar :name 255)
         (varchar :email 255)))
then automatically executes it against the current default database.
Source
create*
(create* & opts)
Starts a CREATE TABLE command

Source
create-if-not-exists
macro
(create-if-not-exists [_ tbl-name & columns])
Allows you to wrap a table definitions together as in the create macro, but
includes IF NOT EXISTS in the generated SQL
Source
double
(double command col-name & options)
Creates a double precision column

Source
drop
macro
(drop [_ tbl-name])
Nice wrapper for dropping tables allows you to write:
(drop
  (table :users))
then automatically executes it against the current default database. 
Source
drop*
(drop* & opts)
Starts a DROP TABLE command

Source
drop-column
macro
(drop-column command column-name)
Internally used by alter macro

Source
drop-column*
(drop-column* command col-name)
Specifies column to drop in ALTER TABLE command

Source
drop-if-exists
macro
(drop-if-exists [_ tbl-name])
Nice wrapper for dropping table as in the drop macro

Source
execute
(execute command)
Execute command with the default connection

Source
float
(float command col-name & options)
Creates a Float Column

Source
integer
(integer command col-name & options)
Creates an Integer Column

Source
refer-to
(refer-to command table & [type])
Creates a reference column

Source
rename
macro
(rename command column [_ new-name])
Internally used by alter macro

Source
rename-column-to*
(rename-column-to* command col-name)
Renames a column as part of ALTER TABLE command

Source
rename-to*
(rename-to* command new-table)
Renames table as part of ALTER TABLE command

Source
serial
(serial command col-name & options)
Creates a serial column

Source
sql-string
(sql-string command)
Produces an sql string from command map

Source
table*
(table* command table-name)
Modifyes a command map to include table name

Source
text
(text command col-name & options)
Creates a text column

Source
timestamp
(timestamp command col-name & options)
Creates a timestamp column

Source
varchar
(varchar command col-name length & options)
Creates a Varchar Column

Source
with-connection
(with-connection command conn)
Executes a query with a given connection

Source