persistent-0.6.4.4: Type-safe, non-relational, multi-backend persistence.

Database.Persist

Synopsis

Documentation

class PersistEntity val where

A single database entity. For example, if writing a blog application, a blog entry would be an entry, containing fields such as title and content.

Associated Types

data EntityField val :: * -> *

Parameters: val and datatype of the field

data Unique val :: ((* -> *) -> * -> *) -> *

Unique keys in existence on this entity.

class (MonadIO (b m), MonadIO m, Monad (b m), Monad m) => PersistBackend b m where

Methods

insert :: PersistEntity val => val -> b m (Key b val)

Create a new record in the database, returning the newly created identifier.

replace :: PersistEntity val => Key b val -> val -> b m ()

Replace the record in the database with the given key. Result is undefined if such a record does not exist.

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.

delete :: PersistEntity val => Key b val -> b m ()

Delete a specific record by identifier. Does nothing if record does not exist.

deleteBy :: PersistEntity val => Unique val b -> b m ()

Delete a specific record by unique key. Does nothing if no record matches.

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

Delete all records matching the given criterion.

get :: PersistEntity val => Key b val -> b m (Maybe val)

Get a record by identifier, if available.

getBy :: PersistEntity val => Unique val b -> b m (Maybe (Key b val, val))

Get a record by unique key, if available. Returns also the identifier.

selectEnum :: PersistEntity val => [Filter val] -> [SelectOpt val] -> Enumerator (Key b val, val) (b m) a

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 (Key b val, val))

get just the first record for the criterion

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

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

newtype Key backend entity

Constructors

Key 

Fields

unKey :: PersistValue
 

Instances

Eq (Key backend entity) 
Ord (Key backend entity) 
Read (Key backend entity) 
Show (Key backend entity) 
SinglePiece (Key SqlPersist entity) 
PersistField (Key backend entity) 

selectList :: (PersistEntity val, PersistBackend b m) => [Filter val] -> [SelectOpt val] -> b m [(Key b val, val)]

Call select but return the result as a list.

insertBy :: (PersistEntity v, PersistBackend b m) => v -> b m (Either (Key b v, v) (Key b v))

Insert a value, checking for conflicts with any unique constraints. If a duplicate exists in the database, it is returned as Left. Otherwise, the new Key is returned as Right.

getJust :: (PersistBackend b m, PersistEntity val, Show (Key b val)) => Key b val -> b m val

Same as get, but for a non-null (not Maybe) foreign key Unsafe unless your database is enforcing that the foreign key is valid

belongsTo :: (PersistBackend b m, PersistEntity ent1, PersistEntity ent2) => (ent1 -> Maybe (Key b ent2)) -> ent1 -> b m (Maybe ent2)

belongsToJust :: (PersistBackend b m, PersistEntity ent1, PersistEntity ent2) => (ent1 -> Key b ent2) -> ent1 -> b m ent2

same as belongsTo, but uses getJust and therefore is similarly unsafe

getByValue :: (PersistEntity v, PersistBackend b m) => v -> b m (Maybe (Key b v, v))

A modification of getBy, which takes the PersistEntity itself instead of a Unique value. Returns a value matching one of the unique keys. This function makes the most sense on entities with a single Unique constructor.

checkUnique :: (PersistEntity val, PersistBackend b m) => val -> b m Bool

Check whether there are any conflicts for unique keys with this entity and existing entities in the database.

Returns True if the entity would be unique, and could thus safely be inserted; returns False on a conflict.

data Update v

Constructors

forall typ . PersistField typ => Update 

data SelectOpt v

Constructors

forall typ . Asc (EntityField v typ) 
forall typ . Desc (EntityField v typ) 
OffsetBy Int 
LimitTo Int 

data Filter v

Filters which are available for select, updateWhere and deleteWhere. Each filter constructor specifies the field being filtered on, the type of comparison applied (equals, not equals, etc) and the argument for the comparison.

Constructors

forall typ . PersistField typ => Filter 
FilterAnd [Filter v]

convenient for internal use, not needed for the API

FilterOr [Filter v] 

(=.) :: forall v typ. PersistField typ => EntityField v typ -> typ -> Update v

(+=.) :: forall v typ. PersistField typ => EntityField v typ -> typ -> Update v

(-=.) :: forall v typ. PersistField typ => EntityField v typ -> typ -> Update v

(*=.) :: forall v typ. PersistField typ => EntityField v typ -> typ -> Update v

(/=.) :: forall v typ. PersistField typ => EntityField v typ -> typ -> Update v

(==.) :: forall v typ. PersistField typ => EntityField v typ -> typ -> Filter v

(!=.) :: forall v typ. PersistField typ => EntityField v typ -> typ -> Filter v

assign a field a value

assign a field by addition (+=)

assign a field by subtraction (-=)

assign a field by multiplication (*=)

assign a field by division (/=)

(<.) :: forall v typ. PersistField typ => EntityField v typ -> typ -> Filter v

(>.) :: forall v typ. PersistField typ => EntityField v typ -> typ -> Filter v

(<=.) :: forall v typ. PersistField typ => EntityField v typ -> typ -> Filter v

(>=.) :: forall v typ. PersistField typ => EntityField v typ -> typ -> Filter v

(<-.) :: forall v typ. PersistField typ => EntityField v typ -> [typ] -> Filter v

(/<-.) :: forall v typ. PersistField typ => EntityField v typ -> [typ] -> Filter v

(||.) :: forall v. [Filter v] -> [Filter v] -> [Filter v]

In

NotIn