oph.korma.common

bonecp-datasource
(bonecp-datasource db-asetukset)
BoneCP based connection pool

convert-instances-of
(convert-instances-of c f m)
defalias
macro
(defalias alias entity)
defentity
macro
(defentity ent & body)
Wrapperi Korman defentitylle, lisää yleiset prepare/transform-funktiot.

delete-unique
macro
(delete-unique entity & body)
Wraps korma.core/delete, deletes exactly one row. Throws if row count is not 1. Returns the number of deleted rows (1).

entity-alias
(entity-alias entity alias)
ilike
(ilike k v)
Korma-funktio Postgresql:n ilike-vertailulle

insert-if-not-exists
(insert-if-not-exists entity row)
Inserts row if it doesn't exist yet

insert-or-update
(insert-or-update entity pk-fields row)
Inserts row if it doesn't exist yet, updates existing row if it does

joda-date->sql-date
(joda-date->sql-date m)
joda-datetime->sql-timestamp
(joda-datetime->sql-timestamp m)
korma-asetukset
(korma-asetukset db-asetukset)
Muuttaa asetustiedoston db-avaimen arvon Korman odottamaan muotoon.

luo-db
(luo-db db-asetukset)
rajaa-kentilla
(rajaa-kentilla query kentat teksti)
select-unique
macro
(select-unique entity & body)
Wraps korma.core/select, returns unique result. Throws if result is not unique.

select-unique*
(select-unique* entity)
Replaces korma.core/select*, creates a query that returns unique result. Throws if result is not unique.

select-unique-or-nil
macro
(select-unique-or-nil entity & body)
Wraps korma.core/select, returns unique result or nil if none found. Throws if result is not unique.

select-unique-or-nil*
(select-unique-or-nil* entity)
Replaces korma.core/select*, creates a query that returns unique result or nil if none found. Throws if result is not unique.

sql-date->joda-date
(sql-date->joda-date m)
sql-timestamp->joda-datetime
(sql-timestamp->joda-datetime m)
to-hki-local-date
(to-hki-local-date date)
Coerce to Finnish local date

unique
(unique results)
unique-or-nil
(unique-or-nil results)
update-unique
macro
(update-unique entity & body)
Wraps korma.core/update, updates exactly one row. Throws if row count is not 1. Returns the number of updated rows (1).