Database.Persist.Query.GenericSql

Documentation

class PersistStore b m => PersistQuery b m where

Methods

update :: PersistEntity val => Key b val -> [Update val] -> b m ()

Update individual fields on a specific record.

updateWhere :: PersistEntity val => [Filter val] -> [Update val] -> b m ()

Update individual fields on any record matching the given criterion.

deleteWhere :: PersistEntity val => [Filter val] -> b m ()

Delete all records matching the given criterion.

selectSource :: PersistEntity val => [Filter val] -> [SelectOpt val] -> Source (b m) (Entity b val)

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

selectFirst :: PersistEntity val => [Filter val] -> [SelectOpt val] -> b m (Maybe (Entity b val))

get just the first record for the criterion

selectKeys :: PersistEntity val => [Filter val] -> Source (b m) (Key b val)

Get the Keys of all records matching the given criterion.

count :: PersistEntity val => [Filter val] -> b m Int

The total number of records fulfilling the given criterion.

Instances

ResourceIO m => PersistQuery SqlPersist m

newtype SqlPersist m a

Constructors

SqlPersist

Fields

unSqlPersist :: ReaderT Connection m a

Instances

MonadTrans SqlPersist

MonadTransControl SqlPersist

ResourceIO m => PersistUnique SqlPersist m

ResourceIO m => PersistStore SqlPersist m

ResourceIO m => PersistQuery SqlPersist m

MonadBase b m => MonadBase b (SqlPersist m)

MonadBaseControl b m => MonadBaseControl b (SqlPersist m)

Monad m => Monad (SqlPersist m)

Functor m => Functor (SqlPersist m)

MonadPlus m => MonadPlus (SqlPersist m)

Applicative m => Applicative (SqlPersist m)

ResourceThrow m => ResourceThrow (SqlPersist m)

MonadIO m => MonadIO (SqlPersist m)

PathPiece (Key SqlPersist entity)

(PersistEntity one, PersistEntity many, Eq (Key SqlPersist one)) => RunJoin (SelectOneMany SqlPersist one many)

filterClauseNoWhere

Arguments

:: PersistEntity val

=> Bool

include table name?

-> Connection

-> [Filter val]

-> Text

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

selectSourceConn :: (ResourceIO m, PersistEntity val) => Connection -> [Filter val] -> [SelectOpt val] -> Source m (Entity SqlPersist 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