Safe Haskell	Safe-Inferred
Language	Haskell2010

Hasura.Backends.MSSQL.Connection

Contents

Orphan instances
Orphan instances

Description

MSSQL Connection

This module handles the connection against an MS SQL Server. It defines the connection string, connection pool, default settings, and conversion functions between MSSQL and graphql-engine.

Synopsis

class MonadError QErr m => MonadMSSQLTx m where
- liftMSSQLTx :: TxE QErr a -> m a
data MSSQLPoolSettings
- = MSSQLPoolSettings {
  - _mpsMaxConnections :: Maybe Int
  - _mpsTotalMaxConnections :: Maybe Int
  - _mpsIdleTimeout :: Int
  }
- | MSSQLPoolSettingsNoPool
defaultMSSQLMaxConnections :: Int
data MSSQLConnectionInfo = MSSQLConnectionInfo {
- _mciConnectionString :: InputConnectionString
- _mciPoolSettings :: MSSQLPoolSettings
- _mciIsolationLevel :: TxIsolation
}
data MSSQLConnConfiguration = MSSQLConnConfiguration MSSQLConnectionInfo (Maybe (NonEmpty MSSQLConnectionInfo))
createMSSQLPool :: MonadIO m => QErrM m => InputConnectionString -> ConnectionOptions -> Environment -> m (ConnectionString, MSSQLPool)
getEnv :: QErrM m => Environment -> Text -> m Text
data MSSQLExecCtx = MSSQLExecCtx {
- mssqlRunReadOnly :: MSSQLRunTx
- mssqlRunReadWrite :: MSSQLRunTx
- mssqlRunSerializableTx :: MSSQLRunTx
- mssqlDestroyConn :: IO ()
- mssqlResizePools :: ServerReplicas -> IO SourceResizePoolSummary
}
mkMSSQLExecCtx :: TxIsolation -> MSSQLPool -> ResizePoolStrategy -> MSSQLExecCtx
resizeMSSQLPool :: MSSQLPool -> Int -> ServerReplicas -> IO ()
mkMSSQLAnyQueryTx :: Query -> TxET QErr IO ()
data MSSQLSourceConfig = MSSQLSourceConfig ConnectionString MSSQLExecCtx Int
odbcValueToJValue :: Value -> Value
runMSSQLSourceReadTx :: (MonadIO m, MonadBaseControl IO m) => MSSQLSourceConfig -> TxET QErr m a -> m (Either QErr a)
runMSSQLSourceWriteTx :: (MonadIO m, MonadBaseControl IO m) => MSSQLSourceConfig -> TxET QErr m a -> m (Either QErr a)

Documentation

class MonadError QErr m => MonadMSSQLTx m where Source #

Methods

liftMSSQLTx :: TxE QErr a -> m a Source #

Instances

Instances details

MonadIO m => MonadMSSQLTx (TxET QErr m) Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Methods liftMSSQLTx :: TxE QErr a -> TxET QErr m a Source #
MonadMSSQLTx m => MonadMSSQLTx (ReaderT s m) Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Methods liftMSSQLTx :: TxE QErr a -> ReaderT s m a Source #
MonadMSSQLTx m => MonadMSSQLTx (StateT s m) Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Methods liftMSSQLTx :: TxE QErr a -> StateT s m a Source #
(Monoid w, MonadMSSQLTx m) => MonadMSSQLTx (WriterT w m) Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Methods liftMSSQLTx :: TxE QErr a -> WriterT w m a Source #

Orphan instances

data MSSQLPoolSettings Source #

Constructors

MSSQLPoolSettings
Fields _mpsMaxConnections :: Maybe Int _mpsTotalMaxConnections :: Maybe Int _mpsIdleTimeout :: Int
MSSQLPoolSettingsNoPool

Instances

Instances details

