Database.PostgreSQL.PQTypes.Utils

Documentation

throwDB :: (Exception e, MonadDB m, MonadThrow m) => e -> m a

When given DBException, throw it immediately. Otherwise wrap it in DBException with the current query context first.

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.

runPreparedQuery_ :: (IsSQL sql, MonadDB m) => QueryName -> sql -> m ()

Specialization of runPreparedQuery that discards the result.

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

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

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

Specialization of runPreparedQuery01 that discards the result.

runPreparedSQL :: MonadDB m => QueryName -> SQL -> m Int

Specialization of runPreparedQuery to SQL type.

runPreparedSQL_ :: MonadDB m => QueryName -> SQL -> m ()

Specialization of runPreparedQuery_ to SQL type.

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

Specialization of runPreparedQuery01 to SQL type.

runPreparedSQL01_ :: (MonadDB m, MonadThrow m) => QueryName -> SQL -> m ()

Specialization of runPreparedQuery01_ to SQL type.

hpqTypesError :: String -> IO a

Throw 'HPQTypesError exception.