Data.Postgres

newtype JSON a

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

Constructors

• JSON a

Instances

• Newtype (JSON a) _
• (Show a) => Show (JSON a)
• (Eq a) => Eq (JSON a)
• (Ord a) => Ord (JSON a)
• (WriteForeign a) => WriteForeign (JSON a)
• (ReadForeign a) => ReadForeign (JSON a)
• (WriteForeign a) => Serialize (JSON a)

  json, jsonb

• (ReadForeign a) => Deserialize (JSON a)

  json, jsonb

modifyPgTypes :: Effect Unit

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

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.

Members

• serialize :: a -> RepT Raw

Instances

• 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

  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.

Members

• deserialize :: Raw -> RepT a

Instances

• 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 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 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.

Instances

• (Serialize a, Deserialize a) => Rep a

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.