Module

Data.Postgres

newtype JSON a

Newtype hinting that this value should be serialized / deserialized as a JSON string.

modifyPgTypes :: Effect Unit

This mutates import('pg').types, setting deserialization for some types to unmarshal as strings rather than JS values.

isInstanceOfBuffer :: Foreign -> Boolean

isInstanceOfInterval :: Foreign -> Boolean

type RepT = ExceptT (NonEmptyList ForeignError) Effect

The serialization & deserialization monad.

smash :: forall a. RepT a -> Effect a

Flatten to an Effect, showing errors

class Serialize a  where

Serialize data of type a to a Raw SQL value.

Serialize Raw
Serialize Unit
NULL
Serialize Null
NULL
(WriteForeign a) => Serialize (JSON a)
json, jsonb
Serialize Buffer
bytea
Serialize Int
int2, int4
Serialize BigInt
int8
Serialize Boolean
bool
Serialize String
text, inet, tsquery, tsvector, uuid, xml, cidr, time, timetz
Serialize Number
float4, float8
Serialize DateTime
interval
Serialize Interval
interval
Serialize Milliseconds
interval
Serialize Seconds
interval
Serialize Minutes
interval
Serialize Hours
interval
Serialize Days
interval
Serialize Instant
timestamp, timestamptz
(Serialize a) => Serialize (Maybe a)
Just -> a, Nothing -> NULL
(Serialize a) => Serialize (Array a)
postgres array
(Ord a, Rep a) => Serialize (Range a)

class Deserialize a  where

Deserialize data of type a from a Raw SQL value.

Deserialize Raw
Deserialize Unit
NULL (always succeeds)
Deserialize Null
NULL (fails if non-null)
(ReadForeign a) => Deserialize (JSON a)
json, jsonb
Deserialize Buffer
bytea
Deserialize Interval
interval
Deserialize Milliseconds
interval
Deserialize Seconds
interval
Deserialize Minutes
interval
Deserialize Hours
interval
Deserialize Days
interval
Deserialize Int
int2, int4
Deserialize BigInt
int8
Deserialize Boolean
bool
Deserialize String
text, inet, tsquery, tsvector, uuid, xml, cidr, time, timetz
Deserialize Number
float4, float8
Deserialize DateTime
timestamp, timestamptz
Deserialize Instant
timestamp, timestamptz
(Deserialize a) => Deserialize (Array a)
postgres array
(Deserialize a) => Deserialize (Maybe a)
non-NULL -> Just, NULL -> Nothing
(Ord a, Rep a) => Deserialize (Range a)

class (Serialize a, Deserialize a) <= Rep a

A type which is Representable as a SQL value.

unsafeSerializeCoerce :: forall m a. Monad m => a -> m Raw

Coerces the value to Raw.

This is only safe for values whose javascript representation can be directly serialized by node-postgres to the corresponding SQL type.

invalidDuration :: NonEmptyList ForeignError