Database.Esqueleto.Experimental.From.SqlSetOperation

Documentation

newtype SqlSetOperation a

Data type used to implement the SqlSetOperation language this type is implemented in the same way as a From

Semantically a SqlSetOperation is always a From but not vice versa

Since: 3.5.0.0

Constructors

SqlSetOperation

Fields

• unSqlSetOperation :: NeedParens -> SqlQuery (a, IdentInfo -> (Builder, [PersistValue]))

Instances

ToAliasReference a => ToFrom (SqlSetOperation a) a

Defined in Database.Esqueleto.Experimental.From.SqlSetOperation

Methods

toFrom :: SqlSetOperation a -> From a

ToSqlSetOperation (SqlSetOperation a) a

Defined in Database.Esqueleto.Experimental.From.SqlSetOperation

Methods

toSqlSetOperation :: SqlSetOperation a -> SqlSetOperation a

class ToSqlSetOperation a r | a -> r where

Type class to support direct use of SqlQuery in a set operation tree

Since: 3.5.0.0

Methods

toSqlSetOperation :: a -> SqlSetOperation r

Instances

(SqlSelect a r, ToAlias a, ToAliasReference a) => ToSqlSetOperation (SqlQuery a) a

Defined in Database.Esqueleto.Experimental.From.SqlSetOperation

Methods

toSqlSetOperation :: SqlQuery a -> SqlSetOperation a

ToSqlSetOperation (SqlSetOperation a) a

Defined in Database.Esqueleto.Experimental.From.SqlSetOperation

Methods

toSqlSetOperation :: SqlSetOperation a -> SqlSetOperation a

ToSqlSetOperation a a' => ToSqlSetOperation (Intersect a a) a'

Defined in Database.Esqueleto.Experimental.From.SqlSetOperation

Methods

toSqlSetOperation :: Intersect a a -> SqlSetOperation a'

ToSqlSetOperation a a' => ToSqlSetOperation (Except a a) a'

Defined in Database.Esqueleto.Experimental.From.SqlSetOperation

Methods

toSqlSetOperation :: Except a a -> SqlSetOperation a'

ToSqlSetOperation a a' => ToSqlSetOperation (UnionAll a a) a'

Defined in Database.Esqueleto.Experimental.From.SqlSetOperation

Methods

toSqlSetOperation :: UnionAll a a -> SqlSetOperation a'

ToSqlSetOperation a a' => ToSqlSetOperation (Union a a) a'

Defined in Database.Esqueleto.Experimental.From.SqlSetOperation

Methods

toSqlSetOperation :: Union a a -> SqlSetOperation a'

mkSetOperation :: (ToSqlSetOperation a a', ToSqlSetOperation b a') => Builder -> a -> b -> SqlSetOperation a'

Helper function for defining set operations @since 3.5.0.0

data Union a b

Deprecated: Since: 3.4.0.0 - Use the union_ function instead of the Union data constructor

Constructors

a `Union` b

Deprecated: Since: 3.4.0.0 - Use the union_ function instead of the Union data constructor

Instances

ToSqlSetOperation a a' => ToSqlSetOperation (Union a a) a'

Defined in Database.Esqueleto.Experimental.From.SqlSetOperation

Methods

toSqlSetOperation :: Union a a -> SqlSetOperation a'

class Union_ a where

Overloaded union_ function to support use in both SqlSetOperation and withRecursive

Since: 3.5.0.0

Methods

union_ :: a

UNION SQL set operation. Can be used as an infix function between SqlQuery values.

Instances

Union_ UnionKind

Defined in Database.Esqueleto.Experimental.From.CommonTableExpression

Methods

union_ :: UnionKind

(ToSqlSetOperation a c, ToSqlSetOperation b c, res ~ SqlSetOperation c) => Union_ (a -> b -> res)

Defined in Database.Esqueleto.Experimental.From.SqlSetOperation

Methods

union_ :: a -> b -> res

class UnionAll_ a where

Overloaded unionAll_ function to support use in both SqlSetOperation and withRecursive

Since: 3.5.0.0

Methods

unionAll_ :: a

UNION ALL SQL set operation. Can be used as an infix function between SqlQuery values.

Instances

UnionAll_ UnionKind

Defined in Database.Esqueleto.Experimental.From.CommonTableExpression

Methods

unionAll_ :: UnionKind

(ToSqlSetOperation a c, ToSqlSetOperation b c, res ~ SqlSetOperation c) => UnionAll_ (a -> b -> res)

Defined in Database.Esqueleto.Experimental.From.SqlSetOperation

Methods

unionAll_ :: a -> b -> res

data UnionAll a b

Deprecated: Since: 3.4.0.0 - Use the unionAll_ function instead of the UnionAll data constructor

Constructors

a `UnionAll` b

Deprecated: Since: 3.4.0.0 - Use the unionAll_ function instead of the UnionAll data constructor

Instances

ToSqlSetOperation a a' => ToSqlSetOperation (UnionAll a a) a'

Defined in Database.Esqueleto.Experimental.From.SqlSetOperation

Methods

toSqlSetOperation :: UnionAll a a -> SqlSetOperation a'

data Except a b

Deprecated: Since: 3.4.0.0 - Use the except_ function instead of the Except data constructor

Constructors

a `Except` b

Deprecated: Since: 3.4.0.0 - Use the except_ function instead of the Except data constructor

Instances

ToSqlSetOperation a a' => ToSqlSetOperation (Except a a) a'

Defined in Database.Esqueleto.Experimental.From.SqlSetOperation

Methods

toSqlSetOperation :: Except a a -> SqlSetOperation a'

except_ :: (ToSqlSetOperation a a', ToSqlSetOperation b a') => a -> b -> SqlSetOperation a'

EXCEPT SQL set operation. Can be used as an infix function between SqlQuery values.

data Intersect a b

Deprecated: Since: 3.4.0.0 - Use the intersect_ function instead of the Intersect data constructor

Constructors

a `Intersect` b

Deprecated: Since: 3.4.0.0 - Use the intersect_ function instead of the Intersect data constructor

Instances

ToSqlSetOperation a a' => ToSqlSetOperation (Intersect a a) a'

Defined in Database.Esqueleto.Experimental.From.SqlSetOperation

Methods

toSqlSetOperation :: Intersect a a -> SqlSetOperation a'

intersect_ :: (ToSqlSetOperation a a', ToSqlSetOperation b a') => a -> b -> SqlSetOperation a'

INTERSECT SQL set operation. Can be used as an infix function between SqlQuery values.

pattern SelectQuery :: p -> p

Deprecated: Since: 3.4.0.0 - It is no longer necessary to tag SqlQuery values with SelectQuery