Database.Poseidon

This library provide a Simple and Extensible access to PostgreSQL.

Simple: Poseidon runs a SQL query and returns a set of custom datatype. **It is not an ORM.**

Extensible: As a user of the library, you can map your custom PostgreSQL type to your Haskell datatype easily, in a pluggable way (e.g. if you're using postgis, you will be most likely interested by poseidon-postgis, that maps GeoJSON WKT to GeospatialGeometry).

Documentation

newtype ExceptionText

Constructors

ExceptionText Text

Instances

Eq ExceptionText

Defined in Database.Poseidon

Methods

(==) :: ExceptionText -> ExceptionText -> Bool

(/=) :: ExceptionText -> ExceptionText -> Bool

Show ExceptionText

Defined in Database.Poseidon

Methods

showsPrec :: Int -> ExceptionText -> ShowS

show :: ExceptionText -> String

showList :: [ExceptionText] -> ShowS

Exception ExceptionText

Defined in Database.Poseidon

Methods

toException :: ExceptionText -> SomeException

fromException :: SomeException -> Maybe ExceptionText

displayException :: ExceptionText -> String

data ExceptionPostgreSQL

Constructors

ExceptionPGUniqueViolation

ExceptionPGJWTMalformed

ExceptionPGJWTInvalid

ExceptionPGUnknown

Instances

Eq ExceptionPostgreSQL

Defined in Database.Poseidon

Methods

(==) :: ExceptionPostgreSQL -> ExceptionPostgreSQL -> Bool

(/=) :: ExceptionPostgreSQL -> ExceptionPostgreSQL -> Bool

Show ExceptionPostgreSQL

Defined in Database.Poseidon

Methods

showsPrec :: Int -> ExceptionPostgreSQL -> ShowS

show :: ExceptionPostgreSQL -> String

showList :: [ExceptionPostgreSQL] -> ShowS

Exception ExceptionPostgreSQL

Defined in Database.Poseidon

Methods

toException :: ExceptionPostgreSQL -> SomeException

fromException :: SomeException -> Maybe ExceptionPostgreSQL

displayException :: ExceptionPostgreSQL -> String

queryFromText :: (HasEot a, EotDeserialize (Eot a)) => Connection -> Text -> [Maybe (Oid, ByteString, Format)] -> IO [a]

class EotDeserialize eot where

Methods

eotDeserialize :: Result -> CInt -> CInt -> IO eot

Instances

EotDeserialize ()

Defined in Database.Poseidon

Methods

eotDeserialize :: Result -> CInt -> CInt -> IO ()

EotDeserialize Void

Defined in Database.Poseidon

Methods

eotDeserialize :: Result -> CInt -> CInt -> IO Void

(EotDeserialize this, EotDeserialize next) => EotDeserialize (Either this next)

Defined in Database.Poseidon

Methods

eotDeserialize :: Result -> CInt -> CInt -> IO (Either this next)

(Deserialize x, EotDeserialize xs) => EotDeserialize (x, xs)

Defined in Database.Poseidon

Methods

eotDeserialize :: Result -> CInt -> CInt -> IO (x, xs)

getBSValue :: Result -> CInt -> CInt -> IO (Maybe ByteString)

class Deserialize a where

Methods

deserialize :: Result -> CInt -> CInt -> IO a

Instances

Deserialize Bool

Defined in Database.Poseidon

Methods

deserialize :: Result -> CInt -> CInt -> IO Bool

Deserialize Double

Defined in Database.Poseidon

Methods

deserialize :: Result -> CInt -> CInt -> IO Double

Deserialize Float

Defined in Database.Poseidon

Methods

deserialize :: Result -> CInt -> CInt -> IO Float

Deserialize Integer

Defined in Database.Poseidon

Methods

deserialize :: Result -> CInt -> CInt -> IO Integer

Deserialize ()

Defined in Database.Poseidon

Methods

deserialize :: Result -> CInt -> CInt -> IO ()

Deserialize ByteString

Defined in Database.Poseidon

Methods

deserialize :: Result -> CInt -> CInt -> IO ByteString

Deserialize ByteString

Defined in Database.Poseidon

Methods

deserialize :: Result -> CInt -> CInt -> IO ByteString

Deserialize Text

Defined in Database.Poseidon

Methods

deserialize :: Result -> CInt -> CInt -> IO Text

Deserialize UTCTime

Defined in Database.Poseidon

Methods

deserialize :: Result -> CInt -> CInt -> IO UTCTime

Deserialize Value

Defined in Database.Poseidon

Methods

deserialize :: Result -> CInt -> CInt -> IO Value

Deserialize UUID

Defined in Database.Poseidon

Methods

deserialize :: Result -> CInt -> CInt -> IO UUID

Deserialize [Text]

Defined in Database.Poseidon

Methods

deserialize :: Result -> CInt -> CInt -> IO [Text]

Deserialize (Maybe Bool)

Defined in Database.Poseidon

Methods

deserialize :: Result -> CInt -> CInt -> IO (Maybe Bool)

Deserialize (Maybe Text)

Defined in Database.Poseidon

Methods

deserialize :: Result -> CInt -> CInt -> IO (Maybe Text)

getPGBool :: Get Bool

genericDeserialize :: (HasEot a, EotDeserialize (Eot a)) => Result -> CInt -> CInt -> IO a