Safe Haskell	None
Language	Haskell2010

Database.YamSql.Internal.Obj.Function

Documentation

data Function Source #

Constructors

Function

Fields

functionName :: SqlName
functionDescription :: Text
description what the function is good for
functionReturns :: SqlType
return type of the function, TABLE is special (see return_columns)
functionParameters :: Maybe [Variable]
parameters the function takes
functionTemplates :: Maybe [SqlName]
list of templates, used for this function
functionTemplateData :: Maybe [FunctionTpl]
loaded templates, not designed for use via Yaml
TODO: move to xfunctionInternal
functionReturnsColumns :: Maybe [Parameter]
if return is TABLE, gives the columns that are returned (see parameter)
functionVariables :: Maybe [Variable]
variables that are defined (ignored if language is given)
functionPrivExecute :: Maybe [SqlName]
Role that has the privilege to execute the function
functionSecurityDefiner :: Maybe Bool
If true, the function is executed with the privileges of the owner! | Owner has to be given, if this is true (not implemented yet!)
functionOwner :: Maybe SqlName
owner of the function
functionLanguage :: Maybe Text
language in which the body is written if not defined, pgsql is assumed an variables must be defined via variables if pgsql is given explicitly, variables are your problem...
functionBody :: Maybe Text
the code of the function (body)

Instances

Data Function Source #
Methods gfoldl :: (forall d b. Data d => c (d -> b) -> d -> c b) -> (forall g. g -> c g) -> Function -> c Function # gunfold :: (forall b r. Data b => c (b -> r) -> c r) -> (forall r. r -> c r) -> Constr -> c Function # toConstr :: Function -> Constr # dataTypeOf :: Function -> DataType # dataCast1 :: Typeable (* -> ) t => (forall d. Data d => c (t d)) -> Maybe (c Function) # dataCast2 :: Typeable ( -> * -> *) t => (forall d e. (Data d, Data e) => c (t d e)) -> Maybe (c Function) # gmapT :: (forall b. Data b => b -> b) -> Function -> Function # gmapQl :: (r -> r' -> r) -> r -> (forall d. Data d => d -> r') -> Function -> r # gmapQr :: (r' -> r -> r) -> r -> (forall d. Data d => d -> r') -> Function -> r # gmapQ :: (forall d. Data d => d -> u) -> Function -> [u] # gmapQi :: Int -> (forall d. Data d => d -> u) -> Function -> u # gmapM :: Monad m => (forall d. Data d => d -> m d) -> Function -> m Function # gmapMp :: MonadPlus m => (forall d. Data d => d -> m d) -> Function -> m Function # gmapMo :: MonadPlus m => (forall d. Data d => d -> m d) -> Function -> m Function #
Show Function Source #
Methods showsPrec :: Int -> Function -> ShowS # show :: Function -> String # showList :: [Function] -> ShowS #
Generic Function Source #
Associated Types type Rep Function :: * -> * # Methods from :: Function -> Rep Function x # to :: Rep Function x -> Function #
FromJSON Function Source #
Methods parseJSON :: Value -> Parser Function # parseJSONList :: Value -> Parser [Function] #
ToJSON Function Source #
Methods toJSON :: Function -> Value # toEncoding :: Function -> Encoding # toJSONList :: [Function] -> Value # toEncodingList :: [Function] -> Encoding #
ToSqlId (SqlContext (Schema, Function)) Source #
Methods sqlId :: SqlContext (Schema, Function) -> SqlId Source # sqlIdCode :: SqlContext (Schema, Function) -> Text Source #
type Rep Function Source #
type Rep Function = D1 (MetaData "Function" "Database.YamSql.Internal.Obj.Function" "hamsql-0.8.0.0-3odSe2l79FgLCGfN2lHmnu" False) (C1 (MetaCons "Function" PrefixI True) ((::) ((::) ((::) (S1 (MetaSel (Just Symbol "functionName") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 SqlName)) ((::) (S1 (MetaSel (Just Symbol "functionDescription") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 Text)) (S1 (MetaSel (Just Symbol "functionReturns") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 SqlType)))) ((::) (S1 (MetaSel (Just Symbol "functionParameters") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 (Maybe [Variable]))) ((::) (S1 (MetaSel (Just Symbol "functionTemplates") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 (Maybe [SqlName]))) (S1 (MetaSel (Just Symbol "functionTemplateData") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 (Maybe [FunctionTpl])))))) ((::) ((::) (S1 (MetaSel (Just Symbol "functionReturnsColumns") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 (Maybe [Parameter]))) ((::) (S1 (MetaSel (Just Symbol "functionVariables") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 (Maybe [Variable]))) (S1 (MetaSel (Just Symbol "functionPrivExecute") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 (Maybe [SqlName]))))) ((::) ((::) (S1 (MetaSel (Just Symbol "functionSecurityDefiner") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 (Maybe Bool))) (S1 (MetaSel (Just Symbol "functionOwner") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 (Maybe SqlName)))) ((::) (S1 (MetaSel (Just Symbol "functionLanguage") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 (Maybe Text))) (S1 (MetaSel (Just Symbol "functionBody") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 (Maybe Text))))))))

