Database.Relational.Query.Monad.Class

This module defines query building interface classes.

Query interface classes

class (Functor q, Monad q, Functor m, Monad m) => MonadQualify q m where

Lift interface from base qualify monad.

Methods

liftQualify :: q a -> m a

Lift from qualify monad q into MonadQuery m. Qualify monad qualifies table form SubQuery.

Instances

(Functor q, Monad q) => MonadQualify q q

MonadQualify ConfigureQuery QueryUnique

MonadQualify q m => MonadQualify q (AggregatingSetT m)

Aggregated MonadQualify.

MonadQualify q m => MonadQualify q (QueryJoin m)

MonadQualify q m => MonadQualify q (Orderings c m)

MonadQualify with ordering.

MonadQualify q m => MonadQualify q (Assignings r m)

MonadQualify with assigning.

MonadQualify q m => MonadQualify q (Restrictings c m)

Restricted MonadQualify instance.

class (Functor m, Monad m) => MonadRestrict c m where

Restrict context interface

Methods

restrict

Arguments

:: Projection c (Maybe Bool)

Projection which represent restriction

-> m ()

Restricted query context

Add restriction to this context.

Instances

MonadRestrict c m => MonadRestrict c (AggregatingSetT m)

Aggregated MonadRestrict.

MonadRestrict rc m => MonadRestrict rc (Orderings c m)

MonadRestrict with ordering.

MonadRestrict c m => MonadRestrict c (Assignings r m)

MonadRestrict with assigning.

(Monad q, Functor q) => MonadRestrict c (Restrictings c q)

MonadRestrict instance.

class (Functor m, Monad m, MonadQualify ConfigureQuery m) => MonadQuery m where

Query building interface.

Methods

setDuplication :: Duplication -> m ()

Specify duplication.

restrictJoin

Arguments

:: Projection Flat (Maybe Bool)

Projection which represent restriction

-> m ()

Restricted query context

Add restriction to last join.

query' :: Relation p r -> m (PlaceHolders p, Projection Flat r)

Join sub-query with place-holder parameter p. query result is not Maybe.

queryMaybe' :: Relation p r -> m (PlaceHolders p, Projection Flat (Maybe r))

Join sub-query with place-holder parameter p. Query result is Maybe.

Instances

MonadQuery QueryUnique

MonadQuery m => MonadQuery (AggregatingSetT m)

Aggregated MonadQuery.

MonadQuery (QueryJoin ConfigureQuery)

Joinable query instance.

MonadQuery m => MonadQuery (Orderings c m)

MonadQuery with ordering.

MonadQuery q => MonadQuery (Restrictings c q)

Restricted MonadQuery instance.

class MonadQuery m => MonadAggregate m where

Aggregated query building interface extends MonadQuery.

Methods

groupBy

Arguments

:: Projection Flat r

Projection to add into group by

-> m (Projection Aggregated r)

Result context and aggregated projection | Add GROUP BY term into context and get aggregated projection. Non-traditional group-by version.

Add GROUP BY term into context and get aggregated projection.

groupBy'

Arguments

:: AggregateKey (Projection Aggregated r)

Key to aggretate for non-traditional group-by interface

-> m (Projection Aggregated r)

Result context and aggregated projection

Instances

MonadQuery m => MonadAggregate (AggregatingSetT m)

Aggregated query instance.

MonadAggregate m => MonadAggregate (Orderings c m)

MonadAggregate with ordering.

MonadAggregate m => MonadAggregate (Restrictings c m)

Resticted MonadAggregate instance.

class Monad m => MonadPartition c m where

Window specification building interface.

Methods

partitionBy :: Projection c r -> m ()

Add PARTITION BY term into context.

Instances

Monad m => MonadPartition c (PartitioningSetT c m)

Partition clause instance

MonadPartition c m => MonadPartition c (Orderings c m)

MonadPartition with ordering.

all' :: MonadQuery m => m ()

Specify ALL attribute to query context.

distinct :: MonadQuery m => m ()

Specify DISTINCT attribute to query context.

on :: MonadQuery m => Projection Flat (Maybe Bool) -> m ()

Add restriction to last join. Projection type version.

wheres :: MonadRestrict Flat m => Projection Flat (Maybe Bool) -> m ()

Add restriction to this not aggregated query.

having :: MonadRestrict Aggregated m => Projection Aggregated (Maybe Bool) -> m ()

Add restriction to this aggregated query. Aggregated Projection type version.