Database.MySQL.Base.Types

Types for working with the direct bindings to the C mysqlclient API.

Types

High-level types

data Type

Column types supported by MySQL.

Constructors

Decimal

Tiny

Short

Long

Float

Double

Null

Timestamp

LongLong

Int24

Date

Time

DateTime

Year

NewDate

VarChar

Bit

NewDecimal

Enum

Set

TinyBlob

MediumBlob

LongBlob

Blob

VarString

String

Geometry

Instances

Enum Type

Methods

succ :: Type -> Type

pred :: Type -> Type

toEnum :: Int -> Type

fromEnum :: Type -> Int

enumFrom :: Type -> [Type]

enumFromThen :: Type -> Type -> [Type]

enumFromTo :: Type -> Type -> [Type]

enumFromThenTo :: Type -> Type -> Type -> [Type]

Eq Type

Methods

(==) :: Type -> Type -> Bool

(/=) :: Type -> Type -> Bool

Show Type

Methods

showsPrec :: Int -> Type -> ShowS

show :: Type -> String

showList :: [Type] -> ShowS

type Seconds = Word

data Protocol

Constructors

TCP

Socket

Pipe

Memory

Instances

Enum Protocol

Methods

succ :: Protocol -> Protocol

pred :: Protocol -> Protocol

toEnum :: Int -> Protocol

fromEnum :: Protocol -> Int

enumFrom :: Protocol -> [Protocol]

enumFromThen :: Protocol -> Protocol -> [Protocol]

enumFromTo :: Protocol -> Protocol -> [Protocol]

enumFromThenTo :: Protocol -> Protocol -> Protocol -> [Protocol]

Eq Protocol

Methods

(==) :: Protocol -> Protocol -> Bool

(/=) :: Protocol -> Protocol -> Bool

Read Protocol

Methods

readsPrec :: Int -> ReadS Protocol

readList :: ReadS [Protocol]

readPrec :: ReadPrec Protocol

readListPrec :: ReadPrec [Protocol]

Show Protocol

Methods

showsPrec :: Int -> Protocol -> ShowS

show :: Protocol -> String

showList :: [Protocol] -> ShowS

data Option

Constructors

ConnectTimeout Seconds

Compress

NamedPipe

InitCommand ByteString

ReadDefaultFile FilePath

ReadDefaultGroup ByteString

CharsetDir FilePath

CharsetName String

LocalInFile Bool

Protocol Protocol

SharedMemoryBaseName ByteString

ReadTimeout Seconds

WriteTimeout Seconds

UseRemoteConnection

UseEmbeddedConnection

GuessConnection

ClientIP ByteString

SecureAuth Bool

ReportDataTruncation Bool

Reconnect Bool

SSLVerifyServerCert Bool

FoundRows

IgnoreSIGPIPE

IgnoreSpace

Interactive

LocalFiles

MultiResults

MultiStatements

NoSchema

Instances

Eq Option

Methods

(==) :: Option -> Option -> Bool

(/=) :: Option -> Option -> Bool

Read Option

Methods

readsPrec :: Int -> ReadS Option

readList :: ReadS [Option]

readPrec :: ReadPrec Option

readListPrec :: ReadPrec [Option]

Show Option

Methods

showsPrec :: Int -> Option -> ShowS

show :: Option -> String

showList :: [Option] -> ShowS

data Field

A description of a field (column) of a table.

Constructors

Field

Fields

• fieldName :: ByteString

  Name of column.

• fieldOrigName :: ByteString

  Original column name, if an alias.

• fieldTable :: ByteString

  Table of column, if column was a field.

• fieldOrigTable :: ByteString

  Original table name, if table was an alias.

• fieldDB :: ByteString

  Database for table.

• fieldCatalog :: ByteString

  Catalog for table.

• fieldDefault :: Maybe ByteString

  Default value.

• fieldLength :: Word

  Width of column (create length).

• fieldMaxLength :: Word

  Maximum width for selected set.

• fieldFlags :: FieldFlags

  Div flags.

• fieldDecimals :: Word

  Number of decimals in field.

• fieldCharSet :: Word

  Character set number.

• fieldType :: Type

Instances

Eq Field

Methods

(==) :: Field -> Field -> Bool

(/=) :: Field -> Field -> Bool

Show Field

Methods

showsPrec :: Int -> Field -> ShowS

show :: Field -> String

showList :: [Field] -> ShowS

Storable Field

Methods

sizeOf :: Field -> Int

alignment :: Field -> Int

peekElemOff :: Ptr Field -> Int -> IO Field

pokeElemOff :: Ptr Field -> Int -> Field -> IO ()

peekByteOff :: Ptr b -> Int -> IO Field

pokeByteOff :: Ptr b -> Int -> Field -> IO ()

peek :: Ptr Field -> IO Field

poke :: Ptr Field -> Field -> IO ()

type FieldFlag = FieldFlags

data FieldFlags

Instances

Eq FieldFlags

Methods

(==) :: FieldFlags -> FieldFlags -> Bool

(/=) :: FieldFlags -> FieldFlags -> Bool

Show FieldFlags

Methods

showsPrec :: Int -> FieldFlags -> ShowS

show :: FieldFlags -> String

showList :: [FieldFlags] -> ShowS

Semigroup FieldFlags

Methods

(<>) :: FieldFlags -> FieldFlags -> FieldFlags

sconcat :: NonEmpty FieldFlags -> FieldFlags

stimes :: Integral b => b -> FieldFlags -> FieldFlags

Monoid FieldFlags

Methods

mempty :: FieldFlags

mappend :: FieldFlags -> FieldFlags -> FieldFlags

mconcat :: [FieldFlags] -> FieldFlags

Low-level types

data MYSQL

data MYSQL_RES

type MYSQL_ROW = Ptr (Ptr CChar)

data MYSQL_ROWS

type MYSQL_ROW_OFFSET = Ptr MYSQL_ROWS

type MyBool = CChar

Field flags

hasAllFlags :: FieldFlags -> FieldFlags -> Bool

flagNotNull :: FieldFlag

flagPrimaryKey :: FieldFlag

flagUniqueKey :: FieldFlag

flagMultipleKey :: FieldFlag

flagUnsigned :: FieldFlag

flagZeroFill :: FieldFlag

flagBinary :: FieldFlag

flagAutoIncrement :: FieldFlag

flagNumeric :: FieldFlag

flagNoDefaultValue :: FieldFlag

Connect flags

toConnectFlag :: Option -> CULong