Database.Esqueleto.Internal.Sql

Documentation

data SqlQuery a

SQL backend for esqueleto using SqlPersist.

Instances

Monad SqlQuery

Functor SqlQuery

Applicative SqlQuery

Esqueleto SqlQuery SqlExpr SqlPersist

data SqlExpr a

An expression on the SQL backend.

Instances

Esqueleto SqlQuery SqlExpr SqlPersist

PersistEntity a => SqlSelect (SqlExpr (Maybe (Entity a))) (Maybe (Entity a))

PersistField a => SqlSelect (SqlExpr (Single a)) (Single a)

PersistEntity a => SqlSelect (SqlExpr (Entity a)) (Entity a)

select :: (SqlSelect a r, MonadLogger m, MonadResourceBase m) => SqlQuery a -> SqlPersist m [r]

Execute an esqueleto SELECT query inside persistent's SqlPersist monad and return a list of rows.

selectSource :: (SqlSelect a r, MonadLogger m, MonadResourceBase m) => SqlQuery a -> SqlPersist m (Source (ResourceT (SqlPersist m)) r)

Execute an esqueleto SELECT query inside persistent's SqlPersist monad and return a Source of rows.

selectDistinct :: (SqlSelect a r, MonadLogger m, MonadResourceBase m) => SqlQuery a -> SqlPersist m [r]

Execute an esqueleto SELECT DISTINCT query inside persistent's SqlPersist monad and return a list of rows.

selectDistinctSource :: (SqlSelect a r, MonadLogger m, MonadResourceBase m) => SqlQuery a -> SqlPersist m (Source (ResourceT (SqlPersist m)) r)

Execute an esqueleto SELECT DISTINCT query inside persistent's SqlPersist monad and return a Source of rows.

rawSelectSource :: (SqlSelect a r, MonadLogger m, MonadResourceBase m) => Mode -> SqlQuery a -> SqlPersist m (Source (ResourceT (SqlPersist m)) r)

(Internal) Execute an esqueleto SELECT SqlQuery inside persistent's SqlPersist monad.

runSource :: MonadResourceBase m => Source (ResourceT (SqlPersist m)) r -> SqlPersist m [r]

Runs a Source of rows.

rawExecute :: (MonadLogger m, MonadResourceBase m) => Mode -> SqlQuery () -> SqlPersist m ()

(Internal) Execute an esqueleto statement inside persistent's SqlPersist monad.

delete :: (MonadLogger m, MonadResourceBase m) => SqlQuery () -> SqlPersist m ()

Execute an esqueleto DELETE query inside persistent's SqlPersist monad. Note that currently there are no type checks for statements that should not appear on a DELETE query.

Example of usage:

 delete $
 from $ appointment ->
 where_ (appointment ^. AppointmentDate <. val now)

update :: (MonadLogger m, MonadResourceBase m, PersistEntity val, PersistEntityBackend val ~ SqlPersist) => (SqlExpr (Entity val) -> SqlQuery ()) -> SqlPersist m ()

Execute an esqueleto UPDATE query inside persistent's SqlPersist monad. Note that currently there are no type checks for statements that should not appear on a UPDATE query.

Example of usage:

 update $ p -> do
 set p [ PersonAge =. just (val thisYear) -. p ^. PersonBorn ]
 where_ $ isNull (p ^. PersonAge)

toRawSql :: SqlSelect a r => Mode -> Escape -> SqlQuery a -> (Builder, [PersistValue])

Pretty prints a SqlQuery into a SQL query.

data Mode

Constructors

SELECT

SELECT_DISTINCT

DELETE

UPDATE