| Portability | unknown |
|---|---|
| Stability | experimental |
| Maintainer | ex8k.hibino@gmail.com |
| Safe Haskell | None |
Database.Relational.Query.Monad.Aggregate
Contents
Description
This module contains definitions about aggregated query type.
- type QueryAggregate = Orderings Aggregated (Restrictings Aggregated (AggregatingSetT QueryCore))
- type AggregatedQuery r = OrderedQuery Aggregated (Restrictings Aggregated (AggregatingSetT QueryCore)) r
- toSQL :: AggregatedQuery r -> ConfigureQuery String
- toSubQuery :: AggregatedQuery r -> ConfigureQuery SubQuery
- type Window c = Orderings c (PartitioningSet c)
- partitionBy :: Projection c r -> Window c ()
- over :: SqlProjectable (Projection c) => Projection OverWindow a -> Window c () -> Projection c a
Aggregated Query
type QueryAggregate = Orderings Aggregated (Restrictings Aggregated (AggregatingSetT QueryCore))Source
Aggregated query monad type.
type AggregatedQuery r = OrderedQuery Aggregated (Restrictings Aggregated (AggregatingSetT QueryCore)) rSource
Aggregated query type. AggregatedQuery r == QueryAggregate (Projection Aggregated r).
Arguments
| :: AggregatedQuery r |
|
| -> ConfigureQuery String | Result SQL string with |
Run AggregatedQuery to get SQL with ConfigureQuery computation.
Arguments
| :: AggregatedQuery r |
|
| -> ConfigureQuery SubQuery | Result |
Run AggregatedQuery to get SubQuery with ConfigureQuery computation.
type Window c = Orderings c (PartitioningSet c)Source
Partition monad type for partition-by clause.
partitionBy :: Projection c r -> Window c ()Source
Add PARTITION BY term into context.
over :: SqlProjectable (Projection c) => Projection OverWindow a -> Window c () -> Projection c aSource
Operator to make window function projection.