Database.Persist.Query.GenericSql

Documentation

class PersistStore m => PersistQuery m where

Methods

update :: (PersistEntity val, PersistEntityBackend val ~ PersistMonadBackend m) => Key val -> [Update val] -> m ()

Update individual fields on a specific record.

updateGet :: (PersistEntity val, PersistMonadBackend m ~ PersistEntityBackend val) => Key val -> [Update val] -> m val

Update individual fields on a specific record, and retrieve the updated value from the database.

Note that this function will throw an exception if the given key is not found in the database.

updateWhere :: (PersistEntity val, PersistEntityBackend val ~ PersistMonadBackend m) => [Filter val] -> [Update val] -> m ()

Update individual fields on any record matching the given criterion.

deleteWhere :: (PersistEntity val, PersistEntityBackend val ~ PersistMonadBackend m) => [Filter val] -> m ()

Delete all records matching the given criterion.

selectSource :: (PersistEntity val, PersistEntityBackend val ~ PersistMonadBackend m) => [Filter val] -> [SelectOpt val] -> Source m (Entity val)

Get all records matching the given criterion in the specified order. Returns also the identifiers.

selectFirst :: (PersistEntity val, PersistEntityBackend val ~ PersistMonadBackend m) => [Filter val] -> [SelectOpt val] -> m (Maybe (Entity val))

get just the first record for the criterion

selectKeys :: (PersistEntity val, PersistEntityBackend val ~ PersistMonadBackend m) => [Filter val] -> [SelectOpt val] -> Source m (Key val)

Get the Keys of all records matching the given criterion.

count :: (PersistEntity val, PersistEntityBackend val ~ PersistMonadBackend m) => [Filter val] -> m Int

The total number of records fulfilling the given criterion.

Instances

(PersistStore (ResourceT m), PersistQuery m) => PersistQuery (ResourceT m)

(PersistStore (LoggingT m), PersistQuery m) => PersistQuery (LoggingT m)

(PersistStore (ListT m), PersistQuery m) => PersistQuery (ListT m)

(PersistStore (MaybeT m), PersistQuery m) => PersistQuery (MaybeT m)

(PersistStore (IdentityT m), PersistQuery m) => PersistQuery (IdentityT m)

(PersistStore (SqlPersist m), MonadResource m, MonadLogger m) => PersistQuery (SqlPersist m)

(PersistStore (ContT r m), PersistQuery m) => PersistQuery (ContT r m)

(PersistStore (ErrorT e m), Error e, PersistQuery m) => PersistQuery (ErrorT e m)

(PersistStore (ReaderT r m), PersistQuery m) => PersistQuery (ReaderT r m)

(PersistStore (StateT s m), PersistQuery m) => PersistQuery (StateT s m)

(PersistStore (StateT s m), PersistQuery m) => PersistQuery (StateT s m)

(PersistStore (WriterT w m), Monoid w, PersistQuery m) => PersistQuery (WriterT w m)

(PersistStore (WriterT w m), Monoid w, PersistQuery m) => PersistQuery (WriterT w m)

(PersistStore (RWST r w s m), Monoid w, PersistQuery m) => PersistQuery (RWST r w s m)

(PersistStore (RWST r w s m), Monoid w, PersistQuery m) => PersistQuery (RWST r w s m)

(PersistStore (Pipe l i o u m), PersistQuery m) => PersistQuery (Pipe l i o u m)

newtype SqlPersist m a

Constructors

SqlPersist

Fields

unSqlPersist :: ReaderT Connection m a

Instances

MonadTrans SqlPersist

MonadTransControl SqlPersist

(MonadBase backend (SqlPersist m), MonadBaseControl backend m) => MonadBaseControl backend (SqlPersist m)

(Applicative backend, Applicative (SqlPersist m), Monad backend, Monad (SqlPersist m), MonadBase backend m) => MonadBase backend (SqlPersist m)

Monad m => Monad (SqlPersist m)

Functor m => Functor (SqlPersist m)

(Monad (SqlPersist m), MonadPlus m) => MonadPlus (SqlPersist m)

(Functor (SqlPersist m), Applicative m) => Applicative (SqlPersist m)

(Monad (SqlPersist m), MonadThrow m) => MonadThrow (SqlPersist m)

(MonadThrow (SqlPersist m), MonadUnsafeIO (SqlPersist m), MonadIO (SqlPersist m), Applicative (SqlPersist m), MonadResource m) => MonadResource (SqlPersist m)

(Monad (SqlPersist m), MonadLogger m) => MonadLogger (SqlPersist m)

(Monad (SqlPersist m), MonadIO m) => MonadIO (SqlPersist m)

(PersistStore (SqlPersist m), MonadResource m, MonadLogger m) => PersistUnique (SqlPersist m)

(MonadIO (SqlPersist m), MonadResource m, MonadLogger m) => PersistStore (SqlPersist m)

(MonadIO (SqlPersist m), MonadLogger (SqlPersist m), MonadIO m, MonadLogger m) => MonadSqlPersist (SqlPersist m)

(PersistStore (SqlPersist m), MonadResource m, MonadLogger m) => PersistQuery (SqlPersist m)

filterClauseNoWhere

Arguments

:: PersistEntity val

=> Bool

include table name?

-> Connection

-> [Filter val]

-> Text

filterClauseNoWhereOrNull

Arguments

:: PersistEntity val

=> Bool

include table name?

-> Connection

-> [Filter val]

-> Text

getFiltsValues :: forall val. PersistEntity val => Connection -> [Filter val] -> [PersistValue]

selectSourceConn :: (PersistEntity val, MonadResource m, MonadLogger m, PersistEntityBackend val ~ SqlBackend, MonadBaseControl IO m) => Connection -> [Filter val] -> [SelectOpt val] -> Source m (Entity val)

Equivalent to selectSource, but instead of getting the connection from the environment inside a SqlPersist monad, provide an explicit Connection. This can allow you to use the returned Source in an arbitrary monad.

dummyFromFilts :: [Filter v] -> v

orderClause

Arguments

:: PersistEntity val

=> Bool

include the table name

-> Connection

-> SelectOpt val

-> Text