Database.Relational.Query.Component

This module provides untyped components for query.

Type for column SQL string

type ColumnSQL = ColumnSQL

Deprecated: prepare to drop public interface. internally use Database.Relational.Query.Internal.SQL.*

Column SQL string type

columnSQL :: String -> ColumnSQL

Deprecated: prepare to drop public interface. internally use Database.Relational.Query.Internal.SQL.*

ColumnSQL from string

columnSQL' :: StringSQL -> ColumnSQL

Deprecated: prepare to drop public interface. internally use Database.Relational.Query.Internal.SQL.*

ColumnSQL from StringSQL

showsColumnSQL :: ColumnSQL -> StringSQL

Deprecated: prepare to drop public interface. internally use Database.Relational.Query.Internal.SQL.*

StringSQL from ColumnSQL

Configuration type for query

data NameConfig

NameConfig type to customize names of expanded templates.

Constructors

NameConfig

Fields

• recordConfig :: NameConfig
• relationVarName :: String -> String -> VarName

Instances

Show NameConfig

Methods

showsPrec :: Int -> NameConfig -> ShowS

show :: NameConfig -> String

showList :: [NameConfig] -> ShowS

data ProductUnitSupport

Unit of product is supported or not.

Constructors

PUSupported

PUNotSupported

Instances

Show ProductUnitSupport

Methods

showsPrec :: Int -> ProductUnitSupport -> ShowS

show :: ProductUnitSupport -> String

showList :: [ProductUnitSupport] -> ShowS

data SchemaNameMode

Schema name qualify mode in SQL string.

Constructors

SchemaQualified

Schema qualified table name in SQL string

SchemaNotQualified

Not qualified table name in SQL string

Instances

Eq SchemaNameMode

Methods

(==) :: SchemaNameMode -> SchemaNameMode -> Bool

(/=) :: SchemaNameMode -> SchemaNameMode -> Bool

Show SchemaNameMode

Methods

showsPrec :: Int -> SchemaNameMode -> ShowS

show :: SchemaNameMode -> String

showList :: [SchemaNameMode] -> ShowS

data IdentifierQuotation

Configuration for quotation of identifiers of SQL.

Constructors

NoQuotation

Quotation Char

Instances

Show IdentifierQuotation

Methods

showsPrec :: Int -> IdentifierQuotation -> ShowS

show :: IdentifierQuotation -> String

showList :: [IdentifierQuotation] -> ShowS

data Config

Configuration type.

Instances

Show Config

Methods

showsPrec :: Int -> Config -> ShowS

show :: Config -> String

showList :: [Config] -> ShowS

defaultConfig :: Config

Default configuration.

Duplication attribute

data Duplication

Result record duplication attribute

Constructors

All

Distinct

Instances

Show Duplication

Methods

showsPrec :: Int -> Duplication -> ShowS

show :: Duplication -> String

showList :: [Duplication] -> ShowS

showsDuplication :: Duplication -> StringSQL

Deprecated: prepare to drop public interface. internally use Database.Relational.Query.Internal.BaseSQL.showsDuplication

Compose duplication attribute string.

Types for aggregation

data AggregateKey a

Typeful aggregate element.

type AggregateColumnRef = AggregateColumnRef

Deprecated: prepare to drop public interface. internally use Database.Relational.Query.Internal.GroupingSQL.*

Type for group-by term

type AggregateBitKey = AggregateBitKey

Deprecated: prepare to drop public interface. internally use Database.Relational.Query.Internal.GroupingSQL.*

Type for group key.

type AggregateSet = AggregateSet

Deprecated: prepare to drop public interface. internally use Database.Relational.Query.Internal.GroupingSQL.*

Type for grouping set

type AggregateElem = AggregateElem

Deprecated: prepare to drop public interface. internally use Database.Relational.Query.Internal.GroupingSQL.*

Type for group-by tree

aggregateColumnRef :: AggregateColumnRef -> AggregateElem

Deprecated: prepare to drop public interface. internally use Database.Relational.Query.Internal.GroupingSQL.*

Single term aggregation element.

aggregateEmpty :: [AggregateElem]

Deprecated: prepare to drop public interface. internally use Database.Relational.Query.Internal.GroupingSQL.*

Empty aggregation.

