Squeal.PostgreSQL.Session.Result

Get values from a Result.

Documentation

data Result y where

Results are generated by executing Statements in a MonadPQ.

They contain an underlying Result and a DecodeRow.

Constructors

Result :: SListI row => DecodeRow row y -> Result -> Result y

Instances

Functor Result

Defined in Squeal.PostgreSQL.Session.Result

Methods

fmap :: (a -> b) -> Result a -> Result b

(<$) :: a -> Result b -> Result a

getRow :: MonadIO io => Row -> Result y -> io y

Get a row corresponding to a given row number from a Result, throwing an exception if the row number is out of bounds.

firstRow :: MonadIO io => Result y -> io (Maybe y)

Get the first row if possible from a Result.

getRows :: MonadIO io => Result y -> io [y]

Get all rows from a Result.

nextRow

Arguments

:: MonadIO io

=> Row

total number of rows

-> Result y

result

-> Row

row number

-> io (Maybe (Row, y))

Intended to be used for unfolding in streaming libraries, nextRow takes a total number of rows (which can be found with ntuples) and a Result and given a row number if it's too large returns Nothing, otherwise returning the row along with the next row number.

cmdStatus :: MonadIO io => Result y -> io Text

Returns the command status tag from the SQL command that generated the Result. Commonly this is just the name of the command, but it might include additional data such as the number of rows processed.

cmdTuples :: MonadIO io => Result y -> io (Maybe Row)

Returns the number of rows affected by the SQL command. This function returns Just the number of rows affected by the SQL statement that generated the Result. This function can only be used following the execution of a SELECT, CREATE TABLE AS, INSERT, UPDATE, DELETE, MOVE, FETCH, or COPY statement,or an EXECUTE of a prepared query that contains an INSERT, UPDATE, or DELETE statement. If the command that generated the PGresult was anything else, cmdTuples returns Nothing.

ntuples :: MonadIO io => Result y -> io Row

Returns the number of rows (tuples) in the query result.

nfields :: MonadIO io => Result y -> io Column

Returns the number of columns (fields) in the query result.

resultStatus :: MonadIO io => Result y -> io ExecStatus

Returns the result status of the command.

okResult :: MonadIO io => Result y -> io ()

Check if a Result's status is either CommandOk or TuplesOk otherwise throw a SQLException.

resultErrorMessage :: MonadIO io => Result y -> io (Maybe ByteString)

Returns the error message most recently generated by an operation on the connection.

resultErrorCode :: MonadIO io => Result y -> io (Maybe ByteString)

Returns the error code most recently generated by an operation on the connection.

https://www.postgresql.org/docs/current/static/errcodes-appendix.html

liftResult :: MonadIO io => (Result -> IO x) -> Result y -> io x

Lifts actions on results from LibPQ.