Module

Yoga.Postgres

Package: purescript-yoga-postgres
Repository: rowtype-yoga/purescript-yoga-postgres

#Connection Source

data Connection

#Transaction Source

data Transaction

#PGValue Source

data PGValue

#PostgresHost Source

newtype PostgresHost

Constructors

PostgresHost String

Instances

#PostgresPort Source

newtype PostgresPort

Constructors

PostgresPort Int

Instances

#PostgresDatabase Source

newtype PostgresDatabase

Constructors

PostgresDatabase String

Instances

#PostgresUsername Source

newtype PostgresUsername

Constructors

PostgresUsername String

Instances

#PostgresPassword Source

newtype PostgresPassword

Constructors

PostgresPassword String

Instances

#ConnectionString Source

newtype ConnectionString

Constructors

ConnectionString String

Instances

#MaxConnections Source

newtype MaxConnections

Constructors

MaxConnections Int

Instances

#IdleTimeout Source

newtype IdleTimeout

Constructors

IdleTimeout Milliseconds

Instances

#ConnectTimeout Source

newtype ConnectTimeout

Constructors

ConnectTimeout Milliseconds

Instances

#StatementTimeout Source

newtype StatementTimeout

Constructors

StatementTimeout Milliseconds

Instances

#SQL Source

newtype SQL

Constructors

SQL String

Instances

#ToPGValue Source

class ToPGValue a  where

Members

toPGValue :: a -> PGValue

Instances

#param Source

param :: forall a. ToPGValue a => a -> Array PGValue

#params Source

params :: forall a. ToPGValue a => Array a -> Array PGValue

#Row Source

type Row = Foreign

#QueryResult Source

type QueryResult = { command :: String, count :: Int, rows :: Array Row }

#PostgresConfigImpl Source

type PostgresConfigImpl :: Row Typetype PostgresConfigImpl = (connect_timeout :: ConnectTimeout, connection :: ConnectionString, database :: PostgresDatabase, debug :: Boolean, host :: PostgresHost, idle_timeout :: IdleTimeout, max :: MaxConnections, onnotice :: Effect Unit, onparameter :: Foreign -> Effect Unit, password :: PostgresPassword, port :: PostgresPort, ssl :: Boolean, username :: PostgresUsername)

#postgresImpl Source

postgresImpl :: forall opts. EffectFn1 (Record opts) Connection

#postgres Source

postgres :: forall opts opts_. Union opts opts_ PostgresConfigImpl => Record opts -> Effect Connection

#queryImpl Source

queryImpl :: EffectFn3 Connection SQL (Array PGValue) (Promise QueryResult)

#query Source

query :: SQL -> Array PGValue -> Connection -> Aff QueryResult

#querySimpleImpl Source

querySimpleImpl :: EffectFn2 Connection SQL (Promise QueryResult)

#querySimple Source

querySimple :: SQL -> Connection -> Aff QueryResult

#queryOneImpl Source

queryOneImpl :: EffectFn3 Connection SQL (Array PGValue) (Promise (Nullable Row))

#queryOne Source

queryOne :: SQL -> Array PGValue -> Connection -> Aff (Maybe Row)

#queryOneSimpleImpl Source

queryOneSimpleImpl :: EffectFn2 Connection SQL (Promise (Nullable Row))

#queryOneSimple Source

queryOneSimple :: SQL -> Connection -> Aff (Maybe Row)

#unsafeImpl Source

unsafeImpl :: EffectFn3 Connection SQL (Array PGValue) (Promise Row)

#unsafe Source

unsafe :: SQL -> Array PGValue -> Connection -> Aff Row

#executeImpl Source

executeImpl :: EffectFn3 Connection SQL (Array PGValue) (Promise Int)

#execute Source

execute :: SQL -> Array PGValue -> Connection -> Aff Int

#executeSimpleImpl Source

executeSimpleImpl :: EffectFn2 Connection SQL (Promise Int)

#executeSimple Source

executeSimple :: SQL -> Connection -> Aff Int

#beginImpl Source

beginImpl :: EffectFn1 Connection (Promise Transaction)

#begin Source

begin :: Connection -> Aff Transaction

#commitImpl Source

commitImpl :: EffectFn1 Transaction (Promise Unit)

#commit Source

commit :: Transaction -> Aff Unit

#rollbackImpl Source

rollbackImpl :: EffectFn1 Transaction (Promise Unit)

#rollback Source

rollback :: Transaction -> Aff Unit

#transactionImpl Source

transactionImpl :: EffectFn2 Connection (Transaction -> Effect (Promise Unit)) (Promise Unit)

#transaction Source

transaction :: (Transaction -> Aff Unit) -> Connection -> Aff Unit

#txQueryImpl Source

txQueryImpl :: EffectFn3 Transaction SQL (Array PGValue) (Promise QueryResult)

#txQuery Source

txQuery :: SQL -> Array PGValue -> Transaction -> Aff QueryResult

#txQuerySimpleImpl Source

txQuerySimpleImpl :: EffectFn2 Transaction SQL (Promise QueryResult)

#txQuerySimple Source

txQuerySimple :: SQL -> Transaction -> Aff QueryResult

#txExecuteImpl Source

txExecuteImpl :: EffectFn3 Transaction SQL (Array PGValue) (Promise Int)

#txExecute Source

txExecute :: SQL -> Array PGValue -> Transaction -> Aff Int

#endImpl Source

endImpl :: EffectFn1 Connection (Promise Unit)

#end Source

end :: Connection -> Aff Unit

#Channel Source

newtype Channel

Constructors

Channel String

Instances

#Notification Source

type Notification = { channel :: Channel, payload :: String }

#listenImpl Source

listenImpl :: EffectFn3 Connection Channel (Notification -> Effect Unit) (Promise Unit)

#listen Source

listen :: Channel -> (Notification -> Effect Unit) -> Connection -> Aff Unit

#unlistenImpl Source

unlistenImpl :: EffectFn2 Connection Channel (Promise Unit)

#unlisten Source

unlisten :: Channel -> Connection -> Aff Unit

#notifyImpl Source

notifyImpl :: EffectFn3 Connection Channel String (Promise Unit)

#notify Source

notify :: Channel -> String -> Connection -> Aff Unit

#StatementName Source

newtype StatementName

Constructors

StatementName String

Instances

#PreparedStatement Source

type PreparedStatement = { name :: StatementName, query :: SQL }

#prepareImpl Source

prepareImpl :: EffectFn3 Connection StatementName SQL (Promise Unit)

#prepare Source

prepare :: StatementName -> SQL -> Connection -> Aff Unit

#executePreparedImpl Source

executePreparedImpl :: EffectFn3 Connection StatementName (Array PGValue) (Promise QueryResult)

#executePrepared Source

executePrepared :: StatementName -> Array PGValue -> Connection -> Aff QueryResult

#deallocateImpl Source

deallocateImpl :: EffectFn2 Connection StatementName (Promise Unit)

#deallocate Source

deallocate :: StatementName -> Connection -> Aff Unit

#pingImpl Source

pingImpl :: EffectFn1 Connection (Promise Boolean)

#ping Source

ping :: Connection -> Aff Boolean

#optionsImpl Source

optionsImpl :: EffectFn1 Connection { database :: String, host :: String, port :: Int }

#options Source

options :: Connection -> Effect { database :: String, host :: String, port :: Int }

Modules: Yoga.Postgres; Yoga.Postgres.Schema; Yoga.Postgres.TypedQuery