Database.HSQL.Types

Documentation

type FieldDef = (String, SqlType, Bool)

data SqlType

Constructors

SqlChar Int

SqlVarChar Int

SqlLongVarChar Int

SqlText

SqlWChar Int

SqlWVarChar Int

SqlWLongVarChar Int

SqlDecimal Int Int

SqlNumeric Int Int

SqlSmallInt

SqlMedInt

SqlInteger

SqlReal

SqlFloat

SqlDouble

SqlBit

SqlTinyInt

SqlBigInt

SqlBinary Int

SqlVarBinary Int

SqlLongVarBinary Int

SqlDate

SqlTime

SqlTimeTZ

SqlAbsTime

SqlRelTime

SqlTimeInterval

SqlAbsTimeInterval

SqlTimeStamp

SqlDateTime

SqlDateTimeTZ

SqlYear

SqlSET

SqlENUM

SqlBLOB

SqlMoney

SqlINetAddr

SqlCIDRAddr

SqlMacAddr

SqlPoint

SqlLSeg

SqlPath

SqlBox

SqlPolygon

SqlLine

SqlCircle

SqlUnknown Int

HSQL returns SqlUnknown tp for all columns for which it cannot determine the right type. The tp here is the internal type code returned from the backend library

Instances

Eq SqlType

Show SqlType

data SqlError

Constructors

SqlError

Fields

seState :: String

seNativeError :: Int

seErrorMsg :: String

SqlNoData

SqlInvalidHandle

SqlStillExecuting

SqlNeedData

SqlBadTypeCast

Fields

seFieldName :: String

seFieldType :: SqlType

SqlFetchNull

Fields

seFieldName :: String

SqlUnknownField

Fields

seFieldName :: String

SqlUnsupportedOperation

SqlClosedHandle

Instances

Show SqlError

Typeable SqlError

sqlErrorTc :: TyCon

data Connection

A Connection type represents a connection to a database, through which you can operate on the it. In order to create the connection you need to use the connect function from the module for your prefered backend.

Constructors

Connection

Fields

connDisconnect :: IO ()

connExecute :: String -> IO ()

connQuery :: String -> IO Statement

connTables :: IO [String]

connDescribe :: String -> IO [FieldDef]

connBeginTransaction :: IO ()

connCommitTransaction :: IO ()

connRollbackTransaction :: IO ()

connClosed :: MVar Bool

data Statement

The Statement type represents a result from the execution of given SQL query.

Constructors

Statement

Fields

stmtConn :: Connection

stmtClose :: IO ()

stmtFetch :: IO Bool

stmtGetCol :: forall a. Int -> FieldDef -> (FieldDef -> CString -> Int -> IO a) -> IO a

stmtFields :: [FieldDef]

stmtClosed :: MVar Bool

class SqlBind a where

Methods

fromSqlCStringLen :: FieldDef -> CString -> Int -> IO a

fromSqlValue :: SqlType -> String -> Maybe a

toSqlValue :: a -> String

Instances

SqlBind Bool

SqlBind Double

SqlBind Float

SqlBind Int

SqlBind Int64

SqlBind Integer

SqlBind String

SqlBind ClockTime

SqlBind MacAddr

SqlBind INetAddr

SqlBind Polygon

SqlBind Circle

SqlBind Box

SqlBind Path

SqlBind Line

SqlBind Point

SqlBind a => SqlBind (Maybe a)