Yoga.Postgres.Om

query :: forall @a ctx err. ReadForeign a => SQL -> Array PGValue -> Connection -> Om ctx (parseError :: MultipleErrors | err) (Array a)

Query and parse rows using yoga-json's ReadForeign (DEFAULT) Throws parse errors to the Om exception channel

queryOne :: forall @a ctx err. ReadForeign a => SQL -> Array PGValue -> Connection -> Om ctx (parseError :: MultipleErrors | err) (Maybe a)

Query one row and parse using yoga-json's ReadForeign (DEFAULT) Throws parse errors to the Om exception channel

unsafe :: forall @a ctx err. ReadForeign a => SQL -> Array PGValue -> Connection -> Om ctx (parseError :: MultipleErrors | err) a

Unsafe query (expects exactly one row) and parse using yoga-json (DEFAULT) Throws parse errors to the Om exception channel

queryUnsafe :: forall @a ctx err. SQL -> Array PGValue -> Connection -> Om ctx err (Array a)

Query and unsafeCoerce rows to the desired type (bypasses yoga-json parsing) USE WITH CAUTION - no runtime validation!

queryOneUnsafe :: forall @a ctx err. SQL -> Array PGValue -> Connection -> Om ctx err (Maybe a)

Query one row and unsafeCoerce to the desired type (bypasses yoga-json parsing) USE WITH CAUTION - no runtime validation!

unsafeUnsafe :: forall @a ctx err. SQL -> Array PGValue -> Connection -> Om ctx err a

Unsafe query (expects exactly one row) and unsafeCoerce to the desired type USE WITH CAUTION - no runtime validation!

execute :: forall ctx err. SQL -> Array PGValue -> Connection -> Om ctx err Int

Om-friendly execute (takes Connection as parameter)

executeSimple :: forall ctx err. SQL -> Connection -> Om ctx err Int

Om-friendly executeSimple (takes Connection as parameter)

transaction :: forall ctx err a. (Transaction -> Om ctx err a) -> Connection -> Om ctx err a

Om-friendly transaction (takes Connection as parameter)

txQuery :: forall @a ctx err. ReadForeign a => SQL -> Array PGValue -> Transaction -> Om ctx (parseError :: MultipleErrors | err) (Array a)

Transaction query and parse rows using yoga-json's ReadForeign (DEFAULT) Throws parse errors to the Om exception channel

txQuerySimple :: forall ctx err. SQL -> Transaction -> Om ctx err QueryResult

Om-friendly transaction querySimple (raw Foreign, takes Transaction as parameter)

txExecute :: forall ctx err. SQL -> Array PGValue -> Transaction -> Om ctx err Int

Om-friendly transaction execute (takes Transaction as parameter)

data Transaction

newtype SQL

Instances

• Newtype SQL _
• Eq SQL
• Show SQL

type QueryResult = { command :: String, count :: Int, rows :: Array Row }

data PGValue

data Connection

toPGValue :: forall a. ToPGValue a => a -> PGValue