Database.Persist.Store

API for database actions. The API deals with fields and entities. In SQL, a field corresponds to a column, and should be a single non-composite value. An entity corresponds to a SQL table, so an entity is a collection of fields.

Documentation

data PersistValue

A raw value which can be stored in any backend and can be marshalled to and from a PersistField.

Constructors

PersistText Text

PersistByteString ByteString

PersistInt64 Int64

PersistDouble Double

PersistBool Bool

PersistDay Day

PersistTimeOfDay TimeOfDay

PersistUTCTime UTCTime

PersistZonedTime ZT

PersistNull

PersistList [PersistValue]

PersistMap [(Text, PersistValue)]

PersistObjectId ByteString

intended especially for MongoDB backend

Instances

Eq PersistValue

Ord PersistValue

Read PersistValue

Show PersistValue

Typeable PersistValue

ToJSON PersistValue

FromJSON PersistValue

PathPiece PersistValue

PersistField PersistValue

data SqlType

A SQL data type. Naming attempts to reflect the underlying Haskell datatypes, eg SqlString instead of SqlVarchar. Different SQL databases may have different translations for these types.

Constructors

SqlString

SqlInt32

SqlInt64

SqlReal

SqlBool

SqlDay

SqlTime

SqlDayTime

SqlDayTimeZoned

SqlBlob

SqlOther Text

a backend-specific name

Instances

Eq SqlType

Ord SqlType

Read SqlType

Show SqlType

Typeable SqlType

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 Text

PersistField Html

PersistField ZonedTime

PersistField TimeOfDay

PersistField Day

PersistField SomePersistField

PersistField PersistValue

PersistField Checkmark

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 (KeyBackend 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 -> [(HaskellName, DBName)]

persistUniqueToValues :: Unique val -> [PersistValue]

persistUniqueKeys :: val -> [Unique val]

persistIdField :: EntityField val (Key val)

class MonadIO m => PersistStore m where

Associated Types

type PersistMonadBackend m

Methods

insert :: (PersistMonadBackend m ~ PersistEntityBackend val, PersistEntity val) => val -> m (Key val)

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

insert_ :: (PersistMonadBackend m ~ PersistEntityBackend val, PersistEntity val) => val -> m ()

Same as insert, but doesn't return a Key.

insertKey :: (PersistMonadBackend m ~ PersistEntityBackend val, PersistEntity val) => Key val -> val -> m ()

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

repsert :: (PersistMonadBackend m ~ PersistEntityBackend val, PersistEntity val) => Key val -> val -> 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 :: (PersistMonadBackend m ~ PersistEntityBackend val, PersistEntity val) => Key val -> val -> 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 :: (PersistMonadBackend m ~ PersistEntityBackend val, PersistEntity val) => Key val -> m ()

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

get :: (PersistMonadBackend m ~ PersistEntityBackend val, PersistEntity val) => Key val -> m (Maybe val)

Get a record by identifier, if available.

Instances

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

class PersistStore m => PersistUnique m where

Queries against unique keys (other than the id).

Please read the general Persistent documentation to learn how to create Unique keys. SQL backends automatically create uniqueness constraints, but for MongoDB you must place a unique index on the field.

Methods

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

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

deleteBy :: (PersistEntityBackend val ~ PersistMonadBackend m, PersistEntity val) => Unique val -> m ()

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

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

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

Instances

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

data PersistFilter

Constructors

Eq

Ne

Gt

Lt

Ge

Le

In

NotIn

BackendSpecificFilter Text

Instances

Read PersistFilter

Show PersistFilter

data SomePersistField

Constructors

forall a . PersistField a => SomePersistField a

Instances

PersistField SomePersistField

newtype ZT

Avoid orphan instances.

Constructors

ZT ZonedTime

Instances

Eq ZT

Ord ZT

Read ZT

Show ZT

Typeable ZT

insertBy :: (PersistEntity v, PersistStore m, PersistUnique m, PersistMonadBackend m ~ PersistEntityBackend v) => v -> m (Either (Entity v) (Key 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.

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

getJust :: (PersistStore m, PersistEntity val, Show (Key val), PersistMonadBackend m ~ PersistEntityBackend val) => Key val -> 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 m, PersistEntity ent1, PersistEntity ent2, PersistMonadBackend m ~ PersistEntityBackend ent2) => (ent1 -> Maybe (Key ent2)) -> ent1 -> m (Maybe ent2)

belongsToJust :: (PersistStore m, PersistEntity ent1, PersistEntity ent2, PersistMonadBackend m ~ PersistEntityBackend ent2) => (ent1 -> Key ent2) -> ent1 -> m ent2

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

checkUnique :: (PersistEntityBackend val ~ PersistMonadBackend m, PersistEntity val, PersistUnique m) => val -> 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.

class (PersistStore m, PersistEntity a, PersistEntityBackend a ~ PersistMonadBackend m) => DeleteCascade a m where

Methods

deleteCascade :: Key a -> m ()

data PersistException

Constructors

PersistError Text

Generic Exception

PersistMarshalError Text

PersistInvalidField Text

PersistForeignConstraintUnmet Text

PersistMongoDBError Text

PersistMongoDBUnsupported Text

Instances

Show PersistException

Typeable PersistException

Exception PersistException

Error PersistException

newtype KeyBackend backend entity

Constructors

Key

Fields

unKey :: PersistValue

Instances

Eq (KeyBackend backend entity)

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

Read (KeyBackend backend entity)

Show (KeyBackend backend entity)

ToJSON (KeyBackend backend entity)

FromJSON (KeyBackend backend entity)

PathPiece (KeyBackend SqlBackend entity)

PersistField (KeyBackend backend entity)

type Key val = KeyBackend (PersistEntityBackend val) val

Helper wrapper, equivalent to Key (PersistEntityBackend val) val.

Since 1.1.0

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 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)

Helpers

getPersistMap :: PersistValue -> Either Text [(Text, PersistValue)]

listToJSON :: [PersistValue] -> Text

mapToJSON :: [(Text, PersistValue)] -> Text

Config

class PersistConfig c where

Represents a value containing all the configuration options for a specific backend. This abstraction makes it easier to write code that can easily swap backends.

Associated Types

type PersistConfigBackend c :: (* -> *) -> * -> *

type PersistConfigPool c

Methods

loadConfig :: Value -> Parser c

Load the config settings from a Value, most likely taken from a YAML config file.

applyEnv :: c -> IO c

Modify the config settings based on environment variables.

createPoolConfig :: c -> IO (PersistConfigPool c)

Create a new connection pool based on the given config settings.

runPool :: (MonadBaseControl IO m, MonadIO m) => c -> PersistConfigBackend c m a -> PersistConfigPool c -> m a

Run a database action by taking a connection from the pool.