data SQL_FUNCTION Source #

Constructors

SQL_FUNCTION

Instances

Show SQL_FUNCTION Source #
Methods showsPrec :: Int -> SQL_FUNCTION -> ShowS # show :: SQL_FUNCTION -> String # showList :: [SQL_FUNCTION] -> ShowS #
ToSqlCode SQL_FUNCTION Source #
Methods toSqlCode :: SQL_FUNCTION -> Text Source #
SqlObjType SQL_FUNCTION Source #

data FunctionTpl Source #

Constructors

FunctionTpl
Fields functiontplTemplate :: SqlName functiontplDescription :: Text functiontplLanguage :: Maybe Text functiontplParameters :: Maybe [Variable] functiontplVariables :: Maybe [Variable] functiontplPrivExecute :: Maybe [SqlName] functiontplSecurityDefiner :: Maybe Bool functiontplOwner :: Maybe SqlName functiontplBodyPrelude :: Maybe Text functiontplBodyPostlude :: Maybe Text

Instances

Data FunctionTpl Source #
Methods gfoldl :: (forall d b. Data d => c (d -> b) -> d -> c b) -> (forall g. g -> c g) -> FunctionTpl -> c FunctionTpl # gunfold :: (forall b r. Data b => c (b -> r) -> c r) -> (forall r. r -> c r) -> Constr -> c FunctionTpl # toConstr :: FunctionTpl -> Constr # dataTypeOf :: FunctionTpl -> DataType # dataCast1 :: Typeable (* -> ) t => (forall d. Data d => c (t d)) -> Maybe (c FunctionTpl) # dataCast2 :: Typeable ( -> * -> *) t => (forall d e. (Data d, Data e) => c (t d e)) -> Maybe (c FunctionTpl) # gmapT :: (forall b. Data b => b -> b) -> FunctionTpl -> FunctionTpl # gmapQl :: (r -> r' -> r) -> r -> (forall d. Data d => d -> r') -> FunctionTpl -> r # gmapQr :: (r' -> r -> r) -> r -> (forall d. Data d => d -> r') -> FunctionTpl -> r # gmapQ :: (forall d. Data d => d -> u) -> FunctionTpl -> [u] # gmapQi :: Int -> (forall d. Data d => d -> u) -> FunctionTpl -> u # gmapM :: Monad m => (forall d. Data d => d -> m d) -> FunctionTpl -> m FunctionTpl # gmapMp :: MonadPlus m => (forall d. Data d => d -> m d) -> FunctionTpl -> m FunctionTpl # gmapMo :: MonadPlus m => (forall d. Data d => d -> m d) -> FunctionTpl -> m FunctionTpl #
Show FunctionTpl Source #
Methods showsPrec :: Int -> FunctionTpl -> ShowS # show :: FunctionTpl -> String # showList :: [FunctionTpl] -> ShowS #
Generic FunctionTpl Source #
Associated Types type Rep FunctionTpl :: * -> * # Methods from :: FunctionTpl -> Rep FunctionTpl x # to :: Rep FunctionTpl x -> FunctionTpl #
FromJSON FunctionTpl Source #
Methods parseJSON :: Value -> Parser FunctionTpl # parseJSONList :: Value -> Parser [FunctionTpl] #
ToJSON FunctionTpl Source #
Methods toJSON :: FunctionTpl -> Value # toEncoding :: FunctionTpl -> Encoding # toJSONList :: [FunctionTpl] -> Value # toEncodingList :: [FunctionTpl] -> Encoding #
WithName (WithSchema FunctionTpl) Source #
Methods name :: WithSchema FunctionTpl -> Text Source #
type Rep FunctionTpl Source #
type Rep FunctionTpl = D1 (MetaData "FunctionTpl" "Database.YamSql.Internal.Obj.Function" "hamsql-0.8.0.0-3odSe2l79FgLCGfN2lHmnu" False) (C1 (MetaCons "FunctionTpl" PrefixI True) ((::) ((::) ((::) (S1 (MetaSel (Just Symbol "functiontplTemplate") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 SqlName)) (S1 (MetaSel (Just Symbol "functiontplDescription") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 Text))) ((::) (S1 (MetaSel (Just Symbol "functiontplLanguage") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 (Maybe Text))) ((::) (S1 (MetaSel (Just Symbol "functiontplParameters") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 (Maybe [Variable]))) (S1 (MetaSel (Just Symbol "functiontplVariables") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 (Maybe [Variable])))))) ((::) ((::) (S1 (MetaSel (Just Symbol "functiontplPrivExecute") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 (Maybe [SqlName]))) (S1 (MetaSel (Just Symbol "functiontplSecurityDefiner") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 (Maybe Bool)))) ((::) (S1 (MetaSel (Just Symbol "functiontplOwner") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 (Maybe SqlName))) ((:*:) (S1 (MetaSel (Just Symbol "functiontplBodyPrelude") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 (Maybe Text))) (S1 (MetaSel (Just Symbol "functiontplBodyPostlude") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 (Maybe Text))))))))

applyFunctionTpl :: FunctionTpl -> Function -> Function Source #