| Copyright | 2013 Kei Hibino |
|---|---|
| License | BSD3 |
| Maintainer | ex8k.hibino@gmail.com |
| Stability | experimental |
| Portability | unknown |
| Safe Haskell | None |
| Language | Haskell2010 |
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 p r = OrderedQuery Aggregated (Restrictings Aggregated (AggregatingSetT QueryCore)) p r
- toSQL :: AggregatedQuery p r -> ConfigureQuery String
- toSubQuery :: AggregatedQuery p r -> ConfigureQuery SubQuery
- type Window c = Orderings c (PartitioningSet 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 p r = OrderedQuery Aggregated (Restrictings Aggregated (AggregatingSetT QueryCore)) p r Source
Aggregated query type. AggregatedQuery p r == QueryAggregate (PlaceHolders p, Projection Aggregated r).
Arguments
| :: AggregatedQuery p r |
|
| -> ConfigureQuery String | Result SQL string with |
Run AggregatedQuery to get SQL with ConfigureQuery computation.
Arguments
| :: AggregatedQuery p 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.
over :: SqlProjectable (Projection c) => Projection OverWindow a -> Window c () -> Projection c a infix 8 Source
Operator to make window function result projection using built Window monad.