Safe Haskell	Safe-Inferred
Language	GHC2021

Napkin.Types.Commands.BigQuery.Merge

Documentation

newtype WhenMatched #

Constructors

UpdateWhenMatched [(Name, SExp)]

Instances

Instances details

Show WhenMatched #
Instance details Defined in Napkin.Types.Commands.BigQuery.Merge Methods showsPrec :: Int -> WhenMatched -> ShowS # show :: WhenMatched -> String # showList :: [WhenMatched] -> ShowS #
Eq WhenMatched #
Instance details Defined in Napkin.Types.Commands.BigQuery.Merge Methods (==) :: WhenMatched -> WhenMatched -> Bool # (/=) :: WhenMatched -> WhenMatched -> Bool #

newtype WhenNotMatched #

Constructors

InsertWhenNotMatched [(Name, SExp)]

Instances

Instances details

Show WhenNotMatched #
Instance details Defined in Napkin.Types.Commands.BigQuery.Merge Methods showsPrec :: Int -> WhenNotMatched -> ShowS # show :: WhenNotMatched -> String # showList :: [WhenNotMatched] -> ShowS #
Eq WhenNotMatched #
Instance details Defined in Napkin.Types.Commands.BigQuery.Merge Methods (==) :: WhenNotMatched -> WhenNotMatched -> Bool # (/=) :: WhenNotMatched -> WhenNotMatched -> Bool #

newtype JoinOnPredicate #

Constructors

JoinOnPredicate SExp

Instances

Instances details

Show JoinOnPredicate #
Instance details Defined in Napkin.Types.Commands.BigQuery.Merge Methods showsPrec :: Int -> JoinOnPredicate -> ShowS # show :: JoinOnPredicate -> String # showList :: [JoinOnPredicate] -> ShowS #
Eq JoinOnPredicate #
Instance details Defined in Napkin.Types.Commands.BigQuery.Merge Methods (==) :: JoinOnPredicate -> JoinOnPredicate -> Bool # (/=) :: JoinOnPredicate -> JoinOnPredicate -> Bool #
RenderSql JoinOnPredicate BigQuery #
Instance details Defined in Napkin.Render.BigQuery.Merge Methods renderSql :: BigQuery -> JoinOnPredicate -> Doc #

newtype TableAlias #

Constructors

TableAlias Name

Instances

Instances details

IsString TableAlias #
Instance details Defined in Napkin.Types.Commands.BigQuery.Merge Methods fromString :: String -> TableAlias #
Show TableAlias #
Instance details Defined in Napkin.Types.Commands.BigQuery.Merge Methods showsPrec :: Int -> TableAlias -> ShowS # show :: TableAlias -> String # showList :: [TableAlias] -> ShowS #
Eq TableAlias #
Instance details Defined in Napkin.Types.Commands.BigQuery.Merge Methods (==) :: TableAlias -> TableAlias -> Bool # (/=) :: TableAlias -> TableAlias -> Bool #
RenderSql TableAlias BigQuery #
Instance details Defined in Napkin.Render.BigQuery.Merge Methods renderSql :: BigQuery -> TableAlias -> Doc #

data Merge #

Constructors

Merge
Fields targetTable :: Ref Table targetAlias :: TableAlias using :: Query usingAlias :: TableAlias mergeOn :: JoinOnPredicate updateWhenMatched :: Maybe WhenMatched insertWhenNotMatchedByTarget :: Maybe WhenNotMatched

Instances

Instances details

Generic Merge #
Instance details Defined in Napkin.Types.Commands.BigQuery.Merge Associated Types type Rep Merge :: Type -> Type # Methods from :: Merge -> Rep Merge x # to :: Rep Merge x -> Merge #
Show Merge #
Instance details Defined in Napkin.Types.Commands.BigQuery.Merge Methods showsPrec :: Int -> Merge -> ShowS # show :: Merge -> String # showList :: [Merge] -> ShowS #
Eq Merge #
Instance details Defined in Napkin.Types.Commands.BigQuery.Merge Methods (==) :: Merge -> Merge -> Bool # (/=) :: Merge -> Merge -> Bool #
RenderSql Merge BigQuery #
Instance details Defined in Napkin.Render.BigQuery.Merge Methods renderSql :: BigQuery -> Merge -> Doc #
Command Merge () BigQuery #
Instance details Defined in Napkin.Run.BigQuery.Merge Methods execCommand :: MonadNapkin BigQuery m => BackendConn BigQuery -> Merge -> m () #
Command Merge () MsSql #
Instance details Defined in Napkin.Run.MsSql Methods execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> Merge -> m () #
Command Merge () Postgres #
Instance details Defined in Napkin.Run.Postgres Methods execCommand :: MonadNapkin Postgres m => BackendConn Postgres -> Merge -> m () #
Command Merge () Redshift #
Instance details Defined in Napkin.Run.Redshift Methods execCommand :: MonadNapkin Redshift m => BackendConn Redshift -> Merge -> m () #
Command Merge () Sqlite #
Instance details Defined in Napkin.Run.Sqlite Methods execCommand :: MonadNapkin Sqlite m => BackendConn Sqlite -> Merge -> m () #
type Rep Merge #
Instance details Defined in Napkin.Types.Commands.BigQuery.Merge type Rep Merge = D1 ('MetaData "Merge" "Napkin.Types.Commands.BigQuery.Merge" "napkin-1.0.0-B79azc00rn1K8mj00hwhwG" 'False) (C1 ('MetaCons "Merge" 'PrefixI 'True) ((S1 ('MetaSel ('Just "targetTable") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Ref Table)) :: (S1 ('MetaSel ('Just "targetAlias") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 TableAlias) :: S1 ('MetaSel ('Just "using") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Query))) :: ((S1 ('MetaSel ('Just "usingAlias") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 TableAlias) :: S1 ('MetaSel ('Just "mergeOn") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 JoinOnPredicate)) :: (S1 ('MetaSel ('Just "updateWhenMatched") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe WhenMatched)) :: S1 ('MetaSel ('Just "insertWhenNotMatchedByTarget") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe WhenNotMatched))))))