Safe Haskell | Safe-Inferred |
---|---|
Language | Haskell2010 |
SQL Server client library implemented in Haskell
Synopsis
- data ConnectInfo = ConnectInfo {
- connectHost :: !String
- connectPort :: !String
- connectDatabase :: !String
- connectUser :: !String
- connectPassword :: !String
- connectEncryption :: !Word8
- connectPacketSize :: !Word32
- connectOptionFlags1 :: !Word8
- connectOptionFlags2 :: !Word8
- connectOptionFlags3 :: !Word8
- connectTypeFlags :: !Word8
- connectTimeZone :: !Int32
- connectCollation :: !Collation32
- connectLanguage :: !String
- connectAppName :: !String
- connectServerName :: !String
- defaultConnectInfo :: ConnectInfo
- data Connection = Connection Socket Word32
- connect :: ConnectInfo -> IO Connection
- connectWithoutEncryption :: ConnectInfo -> IO Connection
- close :: Connection -> IO ()
- data ProtocolError = ProtocolError String
- data AuthError = AuthError !Info
Connect with the SQL Server
connect
and close
function could be used as follows.
{-# LANGUAGE OverloadedStrings #-} module Main where import Network.Socket (withSocketsDo) import Control.Exception (bracket) import Database.MSSQLServer.Connection import Database.MSSQLServer.Query main :: IO () main = do let info = defaultConnectInfo { connectHost = "192.168.0.1" , connectPort = "1433" , connectDatabase = "some_database" , connectUser = "some_user" , connectPassword = "some_password" } withSocketsDo $ bracket (connect info) close $ \conn -> do rs <- sql conn "SELECT 2 + 2" :: IO [Only Int] print rs
data ConnectInfo Source #
ConnectInfo | |
|
connect :: ConnectInfo -> IO Connection Source #
close :: Connection -> IO () Source #
data ProtocolError Source #
Instances
Exception ProtocolError Source # | |
Defined in Database.MSSQLServer.Connection | |
Show ProtocolError Source # | |
Defined in Database.MSSQLServer.Connection showsPrec :: Int -> ProtocolError -> ShowS # show :: ProtocolError -> String # showList :: [ProtocolError] -> ShowS # |
Instances
Exception AuthError Source # | |
Defined in Database.MSSQLServer.Connection toException :: AuthError -> SomeException # fromException :: SomeException -> Maybe AuthError # displayException :: AuthError -> String # | |
Show AuthError Source # | |