FromJSON MSSQLPoolSettings Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Methods parseJSON :: Value -> Parser MSSQLPoolSettings Source # parseJSONList :: Value -> Parser [MSSQLPoolSettings] Source #
ToJSON MSSQLPoolSettings Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Methods toJSON :: MSSQLPoolSettings -> Value Source # toEncoding :: MSSQLPoolSettings -> Encoding Source # toJSONList :: [MSSQLPoolSettings] -> Value Source # toEncodingList :: [MSSQLPoolSettings] -> Encoding Source #
HasCodec MSSQLPoolSettings Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Methods codec :: JSONCodec MSSQLPoolSettings Source # listCodecForStringCompatibility :: JSONCodec [MSSQLPoolSettings] Source #
Generic MSSQLPoolSettings Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Associated Types type Rep MSSQLPoolSettings :: Type -> Type # Methods from :: MSSQLPoolSettings -> Rep MSSQLPoolSettings x # to :: Rep MSSQLPoolSettings x -> MSSQLPoolSettings #
Show MSSQLPoolSettings Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Methods showsPrec :: Int -> MSSQLPoolSettings -> ShowS # show :: MSSQLPoolSettings -> String # showList :: [MSSQLPoolSettings] -> ShowS #
NFData MSSQLPoolSettings Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Methods rnf :: MSSQLPoolSettings -> () #
Eq MSSQLPoolSettings Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Methods (==) :: MSSQLPoolSettings -> MSSQLPoolSettings -> Bool # (/=) :: MSSQLPoolSettings -> MSSQLPoolSettings -> Bool #
Hashable MSSQLPoolSettings Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Methods hashWithSalt :: Int -> MSSQLPoolSettings -> Int Source # hash :: MSSQLPoolSettings -> Int Source #
type Rep MSSQLPoolSettings Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection type Rep MSSQLPoolSettings = D1 ('MetaData "MSSQLPoolSettings" "Hasura.Backends.MSSQL.Connection" "graphql-engine-1.0.0-inplace" 'False) (C1 ('MetaCons "MSSQLPoolSettings" 'PrefixI 'True) (S1 ('MetaSel ('Just "_mpsMaxConnections") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedStrict) (Rec0 (Maybe Int)) :: (S1 ('MetaSel ('Just "_mpsTotalMaxConnections") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedStrict) (Rec0 (Maybe Int)) :: S1 ('MetaSel ('Just "_mpsIdleTimeout") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedStrict) (Rec0 Int))) :+: C1 ('MetaCons "MSSQLPoolSettingsNoPool" 'PrefixI 'False) (U1 :: Type -> Type))

defaultMSSQLMaxConnections :: Int Source #

data MSSQLConnectionInfo Source #

Constructors

MSSQLConnectionInfo
Fields _mciConnectionString :: InputConnectionString _mciPoolSettings :: MSSQLPoolSettings _mciIsolationLevel :: TxIsolation

Instances

Instances details

FromJSON MSSQLConnectionInfo Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Methods parseJSON :: Value -> Parser MSSQLConnectionInfo Source # parseJSONList :: Value -> Parser [MSSQLConnectionInfo] Source #
ToJSON MSSQLConnectionInfo Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Methods toJSON :: MSSQLConnectionInfo -> Value Source # toEncoding :: MSSQLConnectionInfo -> Encoding Source # toJSONList :: [MSSQLConnectionInfo] -> Value Source # toEncodingList :: [MSSQLConnectionInfo] -> Encoding Source #
HasCodec MSSQLConnectionInfo Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Methods codec :: JSONCodec MSSQLConnectionInfo Source # listCodecForStringCompatibility :: JSONCodec [MSSQLConnectionInfo] Source #
Generic MSSQLConnectionInfo Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Associated Types type Rep MSSQLConnectionInfo :: Type -> Type # Methods from :: MSSQLConnectionInfo -> Rep MSSQLConnectionInfo x # to :: Rep MSSQLConnectionInfo x -> MSSQLConnectionInfo #
Show MSSQLConnectionInfo Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Methods showsPrec :: Int -> MSSQLConnectionInfo -> ShowS # show :: MSSQLConnectionInfo -> String # showList :: [MSSQLConnectionInfo] -> ShowS #
NFData MSSQLConnectionInfo Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Methods rnf :: MSSQLConnectionInfo -> () #
Eq MSSQLConnectionInfo Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Methods (==) :: MSSQLConnectionInfo -> MSSQLConnectionInfo -> Bool # (/=) :: MSSQLConnectionInfo -> MSSQLConnectionInfo -> Bool #
Hashable MSSQLConnectionInfo Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Methods hashWithSalt :: Int -> MSSQLConnectionInfo -> Int Source # hash :: MSSQLConnectionInfo -> Int Source #
type Rep MSSQLConnectionInfo Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection type Rep MSSQLConnectionInfo

data MSSQLConnConfiguration Source #

Constructors

MSSQLConnConfiguration MSSQLConnectionInfo (Maybe (NonEmpty MSSQLConnectionInfo))

Instances

Instances details

FromJSON MSSQLConnConfiguration Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Methods parseJSON :: Value -> Parser MSSQLConnConfiguration Source # parseJSONList :: Value -> Parser [MSSQLConnConfiguration] Source #
ToJSON MSSQLConnConfiguration Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Methods toJSON :: MSSQLConnConfiguration -> Value Source # toEncoding :: MSSQLConnConfiguration -> Encoding Source # toJSONList :: [MSSQLConnConfiguration] -> Value Source # toEncodingList :: [MSSQLConnConfiguration] -> Encoding Source #
HasCodec MSSQLConnConfiguration Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Methods codec :: JSONCodec MSSQLConnConfiguration Source # listCodecForStringCompatibility :: JSONCodec [MSSQLConnConfiguration] Source #
Generic MSSQLConnConfiguration Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Associated Types type Rep MSSQLConnConfiguration :: Type -> Type # Methods from :: MSSQLConnConfiguration -> Rep MSSQLConnConfiguration x # to :: Rep MSSQLConnConfiguration x -> MSSQLConnConfiguration #
Show MSSQLConnConfiguration Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Methods showsPrec :: Int -> MSSQLConnConfiguration -> ShowS # show :: MSSQLConnConfiguration -> String # showList :: [MSSQLConnConfiguration] -> ShowS #
NFData MSSQLConnConfiguration Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Methods rnf :: MSSQLConnConfiguration -> () #
Eq MSSQLConnConfiguration Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Methods (==) :: MSSQLConnConfiguration -> MSSQLConnConfiguration -> Bool # (/=) :: MSSQLConnConfiguration -> MSSQLConnConfiguration -> Bool #
Hashable MSSQLConnConfiguration Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Methods hashWithSalt :: Int -> MSSQLConnConfiguration -> Int Source # hash :: MSSQLConnConfiguration -> Int Source #
type Rep MSSQLConnConfiguration Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection type Rep MSSQLConnConfiguration = D1 ('MetaData "MSSQLConnConfiguration" "Hasura.Backends.MSSQL.Connection" "graphql-engine-1.0.0-inplace" 'False) (C1 ('MetaCons "MSSQLConnConfiguration" 'PrefixI 'True) (S1 ('MetaSel ('Just "_mccConnectionInfo") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedStrict) (Rec0 MSSQLConnectionInfo) :*: S1 ('MetaSel ('Just "_mccReadReplicas") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedStrict) (Rec0 (Maybe (NonEmpty MSSQLConnectionInfo)))))

createMSSQLPool :: MonadIO m => QErrM m => InputConnectionString -> ConnectionOptions -> Environment -> m (ConnectionString, MSSQLPool) Source #

getEnv :: QErrM m => Environment -> Text -> m Text Source #

data MSSQLExecCtx Source #

Execution Context required to execute MSSQL transactions

Constructors

MSSQLExecCtx

Fields

mssqlRunReadOnly :: MSSQLRunTx
A function that runs read-only queries
mssqlRunReadWrite :: MSSQLRunTx
A function that runs read-write queries; run in a transaction
mssqlRunSerializableTx :: MSSQLRunTx
A function that runs a transaction in the SERIALIZABLE transaction isolation level. This is mainly intended to run source catalog migrations.
mssqlDestroyConn :: IO ()
Destroys connection pools
mssqlResizePools :: ServerReplicas -> IO SourceResizePoolSummary
Resize pools based on number of server instances

mkMSSQLExecCtx :: TxIsolation -> MSSQLPool -> ResizePoolStrategy -> MSSQLExecCtx Source #

Creates a MSSQL execution context for a single primary pool

resizeMSSQLPool :: MSSQLPool -> Int -> ServerReplicas -> IO () Source #

Resize MSSQL pool by setting the number of connections equal to allowed maximum connections across all server instances divided by number of instances

mkMSSQLAnyQueryTx :: Query -> TxET QErr IO () Source #

Run any query discarding its results

data MSSQLSourceConfig Source #

Constructors

MSSQLSourceConfig ConnectionString MSSQLExecCtx Int

Instances

Instances details

ToJSON MSSQLSourceConfig Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Methods toJSON :: MSSQLSourceConfig -> Value Source # toEncoding :: MSSQLSourceConfig -> Encoding Source # toJSONList :: [MSSQLSourceConfig] -> Value Source # toEncodingList :: [MSSQLSourceConfig] -> Encoding Source #
Generic MSSQLSourceConfig Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Associated Types type Rep MSSQLSourceConfig :: Type -> Type # Methods from :: MSSQLSourceConfig -> Rep MSSQLSourceConfig x # to :: Rep MSSQLSourceConfig x -> MSSQLSourceConfig #
Show MSSQLSourceConfig Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Methods showsPrec :: Int -> MSSQLSourceConfig -> ShowS # show :: MSSQLSourceConfig -> String # showList :: [MSSQLSourceConfig] -> ShowS #
Eq MSSQLSourceConfig Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Methods (==) :: MSSQLSourceConfig -> MSSQLSourceConfig -> Bool # (/=) :: MSSQLSourceConfig -> MSSQLSourceConfig -> Bool #
Has () MSSQLSourceConfig Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection Methods getter :: MSSQLSourceConfig -> () Source # modifier :: (() -> ()) -> MSSQLSourceConfig -> MSSQLSourceConfig Source # hasLens :: Lens MSSQLSourceConfig () Source #
type Rep MSSQLSourceConfig Source #
Instance details Defined in Hasura.Backends.MSSQL.Connection type Rep MSSQLSourceConfig = D1 ('MetaData "MSSQLSourceConfig" "Hasura.Backends.MSSQL.Connection" "graphql-engine-1.0.0-inplace" 'False) (C1 ('MetaCons "MSSQLSourceConfig" 'PrefixI 'True) (S1 ('MetaSel ('Just "_mscConnectionString") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedStrict) (Rec0 ConnectionString) :: (S1 ('MetaSel ('Just "_mscExecCtx") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedStrict) (Rec0 MSSQLExecCtx) :: S1 ('MetaSel ('Just "_mscReadReplicas") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedStrict) (Rec0 Int))))

odbcValueToJValue :: Value -> Value Source #

runMSSQLSourceReadTx :: (MonadIO m, MonadBaseControl IO m) => MSSQLSourceConfig -> TxET QErr m a -> m (Either QErr a) Source #

runMSSQLSourceWriteTx :: (MonadIO m, MonadBaseControl IO m) => MSSQLSourceConfig -> TxET QErr m a -> m (Either QErr a) Source #

Orphan instances

NFData ConnectionString Source #
Instance details Methods rnf :: ConnectionString -> () #
Hashable ConnectionString Source #
Instance details Methods hashWithSalt :: Int -> ConnectionString -> Int Source # hash :: ConnectionString -> Int Source #