com.eldrix.iort.impl.sql — com.eldrix/iort 0.1.54

add-constraints-sql clj multimethod

Return SQL DDL statements to add all necessary foreign key constraints.

add-fk-constraints-sql clj

(add-fk-constraints-sql {:keys [cdmTableName cdmFieldName isForeignKey
                                fkTableName fkFieldName]
                         :as field})

add-idx-sql clj

(add-idx-sql {:keys [cdmTableName cdmFieldName] :as field})

add-indices-sql clj multimethod

Return SQL DDL statements to add all indices to a CDM database.

add-table-constraints-sql clj

(add-table-constraints-sql table-fields)

add-table-indices clj

(add-table-indices table-fields)

cdmDatatype->parser clj

create-field-sql clj

(create-field-sql {:keys [datatypes]}
                  {:keys [cdmFieldName isRequired isPrimaryKey cdmDatatype]})

Given a table field specification, return the :with-columns clauses for a :create-table operation.

create-table-sql clj

(create-table-sql {:keys [constraints] :as opts} table-fields)

Given a CDM table specification, return SQL statements. Parameters: opts: a map with :- - constraints : true or false whether to add foreign key constraints - datatypes : map of CDM datatypes to SQL datatypes to use

create-tables-sql clj multimethod

Return SQL DDL statements to create all CDM database tables.

default-datatypes clj

A map of OMOP CDM datatypes to SQL types

drop-constraints-sql clj multimethod

Return SQL DDL statements to drop all foreign key constraints.

drop-fk-constraints-sql clj

(drop-fk-constraints-sql {:keys [cdmTableName isForeignKey] :as field})

drop-idx-sql clj

(drop-idx-sql field)

drop-indices-sql clj multimethod

Return SQL DDL statements to drop all indices from a CDM database.

drop-table-constraints-sql clj

(drop-table-constraints-sql table-fields)

drop-table-indices clj

(drop-table-indices table-fields)

drop-table-sql clj

(drop-table-sql table-name)

drop-tables-sql clj multimethod

Return SQL DDL statements to drop all CDM database tables.

fk-constraint-id clj

(fk-constraint-id {:keys [cdmTableName cdmFieldName]})

Generate a suitable identifier for a foreign key constraint.

foreign-key-sql clj

(foreign-key-sql {:keys [cdmFieldName isForeignKey fkTableName fkFieldName]})

foreign-keys-sql clj

(foreign-keys-sql table-fields)

format clj

(format x)

idx-name clj

(idx-name {:keys [cdmTableName cdmFieldName]})

insert-sql clj multimethod

Return SQL insert statement to insert data into the table specified. Returns 'nil' when no table definition for table specified.

insert-sql* clj

(insert-sql* {:keys [cdmFields cdmTableName] :as table})

parse-cdm-date clj

(parse-cdm-date s)

parsers clj

(parsers table-fields)

Based on table fields, return a vector of parsers for import.

supported-dialects clj

These are the databases that will be tested; it is likely other databases with JDBC drivers would work. Any dialect-specific tweaks are provided within this namespace via multimethods.

upsert-sql clj

(upsert-sql {:keys [cdmFields cdmTableName] :as table})