aggregatePowerKey :: [AggregateColumnRef] -> AggregateBitKey

Deprecated: prepare to drop public interface. internally use Database.Relational.Query.Internal.GroupingSQL.*

Key of aggregation power set.

aggregateGroupingSet :: [AggregateElem] -> AggregateSet

Deprecated: prepare to drop public interface. internally use Database.Relational.Query.Internal.GroupingSQL.*

Single grouping set.

aggregateRollup :: [AggregateBitKey] -> AggregateElem

Deprecated: prepare to drop public interface. internally use Database.Relational.Query.Internal.GroupingSQL.*

Rollup aggregation element.

aggregateCube :: [AggregateBitKey] -> AggregateElem

Deprecated: prepare to drop public interface. internally use Database.Relational.Query.Internal.GroupingSQL.*

Cube aggregation element.

aggregateSets :: [AggregateSet] -> AggregateElem

Deprecated: prepare to drop public interface. internally use Database.Relational.Query.Internal.GroupingSQL.*

Grouping sets aggregation.

composeGroupBy :: [AggregateElem] -> StringSQL

Deprecated: prepare to drop public interface. internally use Database.Relational.Query.Internal.GroupingSQL.*

Compose GROUP BY clause from AggregateElem list.

composePartitionBy :: [AggregateColumnRef] -> StringSQL

Deprecated: prepare to drop public interface. internally use Database.Relational.Query.Internal.GroupingSQL.*

Compose PARTITION BY clause from AggregateColumnRef list.

aggregateKeyProjection :: AggregateKey a -> a

Deprecated: prepare to drop public interface. internally use Database.Relational.Query.Internal.GroupingSQL.*

Extract typed projection from AggregateKey.

aggregateKeyElement :: AggregateKey a -> AggregateElem

Deprecated: prepare to drop public interface. internally use Database.Relational.Query.Internal.GroupingSQL.*

Extract untyped term from AggregateKey.

unsafeAggregateKey :: (a, AggregateElem) -> AggregateKey a

Deprecated: prepare to drop public interface. internally use Database.Relational.Query.Internal.GroupingSQL.*

Unsafely bind typed-projection and untyped-term into AggregateKey.

Types for ordering

data Order

Order direction. Ascendant or Descendant.

Constructors

Asc

Desc

Instances

Show Order

Methods

showsPrec :: Int -> Order -> ShowS

show :: Order -> String

showList :: [Order] -> ShowS

type OrderColumn = OrderColumn

Deprecated: prepare to drop public interface. internally use Database.Relational.Query.Internal.BaseSQL.*

Type for order-by column

type OrderingTerm = OrderingTerm

Deprecated: prepare to drop public interface. internally use Database.Relational.Query.Internal.BaseSQL.*

Type for order-by term

composeOrderBy :: [OrderingTerm] -> StringSQL

Deprecated: prepare to drop public interface. internally use Database.Relational.Query.Internal.BaseSQL.*

Compose ORDER BY clause from OrderingTerms

type OrderingTerms = [OrderingTerm]

Deprecated: use [OrderingTerm].

Type for order-by terms

Types for assignments

type AssignColumn = AssignColumn

Deprecated: prepare to drop public interface. internally use Database.Relational.Query.Internal.BaseSQL.*

Column SQL String of assignment

type AssignTerm = AssignTerm

Deprecated: prepare to drop public interface. internally use Database.Relational.Query.Internal.BaseSQL.*

Value SQL String of assignment

type Assignment = Assignment

Deprecated: prepare to drop public interface. internally use Database.Relational.Query.Internal.BaseSQL.*

Assignment pair

composeSets :: [Assignment] -> StringSQL

Deprecated: prepare to drop public interface. internally use Database.Relational.Query.Internal.BaseSQL.*

Compose SET clause from [Assignment].

composeValues :: [Assignment] -> StringSQL

Deprecated: prepare to drop public interface. internally use Database.Relational.Query.Internal.BaseSQL.*

Compose VALUES clause from [Assignment].

type Assignments = [Assignment]

Deprecated: use [Assignment].

Assignment pair list.

Compose window clause

composeOver :: [AggregateColumnRef] -> OrderingTerms -> StringSQL

Deprecated: prepare to drop public interface.

Compose OVER (PARTITION BY ... ) clause.