Safe Haskell	None
Language	Haskell2010

Data.Serviette

Description

Generate sql queries from JSON. You could use this to query database directly from frontend. Basic sql queries are supported and the resulting sql query is returned in json format.

Synopsis

Documentation

rawSqlStr :: SqlQuery -> ByteString Source #

Returns json with sql query and errors and warnings if any

data SqlQuery Source #

Represents intermediate type for receiving json

Constructors

SqlQuery
Fields format :: Int action :: Action selectName :: TableName set :: Maybe [SetField] joinTables :: Maybe [JoinTable] whereCondition :: Maybe [WhereCondition]

Instances

Show SqlQuery Source #
Methods showsPrec :: Int -> SqlQuery -> ShowS # show :: SqlQuery -> String # showList :: [SqlQuery] -> ShowS #
Generic SqlQuery Source #
Associated Types type Rep SqlQuery :: * -> * # Methods from :: SqlQuery -> Rep SqlQuery x # to :: Rep SqlQuery x -> SqlQuery #
ToJSON SqlQuery Source #
Methods toJSON :: SqlQuery -> Value # toEncoding :: SqlQuery -> Encoding # toJSONList :: [SqlQuery] -> Value # toEncodingList :: [SqlQuery] -> Encoding #
FromJSON SqlQuery Source #
Methods parseJSON :: Value -> Parser SqlQuery # parseJSONList :: Value -> Parser [SqlQuery] #
type Rep SqlQuery Source #
type Rep SqlQuery = D1 (MetaData "SqlQuery" "Data.ApiDataTypes" "serviette-0.1.0.6-HahqiRl77K64mqnQ5kNaJt" False) (C1 (MetaCons "SqlQuery" PrefixI True) ((::) ((::) (S1 (MetaSel (Just Symbol "format") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 Int)) ((::) (S1 (MetaSel (Just Symbol "action") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 Action)) (S1 (MetaSel (Just Symbol "selectName") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 TableName)))) ((::) (S1 (MetaSel (Just Symbol "set") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 (Maybe [SetField]))) ((:*:) (S1 (MetaSel (Just Symbol "joinTables") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 (Maybe [JoinTable]))) (S1 (MetaSel (Just Symbol "whereCondition") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 (Maybe [WhereCondition])))))))

data SqlResponse Source #

Constructors

SqlResponse
Fields response :: Text errors :: Text warnings :: Text

Instances

Show SqlResponse Source #
Methods showsPrec :: Int -> SqlResponse -> ShowS # show :: SqlResponse -> String # showList :: [SqlResponse] -> ShowS #
Generic SqlResponse Source #
Associated Types type Rep SqlResponse :: * -> * # Methods from :: SqlResponse -> Rep SqlResponse x # to :: Rep SqlResponse x -> SqlResponse #
ToJSON SqlResponse Source #
Methods toJSON :: SqlResponse -> Value # toEncoding :: SqlResponse -> Encoding # toJSONList :: [SqlResponse] -> Value # toEncodingList :: [SqlResponse] -> Encoding #
FromJSON SqlResponse Source #
Methods parseJSON :: Value -> Parser SqlResponse # parseJSONList :: Value -> Parser [SqlResponse] #
type Rep SqlResponse Source #
type Rep SqlResponse = D1 (MetaData "SqlResponse" "Data.ApiDataTypes" "serviette-0.1.0.6-HahqiRl77K64mqnQ5kNaJt" False) (C1 (MetaCons "SqlResponse" PrefixI True) ((::) (S1 (MetaSel (Just Symbol "response") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 Text)) ((::) (S1 (MetaSel (Just Symbol "errors") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 Text)) (S1 (MetaSel (Just Symbol "warnings") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 Text)))))

data SqlResultQuery Source #

Represents type that is the result of the json "computation"

Constructors

SqlResultQuery
Fields getAction :: Action getSelectTable :: TableName getSetFields :: Maybe [SetField] getJoins :: Maybe [JoinTable] getWhereCondition :: Maybe [WhereCondition]

Instances

Show SqlResultQuery Source #
Methods showsPrec :: Int -> SqlResultQuery -> ShowS # show :: SqlResultQuery -> String # showList :: [SqlResultQuery] -> ShowS #
Generic SqlResultQuery Source #
Associated Types type Rep SqlResultQuery :: * -> * # Methods from :: SqlResultQuery -> Rep SqlResultQuery x # to :: Rep SqlResultQuery x -> SqlResultQuery #
ToJSON SqlResultQuery Source #
Methods toJSON :: SqlResultQuery -> Value # toEncoding :: SqlResultQuery -> Encoding # toJSONList :: [SqlResultQuery] -> Value # toEncodingList :: [SqlResultQuery] -> Encoding #
FromJSON SqlResultQuery Source #
Methods parseJSON :: Value -> Parser SqlResultQuery # parseJSONList :: Value -> Parser [SqlResultQuery] #
type Rep SqlResultQuery Source #
type Rep SqlResultQuery = D1 (MetaData "SqlResultQuery" "Data.ApiDataTypes" "serviette-0.1.0.6-HahqiRl77K64mqnQ5kNaJt" False) (C1 (MetaCons "SqlResultQuery" PrefixI True) ((::) ((::) (S1 (MetaSel (Just Symbol "getAction") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 Action)) (S1 (MetaSel (Just Symbol "getSelectTable") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 TableName))) ((::) (S1 (MetaSel (Just Symbol "getSetFields") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 (Maybe [SetField]))) ((::) (S1 (MetaSel (Just Symbol "getJoins") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 (Maybe [JoinTable]))) (S1 (MetaSel (Just Symbol "getWhereCondition") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 (Maybe [WhereCondition])))))))