Alter table, add column(s) table - keyword or string columns - vector of :keyword, string, vector (name, type) or map (:name, :type) Create table iff not exists. Return - void.

Close a DB handle (SQLiteConnection or Postgres for now, could be changed) Could contain prepared statements and meta-data in the future

Return true iff columns exists in table within db. table - keyword or string column - keyword or string

Return seq of column meta data, for table in db

Return column-name as :keyword for column column - either a string/keyword (then default datatype: string), or seq-of [:name :type] return vector with name and type. Used for internal map with new tables/columns within transaction.

Determine SQL datatype of column within record. Return seq of columnname and SQL-datatype. datatype could be more than one :keyword

Return set of column names (as keywords) in table in database table can be a string or keyword. Look in both DB metadata (with query) as well as newly added tables/columns (in cache)

Create a table table: :keyword or string columns: vector of: :keyword, string, vector (name, type) or map (:name, :type). always include a generated ‘id’ column. Iff an id-field exists in columns, create an ‘id_’ field. return - void.

Return current connection/transaction handle, or the db-spec if none exists. Use for working within transactions.

Mapping of java-class to conversion function wrt sql types JSR310 LocalDate and LocalDateTime are supported, no need for conversion.

Convert a value to a type understood by jdbc/sql. Can also be some JSR 310 types

Convert values in record/map to SQL types

Convert par to a string and surround it with double quotes. With respect to bracketed table and column names for reserved words. This seems to work both in SQLite and Postgres (Postgres does not like brackets)

Convert keys in record/map to string and surround with double quotes. Wrt using reserved words in the table. Maybe only do this for the list of 145 (SQlite) reserved words

Execute a DDL/DML query. Also handle optional params-sequence given.

Return created id of first row of result-set. This is different for SQLite and Postgres

Generate id-column spec for database type, given db handle

Run body expressions in a transaction based on handle. Works in conjunction with set-transaction and current-transaction. Returns result of last expression

Return true if handle is currently within a transaction

Insert record into table, adding table/columns if needed. Default/pessimistic version: first check if table and columns exist and create/alter table where needed; then insert record. Also call db-values on record.

Insert record into table, no checks if table/columns exist. Return generated id.

Insert record into table, adding table/columns if needed. Optimistic version: first try to insert; if fails, add table/column(s) and try again. This version might be faster, need some tests.

Log argument to stdout and return it

Apply f to very val in coll, return result

Apply f to every key in coll, return result

Determine new columns (including types) for table based on record. cols - the current columns of table (seq of keywords) record - the hashmap with needed columns of table (columns als keywords) return - seq of new columns

Deprecated, use open-db-sqlite

Open DB connection given a spec, could be SQLite or Postgresql, maybe others

Open SQLite DB and return handle (SQLiteConnection for now, could be changed. Return connection both directly in map as within returned db-spec within map. db-name - path to DB, existing or new, as string

Perform a SQL (select) query, return sequence of maps. Also handle optional params-sequence given.

Set a function to be executed on each new connection/transaction. Function should accept one parameter, the db handle.

Mark transaction handle given by with-db-transaction in this handle. Also exec init-function on this transaction iff it is set. Keep list of new tables/columns created in this transaction. Also call :init-function when given (eg. for percentile function). Fail if transaction already started

Determine sql type of a value For now only integer, float, string and date-time types for Postgres. Default to varchar if no match. sql-type dependent on db-spec, eg with date/time values. throws an exception if type cannot be determined. (maybe should return varchar in that case)

SQL types for combinations of database and Clojure/Java values Includes defaults per datatype and also per database type.

Convert par to a string and surround it with brackets. Wrt bracketed table and column names for reserved words

Given db-handle and table, returns true iff table exists within DB, false otherwise. Table can be keyword or string.

Return seq of table meta data, but for now without column info

Return sequence of table names (as keywords) in database.

Unmark transaction handle given by with-db-transaction in this handle. Reset new columns/tables, should be available als meta-data after commit. Fail if no transaction started