lighthouse.core — coast-framework/lighthouse 1.0.1

coerce-boolean clj

(coerce-boolean schema val)

Coerce sqlite booleans: 1 or 0 to clojure booleans

coerce-inst clj

(coerce-inst val)

Coerce json iso8601 to clojure #inst

coerce-timestamp-inst clj

(coerce-timestamp-inst val)

Coerce timestamps to clojure #inst

cols clj

(cols c k)

Lists the columns in the db given the table name as keyword

Ex:

(cols :table-name) ; => corresponds to postgres table table_name

connect clj

(connect s)

(connect s m)

Takes a string returns a connection pool from a connection string

create clj

(create s)

Creates a new database

defq clj macro

(defq conn filename)

(defq conn n filename)

Use regular .sql files and call them as functions

Ex:

test.sql: -- name: some-sql select * from todo where todo.name = :name

clojure: (defq "test.sql")

creates a fn some-sql in the current namespace

(some-sql {:name "test todo #1"})

delete clj

(delete conn val)

Deletes a map or a vector of maps by primary key only

disconnect clj

(disconnect m)

Takes a lighthouse {:datasource ^HikariDataSource} map and closes the connection to the database

driver-class-name clj

(driver-class-name s)

drop clj

(drop s)

Drops an existing database

insert clj

(insert conn val)

Inserts a map or a vector of maps into the db. All maps need to have the same keys.

migrate clj

(migrate c migration)

(migrate c migration m)

Takes a jdbc connection or datasource and a migration vector

opts clj

parse-json clj

(parse-json schema val)

Parses json from pull queries

pool clj

(pool s m)

Shamelessly stolen from hikari-cp and makes a new hikaricp data source

pull clj

(pull conn v where-clause)

The main entry point for queries that return a nested result based on a lighthouse schema and a primary key

q clj

(q conn v)

(q conn v params)

The main entry point for queries

Ex: (q conn '[:select todo/*])

qualify-col clj

(qualify-col s)

This is a relatively complex function to replace col names with $ in them, pull comes at a cost

rollback clj

(rollback c)

(rollback c m)

Rolls back a migration vector

schema clj

(schema c)

Shows the current lighthouse schema

transact clj

(transact conn query)

(transact conn query params)

Takes a jdbc connection, a query and an optional map of params

Ex: (transact conn '[:delete :from todo :where [todo/id 1]])

update clj

(update conn val)

Updates a map or a vector of maps in the db. All maps need to have one primary key and the same set of keys.