Selda.PG.Class

class (MonadAff m, MonadError PGError m, MonadReader Connection m) <= MonadSelda m 

Instances

• (MonadAff m, MonadError PGError m, MonadReader Connection m) => MonadSelda m

insert_ :: forall m tup rlcols t r. RowToList r rlcols => CanInsertColumnsIntoTable rlcols t => TableColumnNames rlcols => RowListLength rlcols => FromSQLRow tup => ToSQLRow tup => MkTupleToRecord tup r => HFoldl RecordToTuple Unit (Record r) tup => MonadSelda m => Table t -> Array (Record r) -> m Unit

Executes an insert query for each input record.

insert :: forall m tup rlcols t r. RowToList r rlcols => CanInsertColumnsIntoTable rlcols t => TableColumnNames rlcols => RowListLength rlcols => FromSQLRow tup => ToSQLRow tup => MkTupleToRecord tup r => HFoldl RecordToTuple Unit (Record r) tup => MonadSelda m => Table t -> Array (Record r) -> m (Array (Record r))

Executes an insert query for each input record. Records to be inserted needs to have columns without constraints, Default ale optional, Auto must be missing

query :: forall m s tup i o. ColsToPGHandler s i tup o => GetCols i => FromSQLRow tup => MonadSelda m => FullQuery s (Record i) -> m (Array (Record o))

deleteFrom :: forall m r' s r. TableToColsWithoutAlias r r' => MonadSelda m => Table r -> (Record r' -> Col s Boolean) -> m Unit

update :: forall m r' s r. TableToColsWithoutAlias r r' => GetCols r' => MonadSelda m => Table r -> (Record r' -> Col s Boolean) -> (Record r' -> Record r') -> m Unit