Database.Sqlite

Documentation

data Database

data Statement

type Error = Int

data StepResult

Constructors

Row

Done

Instances

Eq StepResult

Show StepResult

data SQLData

Constructors

SQLInteger Int64

SQLFloat Double

SQLText String

SQLBlob ByteString

SQLNull

Instances

Eq SQLData

Show SQLData

Typeable SQLData

data ColumnType

Constructors

IntegerColumn

FloatColumn

TextColumn

BlobColumn

NullColumn

Instances

Eq ColumnType

Show ColumnType

open :: String -> IO Database

close :: Database -> IO ()

prepare :: Database -> String -> IO Statement

step :: Statement -> IO StepResult

reset :: Statement -> IO ()

finalize :: Statement -> IO ()

bindBlob :: Statement -> Int -> ByteString -> IO ()

bindDouble :: Statement -> Int -> Double -> IO ()

bindInt :: Statement -> Int -> Int -> IO ()

bindInt64 :: Statement -> Int -> Int64 -> IO ()

bindNull :: Statement -> Int -> IO ()

bindText :: Statement -> Int -> String -> IO ()

bind :: Statement -> [SQLData] -> IO ()

column :: Statement -> Int -> IO SQLData

columns :: Statement -> IO [SQLData]

unsafeColumns :: Statement -> [Maybe ColumnType] -> IO [SQLData]