{-# LANGUAGE FlexibleContexts #-}
{-# LANGUAGE MultiParamTypeClasses #-}
module Opaleye.FunctionalJoin (
fullJoinF,
joinF,
leftJoinF,
rightJoinF,
) where
import Control.Applicative ((<$>), (<*>))
import Control.Arrow ((<<<))
import qualified Data.Profunctor.Product.Default as D
import qualified Data.Profunctor.Product as PP
import qualified Opaleye.Field as C
import qualified Opaleye.Field as F
import qualified Opaleye.Internal.Join as IJ
import qualified Opaleye.Internal.Operators as IO
import qualified Opaleye.Internal.Unpackspec as IU
import qualified Opaleye.Join as J
import qualified Opaleye.Select as S
import qualified Opaleye.SqlTypes as T
import qualified Opaleye.Operators as O
{-# DEPRECATED joinF "Use 'Opaleye.Operators.where_' and @do@ notation instead. Will be removed in 0.10." #-}
joinF :: (fieldsL -> fieldsR -> fieldsResult)
-> (fieldsL -> fieldsR -> F.Field T.SqlBool)
-> S.Select fieldsL
-> S.Select fieldsR
-> S.Select fieldsResult
joinF :: (fieldsL -> fieldsR -> fieldsResult)
-> (fieldsL -> fieldsR -> Field SqlBool)
-> Select fieldsL
-> Select fieldsR
-> Select fieldsResult
joinF fieldsL -> fieldsR -> fieldsResult
f fieldsL -> fieldsR -> Field SqlBool
cond Select fieldsL
l Select fieldsR
r =
((fieldsL, fieldsR) -> fieldsResult)
-> SelectArr () (fieldsL, fieldsR) -> Select fieldsResult
forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
fmap ((fieldsL -> fieldsR -> fieldsResult)
-> (fieldsL, fieldsR) -> fieldsResult
forall a b c. (a -> b -> c) -> (a, b) -> c
uncurry fieldsL -> fieldsR -> fieldsResult
f) (((fieldsL, fieldsR) -> Field SqlBool)
-> SelectArr (fieldsL, fieldsR) (fieldsL, fieldsR)
forall a. (a -> Field SqlBool) -> SelectArr a a
O.keepWhen ((fieldsL -> fieldsR -> Field SqlBool)
-> (fieldsL, fieldsR) -> Field SqlBool
forall a b c. (a -> b -> c) -> (a, b) -> c
uncurry fieldsL -> fieldsR -> Field SqlBool
cond) SelectArr (fieldsL, fieldsR) (fieldsL, fieldsR)
-> SelectArr () (fieldsL, fieldsR)
-> SelectArr () (fieldsL, fieldsR)
forall k (cat :: k -> k -> *) (b :: k) (c :: k) (a :: k).
Category cat =>
cat b c -> cat a b -> cat a c
<<< ((,) (fieldsL -> fieldsR -> (fieldsL, fieldsR))
-> Select fieldsL -> SelectArr () (fieldsR -> (fieldsL, fieldsR))
forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
<$> Select fieldsL
l SelectArr () (fieldsR -> (fieldsL, fieldsR))
-> Select fieldsR -> SelectArr () (fieldsL, fieldsR)
forall (f :: * -> *) a b. Applicative f => f (a -> b) -> f a -> f b
<*> Select fieldsR
r))
{-# DEPRECATED leftJoinF "Use 'Opaleye.Join.optional' instead. Will be removed in 0.10." #-}
leftJoinF :: (D.Default IO.IfPP fieldsResult fieldsResult,
D.Default IU.Unpackspec fieldsL fieldsL,
D.Default IU.Unpackspec fieldsR fieldsR)
=> (fieldsL -> fieldsR -> fieldsResult)
-> (fieldsL -> fieldsResult)
-> (fieldsL -> fieldsR -> F.Field T.SqlBool)
-> S.Select fieldsL
-> S.Select fieldsR
-> S.Select fieldsResult
leftJoinF :: (fieldsL -> fieldsR -> fieldsResult)
-> (fieldsL -> fieldsResult)
-> (fieldsL -> fieldsR -> Field SqlBool)
-> Select fieldsL
-> Select fieldsR
-> Select fieldsResult
leftJoinF fieldsL -> fieldsR -> fieldsResult
f fieldsL -> fieldsResult
fL fieldsL -> fieldsR -> Field SqlBool
cond Select fieldsL
l Select fieldsR
r = ((fieldsL, (fieldsR, FieldNullable SqlBool)) -> fieldsResult)
-> SelectArr () (fieldsL, (fieldsR, FieldNullable SqlBool))
-> Select fieldsResult
forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
fmap (fieldsL, (fieldsR, FieldNullable SqlBool)) -> fieldsResult
forall a. (fieldsL, (fieldsR, FieldNullable a)) -> fieldsResult
ret SelectArr () (fieldsL, (fieldsR, FieldNullable SqlBool))
j
where a1 :: SelectArr () a -> SelectArr () (a, Field SqlBool)
a1 = (a -> (a, Field SqlBool))
-> SelectArr () a -> SelectArr () (a, Field SqlBool)
forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
fmap (\a
x -> (a
x, Bool -> Field SqlBool
T.sqlBool Bool
True))
j :: SelectArr () (fieldsL, (fieldsR, FieldNullable SqlBool))
j = Unpackspec fieldsL fieldsL
-> Unpackspec (fieldsR, Field SqlBool) (fieldsR, Field SqlBool)
-> NullMaker
(fieldsR, Field SqlBool) (fieldsR, FieldNullable SqlBool)
-> Select fieldsL
-> Select (fieldsR, Field SqlBool)
-> ((fieldsL, (fieldsR, Field SqlBool)) -> Field SqlBool)
-> SelectArr () (fieldsL, (fieldsR, FieldNullable SqlBool))
forall fieldsL fieldsR nullableFieldsR.
Unpackspec fieldsL fieldsL
-> Unpackspec fieldsR fieldsR
-> NullMaker fieldsR nullableFieldsR
-> Select fieldsL
-> Select fieldsR
-> ((fieldsL, fieldsR) -> Field SqlBool)
-> Select (fieldsL, nullableFieldsR)
J.leftJoinExplicit Unpackspec fieldsL fieldsL
forall (p :: * -> * -> *) a b. Default p a b => p a b
D.def
Unpackspec (fieldsR, Field SqlBool) (fieldsR, Field SqlBool)
forall (p :: * -> * -> *) a b. Default p a b => p a b
D.def
((NullMaker fieldsR fieldsR,
NullMaker (Field SqlBool) (FieldNullable SqlBool))
-> NullMaker
(fieldsR, Field SqlBool) (fieldsR, FieldNullable SqlBool)
forall (p :: * -> * -> *) a0 a1 b0 b1.
ProductProfunctor p =>
(p a0 b0, p a1 b1) -> p (a0, a1) (b0, b1)
PP.p2 ((fieldsR -> fieldsR) -> NullMaker fieldsR fieldsR
forall a b. (a -> b) -> NullMaker a b
IJ.NullMaker fieldsR -> fieldsR
forall a. a -> a
id, NullMaker (Field SqlBool) (FieldNullable SqlBool)
nullmakerBool))
Select fieldsL
l
(Select fieldsR -> Select (fieldsR, Field SqlBool)
forall a. SelectArr () a -> SelectArr () (a, Field SqlBool)
a1 Select fieldsR
r)
(\(fieldsL
l', (fieldsR
r', Field SqlBool
_)) -> fieldsL -> fieldsR -> Field SqlBool
cond fieldsL
l' fieldsR
r')
ret :: (fieldsL, (fieldsR, FieldNullable a)) -> fieldsResult
ret (fieldsL
lr, (fieldsR
rr, FieldNullable a
rc)) = Field SqlBool -> fieldsResult -> fieldsResult -> fieldsResult
forall fields.
Default IfPP fields fields =>
Field SqlBool -> fields -> fields -> fields
O.ifThenElseMany (FieldNullable a -> Field SqlBool
forall a. FieldNullable a -> Field SqlBool
C.isNull FieldNullable a
rc) (fieldsL -> fieldsResult
fL fieldsL
lr) (fieldsL -> fieldsR -> fieldsResult
f fieldsL
lr fieldsR
rr)
nullmakerBool :: IJ.NullMaker (F.Field T.SqlBool)
(F.FieldNullable T.SqlBool)
nullmakerBool :: NullMaker (Field SqlBool) (FieldNullable SqlBool)
nullmakerBool = NullMaker (Field SqlBool) (FieldNullable SqlBool)
forall (p :: * -> * -> *) a b. Default p a b => p a b
D.def
{-# DEPRECATED rightJoinF "Use 'Opaleye.Join.optional' instead. Will be removed in 0.10." #-}
rightJoinF :: (D.Default IO.IfPP fieldsResult fieldsResult,
D.Default IU.Unpackspec fieldsL fieldsL,
D.Default IU.Unpackspec fieldsR fieldsR)
=> (fieldsL -> fieldsR -> fieldsResult)
-> (fieldsR -> fieldsResult)
-> (fieldsL -> fieldsR -> F.Field T.SqlBool)
-> S.Select fieldsL
-> S.Select fieldsR
-> S.Select fieldsResult
rightJoinF :: (fieldsL -> fieldsR -> fieldsResult)
-> (fieldsR -> fieldsResult)
-> (fieldsL -> fieldsR -> Field SqlBool)
-> Select fieldsL
-> Select fieldsR
-> Select fieldsResult
rightJoinF fieldsL -> fieldsR -> fieldsResult
f fieldsR -> fieldsResult
fR fieldsL -> fieldsR -> Field SqlBool
cond Select fieldsL
l Select fieldsR
r = (((fieldsL, FieldNullable SqlBool), fieldsR) -> fieldsResult)
-> SelectArr () ((fieldsL, FieldNullable SqlBool), fieldsR)
-> Select fieldsResult
forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
fmap ((fieldsL, FieldNullable SqlBool), fieldsR) -> fieldsResult
forall a. ((fieldsL, FieldNullable a), fieldsR) -> fieldsResult
ret SelectArr () ((fieldsL, FieldNullable SqlBool), fieldsR)
j
where a1 :: SelectArr () a -> SelectArr () (a, Field SqlBool)
a1 = (a -> (a, Field SqlBool))
-> SelectArr () a -> SelectArr () (a, Field SqlBool)
forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
fmap (\a
x -> (a
x, Bool -> Field SqlBool
T.sqlBool Bool
True))
j :: SelectArr () ((fieldsL, FieldNullable SqlBool), fieldsR)
j = Unpackspec (fieldsL, Field SqlBool) (fieldsL, Field SqlBool)
-> Unpackspec fieldsR fieldsR
-> NullMaker
(fieldsL, Field SqlBool) (fieldsL, FieldNullable SqlBool)
-> Select (fieldsL, Field SqlBool)
-> Select fieldsR
-> (((fieldsL, Field SqlBool), fieldsR) -> Field SqlBool)
-> SelectArr () ((fieldsL, FieldNullable SqlBool), fieldsR)
forall fieldsL fieldsR nullableFieldsL.
Unpackspec fieldsL fieldsL
-> Unpackspec fieldsR fieldsR
-> NullMaker fieldsL nullableFieldsL
-> Select fieldsL
-> Select fieldsR
-> ((fieldsL, fieldsR) -> Field SqlBool)
-> Select (nullableFieldsL, fieldsR)
J.rightJoinExplicit Unpackspec (fieldsL, Field SqlBool) (fieldsL, Field SqlBool)
forall (p :: * -> * -> *) a b. Default p a b => p a b
D.def
Unpackspec fieldsR fieldsR
forall (p :: * -> * -> *) a b. Default p a b => p a b
D.def
((NullMaker fieldsL fieldsL,
NullMaker (Field SqlBool) (FieldNullable SqlBool))
-> NullMaker
(fieldsL, Field SqlBool) (fieldsL, FieldNullable SqlBool)
forall (p :: * -> * -> *) a0 a1 b0 b1.
ProductProfunctor p =>
(p a0 b0, p a1 b1) -> p (a0, a1) (b0, b1)
PP.p2 ((fieldsL -> fieldsL) -> NullMaker fieldsL fieldsL
forall a b. (a -> b) -> NullMaker a b
IJ.NullMaker fieldsL -> fieldsL
forall a. a -> a
id, NullMaker (Field SqlBool) (FieldNullable SqlBool)
nullmakerBool))
(Select fieldsL -> Select (fieldsL, Field SqlBool)
forall a. SelectArr () a -> SelectArr () (a, Field SqlBool)
a1 Select fieldsL
l)
Select fieldsR
r
(\((fieldsL
l', Field SqlBool
_), fieldsR
r') -> fieldsL -> fieldsR -> Field SqlBool
cond fieldsL
l' fieldsR
r')
ret :: ((fieldsL, FieldNullable a), fieldsR) -> fieldsResult
ret ((fieldsL
lr, FieldNullable a
lc), fieldsR
rr) = Field SqlBool -> fieldsResult -> fieldsResult -> fieldsResult
forall fields.
Default IfPP fields fields =>
Field SqlBool -> fields -> fields -> fields
O.ifThenElseMany (FieldNullable a -> Field SqlBool
forall a. FieldNullable a -> Field SqlBool
C.isNull FieldNullable a
lc) (fieldsR -> fieldsResult
fR fieldsR
rr) (fieldsL -> fieldsR -> fieldsResult
f fieldsL
lr fieldsR
rr)
nullmakerBool :: IJ.NullMaker (F.Field T.SqlBool)
(F.FieldNullable T.SqlBool)
nullmakerBool :: NullMaker (Field SqlBool) (FieldNullable SqlBool)
nullmakerBool = NullMaker (Field SqlBool) (FieldNullable SqlBool)
forall (p :: * -> * -> *) a b. Default p a b => p a b
D.def
fullJoinF :: (D.Default IO.IfPP fieldsResult fieldsResult,
D.Default IU.Unpackspec fieldsL fieldsL,
D.Default IU.Unpackspec fieldsR fieldsR)
=> (fieldsL -> fieldsR -> fieldsResult)
-> (fieldsL -> fieldsResult)
-> (fieldsR -> fieldsResult)
-> (fieldsL -> fieldsR -> F.Field T.SqlBool)
-> S.Select fieldsL
-> S.Select fieldsR
-> S.Select fieldsResult
fullJoinF :: (fieldsL -> fieldsR -> fieldsResult)
-> (fieldsL -> fieldsResult)
-> (fieldsR -> fieldsResult)
-> (fieldsL -> fieldsR -> Field SqlBool)
-> Select fieldsL
-> Select fieldsR
-> Select fieldsResult
fullJoinF fieldsL -> fieldsR -> fieldsResult
f fieldsL -> fieldsResult
fL fieldsR -> fieldsResult
fR fieldsL -> fieldsR -> Field SqlBool
cond Select fieldsL
l Select fieldsR
r = (((fieldsL, FieldNullable SqlBool),
(fieldsR, FieldNullable SqlBool))
-> fieldsResult)
-> SelectArr
()
((fieldsL, FieldNullable SqlBool),
(fieldsR, FieldNullable SqlBool))
-> Select fieldsResult
forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
fmap ((fieldsL, FieldNullable SqlBool),
(fieldsR, FieldNullable SqlBool))
-> fieldsResult
forall a a.
((fieldsL, FieldNullable a), (fieldsR, FieldNullable a))
-> fieldsResult
ret SelectArr
()
((fieldsL, FieldNullable SqlBool),
(fieldsR, FieldNullable SqlBool))
j
where a1 :: SelectArr () a -> SelectArr () (a, Field SqlBool)
a1 = (a -> (a, Field SqlBool))
-> SelectArr () a -> SelectArr () (a, Field SqlBool)
forall (f :: * -> *) a b. Functor f => (a -> b) -> f a -> f b
fmap (\a
x -> (a
x, Bool -> Field SqlBool
T.sqlBool Bool
True))
j :: SelectArr
()
((fieldsL, FieldNullable SqlBool),
(fieldsR, FieldNullable SqlBool))
j = Unpackspec (fieldsL, Field SqlBool) (fieldsL, Field SqlBool)
-> Unpackspec (fieldsR, Field SqlBool) (fieldsR, Field SqlBool)
-> NullMaker
(fieldsL, Field SqlBool) (fieldsL, FieldNullable SqlBool)
-> NullMaker
(fieldsR, Field SqlBool) (fieldsR, FieldNullable SqlBool)
-> Select (fieldsL, Field SqlBool)
-> Select (fieldsR, Field SqlBool)
-> (((fieldsL, Field SqlBool), (fieldsR, Field SqlBool))
-> Field SqlBool)
-> SelectArr
()
((fieldsL, FieldNullable SqlBool),
(fieldsR, FieldNullable SqlBool))
forall fieldsL fieldsR nullableFieldsL nullableFieldsR.
Unpackspec fieldsL fieldsL
-> Unpackspec fieldsR fieldsR
-> NullMaker fieldsL nullableFieldsL
-> NullMaker fieldsR nullableFieldsR
-> Select fieldsL
-> Select fieldsR
-> ((fieldsL, fieldsR) -> Field SqlBool)
-> Select (nullableFieldsL, nullableFieldsR)
J.fullJoinExplicit Unpackspec (fieldsL, Field SqlBool) (fieldsL, Field SqlBool)
forall (p :: * -> * -> *) a b. Default p a b => p a b
D.def
Unpackspec (fieldsR, Field SqlBool) (fieldsR, Field SqlBool)
forall (p :: * -> * -> *) a b. Default p a b => p a b
D.def
((NullMaker fieldsL fieldsL,
NullMaker (Field SqlBool) (FieldNullable SqlBool))
-> NullMaker
(fieldsL, Field SqlBool) (fieldsL, FieldNullable SqlBool)
forall (p :: * -> * -> *) a0 a1 b0 b1.
ProductProfunctor p =>
(p a0 b0, p a1 b1) -> p (a0, a1) (b0, b1)
PP.p2 ((fieldsL -> fieldsL) -> NullMaker fieldsL fieldsL
forall a b. (a -> b) -> NullMaker a b
IJ.NullMaker fieldsL -> fieldsL
forall a. a -> a
id, NullMaker (Field SqlBool) (FieldNullable SqlBool)
nullmakerBool))
((NullMaker fieldsR fieldsR,
NullMaker (Field SqlBool) (FieldNullable SqlBool))
-> NullMaker
(fieldsR, Field SqlBool) (fieldsR, FieldNullable SqlBool)
forall (p :: * -> * -> *) a0 a1 b0 b1.
ProductProfunctor p =>
(p a0 b0, p a1 b1) -> p (a0, a1) (b0, b1)
PP.p2 ((fieldsR -> fieldsR) -> NullMaker fieldsR fieldsR
forall a b. (a -> b) -> NullMaker a b
IJ.NullMaker fieldsR -> fieldsR
forall a. a -> a
id, NullMaker (Field SqlBool) (FieldNullable SqlBool)
nullmakerBool))
(Select fieldsL -> Select (fieldsL, Field SqlBool)
forall a. SelectArr () a -> SelectArr () (a, Field SqlBool)
a1 Select fieldsL
l)
(Select fieldsR -> Select (fieldsR, Field SqlBool)
forall a. SelectArr () a -> SelectArr () (a, Field SqlBool)
a1 Select fieldsR
r)
(\((fieldsL
l', Field SqlBool
_), (fieldsR
r', Field SqlBool
_)) -> fieldsL -> fieldsR -> Field SqlBool
cond fieldsL
l' fieldsR
r')
ret :: ((fieldsL, FieldNullable a), (fieldsR, FieldNullable a))
-> fieldsResult
ret ((fieldsL
lr, FieldNullable a
lc), (fieldsR
rr, FieldNullable a
rc)) = Field SqlBool -> fieldsResult -> fieldsResult -> fieldsResult
forall fields.
Default IfPP fields fields =>
Field SqlBool -> fields -> fields -> fields
O.ifThenElseMany (FieldNullable a -> Field SqlBool
forall a. FieldNullable a -> Field SqlBool
C.isNull FieldNullable a
lc)
(fieldsR -> fieldsResult
fR fieldsR
rr)
(Field SqlBool -> fieldsResult -> fieldsResult -> fieldsResult
forall fields.
Default IfPP fields fields =>
Field SqlBool -> fields -> fields -> fields
O.ifThenElseMany (FieldNullable a -> Field SqlBool
forall a. FieldNullable a -> Field SqlBool
C.isNull FieldNullable a
rc)
(fieldsL -> fieldsResult
fL fieldsL
lr)
(fieldsL -> fieldsR -> fieldsResult
f fieldsL
lr fieldsR
rr))
nullmakerBool :: IJ.NullMaker (F.Field T.SqlBool)
(F.FieldNullable T.SqlBool)
nullmakerBool :: NullMaker (Field SqlBool) (FieldNullable SqlBool)
nullmakerBool = NullMaker (Field SqlBool) (FieldNullable SqlBool)
forall (p :: * -> * -> *) a b. Default p a b => p a b
D.def