Database.Postgres

newtype Query a

Constructors

• Query String

data Client :: Type

data Pool :: Type

data ConnectionInfo :: Type

type ClientConfig = { database :: String, host :: String, password :: String, port :: Int, ssl :: Boolean, user :: String }

type PoolConfig = { connectionTimeoutMillis :: Int, idleTimeoutMillis :: Int, max :: Int }

type ConnectionString = String

connectionInfoFromConfig :: ClientConfig -> PoolConfig -> ConnectionInfo

connectionInfoFromString :: ConnectionString -> ConnectionInfo

defaultPoolConfig :: PoolConfig

connect :: Pool -> Aff Client

Makes a connection to the database via a Client.

release :: Client -> Effect Unit

end :: Pool -> Effect Unit

execute :: forall a. Query a -> Array SqlValue -> Client -> Aff Unit

Runs a query and returns nothing.

execute_ :: forall a. Query a -> Client -> Aff Unit

Runs a query and returns nothing

query :: forall a. (Foreign -> Either Error a) -> Query a -> Array SqlValue -> Client -> Aff (Array a)

Runs a query and returns all results.

query_ :: forall a. (Foreign -> Either Error a) -> Query a -> Client -> Aff (Array a)

Just like query but does not make any param replacement

queryValue :: forall a. (Foreign -> Either Error a) -> Query a -> Array SqlValue -> Client -> Aff (Maybe a)

Runs a query and returns a single value, if any.

queryValue_ :: forall a. (Foreign -> Either Error a) -> Query a -> Client -> Aff (Maybe a)

Just like queryValue but does not make any param replacement

queryOne :: forall a. (Foreign -> Either Error a) -> Query a -> Array SqlValue -> Client -> Aff (Maybe a)

Runs a query and returns the first row, if any

queryOne_ :: forall a. (Foreign -> Either Error a) -> Query a -> Client -> Aff (Maybe a)

Just like queryOne but does not make any param replacement

withClient :: forall a. Pool -> (Client -> Aff a) -> Aff a

Connects to the database, calls the provided function with the client and returns the results.

mkPool :: ConnectionInfo -> Effect Pool