Database.Persist

Documentation

class PersistField a where

A value which can be marshalled to and from a PersistValue.

Methods

toPersistValue :: a -> PersistValue

fromPersistValue :: PersistValue -> Either Text a

sqlType :: a -> SqlType

isNullable :: a -> Bool

Instances

PersistField Bool

PersistField Double

PersistField Int

PersistField Int8

PersistField Int16

PersistField Int32

PersistField Int64

PersistField Word8

PersistField Word16

PersistField Word32

PersistField Word64

PersistField String

PersistField Text

PersistField UTCTime

PersistField ByteString

PersistField Html

PersistField ZonedTime

PersistField TimeOfDay

PersistField Day

PersistField SomePersistField

PersistField PersistValue

PersistField a => PersistField [a]

PersistField a => PersistField (Maybe a)

(Ord a, PersistField a) => PersistField (Set a)

(PersistField a, PersistField b) => PersistField (a, b)

PersistField v => PersistField (Map Text v)

PersistField (Key backend entity)

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

type PersistEntityBackend val :: (* -> *) -> * -> *

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

Unique keys in existence on this entity.

Methods

persistFieldDef :: EntityField val typ -> FieldDef

entityDef :: val -> EntityDef

toPersistFields :: val -> [SomePersistField]

fromPersistValues :: [PersistValue] -> Either Text val

halfDefined :: val

persistUniqueToFieldNames :: Unique val backend -> [(HaskellName, DBName)]

persistUniqueToValues :: Unique val backend -> [PersistValue]

persistUniqueKeys :: val -> [Unique val backend]

persistIdField :: EntityField val (Key (PersistEntityBackend val) val)

class (MonadBaseControl IO m, MonadBaseControl IO (backend m)) => PersistStore backend m where

Methods

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

Create a new record in the database, returning an automatically created key (in SQL an auto-increment id).

insertKey :: PersistEntity val => Key backend val -> val -> backend m ()

Create a new record in the database using the given key.

repsert :: PersistEntity val => Key backend val -> val -> backend m ()

Put the record in the database with the given key. Unlike replace, if a record with the given key does not exist then a new record will be inserted.

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

Replace the record in the database with the given key. Note that the result is undefined if such record does not exist, so you must use insertKey or repsert in these cases.

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

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

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

Get a record by identifier, if available.

Instances

(MonadBaseControl IO (SqlPersist m), MonadBaseControl IO m, MonadIO m, MonadThrow m, MonadUnsafeIO m, MonadLogger m) => PersistStore SqlPersist m

class PersistStore backend m => PersistUnique backend m where

Methods

getBy :: (PersistEntityBackend val ~ backend, PersistEntity val) => Unique val backend -> backend m (Maybe (Entity val))

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

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

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

insertUnique :: (backend ~ PersistEntityBackend val, PersistEntity val) => val -> backend m (Maybe (Key backend val))

Like insert, but returns Nothing when the record couldn't be inserted because of a uniqueness constraint.

Instances

(PersistStore SqlPersist m, MonadBaseControl IO m, MonadUnsafeIO m, MonadIO m, MonadThrow m, MonadLogger m) => PersistUnique SqlPersist m

class PersistStore backend m => PersistQuery backend m where

Methods

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

Update individual fields on a specific record.

updateGet :: PersistEntity val => Key backend val -> [Update val] -> backend 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 => [Filter val] -> [Update val] -> backend m ()

Update individual fields on any record matching the given criterion.

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

Delete all records matching the given criterion.

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

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

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

get just the first record for the criterion

selectKeys :: PersistEntity val => [Filter val] -> [SelectOpt val] -> Source (ResourceT (backend m)) (Key backend val)

Get the Keys of all records matching the given criterion.

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

The total number of records fulfilling the given criterion.

Instances

(PersistStore SqlPersist m, MonadThrow m, MonadIO m, MonadUnsafeIO m, MonadBaseControl IO m, MonadLogger m) => PersistQuery SqlPersist m

newtype Key backend entity

Constructors

Key

Fields

unKey :: PersistValue

Instances

Eq (Key backend entity)

Eq (Key backend entity) => Ord (Key backend entity)

Read (Key backend entity)

Show (Key backend entity)

ToJSON (Key backend entity)

FromJSON (Key backend entity)

PathPiece (Key SqlPersist entity)

PersistField (Key backend entity)

data Entity entity

Datatype that represents an entity, with both its key and its Haskell representation.

When using the an SQL-based backend (such as SQLite or PostgreSQL), an Entity may take any number of columns depending on how many fields it has. In order to reconstruct your entity on the Haskell side, persistent needs all of your entity columns and in the right order. Note that you don't need to worry about this when using persistent's API since everything is handled correctly behind the scenes.

However, if you want to issue a raw SQL command that returns an Entity, then you have to be careful with the column order. While you could use SELECT Entity.* WHERE ... and that would work most of the time, there are times when the order of the columns on your database is different from the order that persistent expects (for example, if you add a new field in the middle of you entity definition and then use the migration code -- persistent will expect the column to be in the middle, but your DBMS will put it as the last column). So, instead of using a query like the one above, you may use rawSql (from the Database.Persist.GenericSql module) with its /entity selection placeholder/ (a double question mark ??). Using rawSql the query above must be written as SELECT ?? WHERE ... Then rawSql will replace ?? with the list of all columns that we need from your entity in the right order. If your query returns two entities (i.e. (Entity backend a, Entity backend b)), then you must you use SELECT ??, ?? WHERE ..., and so on.

Constructors

Entity

Fields

entityKey :: Key (PersistEntityBackend entity) entity

entityVal :: entity

Instances

Eq entity => Eq (Entity entity)

(Eq (Entity entity), Ord entity) => Ord (Entity entity)

Read entity => Read (Entity entity)

Show entity => Show (Entity entity)

PersistEntity a => RawSql (Entity a)

insertBy :: (PersistEntity v, PersistStore backend m, PersistUnique backend m, backend ~ PersistEntityBackend v) => v -> backend m (Either (Entity v) (Key backend 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 :: (PersistStore backend m, PersistEntity val, Show (Key backend val)) => Key backend val -> backend 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 :: (PersistStore backend m, PersistEntity ent1, PersistEntity ent2) => (ent1 -> Maybe (Key backend ent2)) -> ent1 -> backend m (Maybe ent2)

belongsToJust :: (PersistStore backend m, PersistEntity ent1, PersistEntity ent2) => (ent1 -> Key backend ent2) -> ent1 -> backend m ent2

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

getByValue :: (PersistEntity v, PersistUnique backend m, PersistEntityBackend v ~ backend) => v -> backend m (Maybe (Entity 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 :: (PersistEntityBackend val ~ backend, PersistEntity val, PersistUnique backend m) => val -> backend 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.

selectList :: (PersistEntity val, PersistQuery backend m, PersistEntityBackend val ~ backend) => [Filter val] -> [SelectOpt val] -> backend m [Entity val]

Call selectSource but return the result as a list.

deleteCascadeWhere :: (DeleteCascade a backend m, PersistQuery backend m) => [Filter a] -> backend m ()

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

Fields

filterField :: EntityField v typ

filterValue :: Either typ [typ]

filterFilter :: PersistFilter

FilterAnd [Filter v]

convenient for internal use, not needed for the API

FilterOr [Filter v]

query combinators

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

assign a field a value

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

assign a field by addition (+=)

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

assign a field by subtraction (-=)

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

assign a field by multiplication (*=)

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

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 typ. PersistField typ => EntityField v typ -> [typ] -> Filter v

In

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

NotIn

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

the OR of two lists of filters