Data.Postgres.Result

data Result

A raw query result

https://node-postgres.com/apis/result

rowsAffected :: Result -> Maybe Int

Returns the number of rows affected by the query

https://node-postgres.com/apis/result#resultrowcount-int--null

class FromRows a  where

Members

• fromRows :: Array (Array Raw) -> RepT a

Instances

• (FromRow a) => FromRows (Array a)
• (FromRow a) => FromRows (Maybe a)
• (FromRow a) => FromRows a

class FromRow (a :: Type)  where

Can be unmarshalled from a queried row

Implementations are provided for:

• tuples of any length containing types that are Rep
• tuples of any length with the last member of Array Raw
• a single value of a type that is Rep
• Array Raw
• Unit (always succeeds)

-- CREATE TABLE foo
--   ( id INT NOT NULL PRIMARY KEY
--   , fruit TEXT NOT NULL
--   , created TIMESTAMPTZ NOT NULL DEFAULT NOW()
--   );
do
  let q = query "select id, fruit, created from foo" client

  -- pick all 3 columns explicitly
  _ :: Array (Int /\ String /\ DateTime) <- q

  -- pick first 2 columns, discarding any others
  _ :: Array (Int /\ String) <- q

  -- pick first 2 columns, if any more keep as `Array Raw`
  _ :: Array (Int /\ String /\ Array Raw) <- q

  -- pick just the ID, discarding all other columns
  id :: Array Int <- q

  pure unit

Members

• minColumnCount :: forall g. g a -> Int

  Minimum length of row for type a

• fromRow :: Array Raw -> RepT a

  Performs the conversion

Instances

• (Deserialize a, FromRow b) => FromRow (Tuple a b)
• FromRow (Array Raw)
• FromRow Unit
• (Deserialize a) => FromRow a

__rowsAffected :: Result -> Nullable Number

FFI binding for Result#rowCount

rows :: Result -> Array (Array Raw)

FFI binding for Result#rows