Database.PostgreSQL.PQTypes.Utils

Documentation

raw :: RawSQL () -> SQL

Convert RawSQL () to SQL.

runQuery_ :: (IsSQL sql, MonadDB m) => sql -> m ()

Specialization of runQuery that discards the result.

runQuery01 :: (IsSQL sql, MonadDB m, MonadThrow m) => sql -> m Bool

Specialization of runQuery that checks whether affected/returned number of rows is in range [0, 1] and returns appropriate Bool value. Otherwise, AffectedRowsMismatch exception is thrown.

runQuery01_ :: (IsSQL sql, MonadDB m, MonadThrow m) => sql -> m ()

Specialization of runQuery01 that discards the result.

runSQL :: MonadDB m => SQL -> m Int

Specialization of runQuery to SQL type.

runSQL_ :: MonadDB m => SQL -> m ()

Specialization of runQuery_ to SQL type.

runSQL01 :: (MonadDB m, MonadThrow m) => SQL -> m Bool

Specialization of runQuery01 to SQL type.

runSQL01_ :: (MonadDB m, MonadThrow m) => SQL -> m ()

Specialization of runQuery01_ to SQL type.

fetchMany :: (MonadDB m, FromRow row) => (row -> t) -> m [t]

Specialization of foldrM that fetches list of rows.

fetchMaybe :: (MonadDB m, MonadThrow m, FromRow row) => (row -> t) -> m (Maybe t)

Specialization of foldlM that fetches one or zero rows. If more rows are delivered, AffectedRowsMismatch exception is thrown.

fetchOne :: (MonadDB m, MonadThrow m, FromRow row) => (row -> t) -> m t

Specialization of foldlM that fetches exactly one row. If different number of rows is delivered, AffectedRowsMismatch exception is thrown.

hpqTypesError :: String -> IO a

Throw 'HPQTypesError exception.