direct-sqlite-2.1: Low-level binding to SQLite3. Includes UTF8 and BLOB support.

Safe Haskell	None

Database.SQLite3

Synopsis

Documentation

data Database Source

data Statement Source

data StepResult Source

Constructors

Row
Done

Instances

Eq StepResult
Show StepResult

data SQLData Source

Constructors

SQLInteger Int64
SQLFloat Double
SQLText Text
SQLBlob ByteString
SQLNull

Instances

Eq SQLData
Show SQLData
Typeable SQLData

open :: String -> IO Database Source

close :: Database -> IO ()Source

prepare :: Database -> String -> IO Statement Source

step :: Statement -> IO StepResult Source

reset :: Statement -> IO ()Source

finalize :: Statement -> IO ()Source

bindParameterCount :: Statement -> IO Int Source

Find the number SQL parameters in a prepared statement.

bindParameterName :: Statement -> Int -> IO (Maybe String)Source

Return the N-th SQL parameter name.

Named parameters are returned as-is. E.g. ":v" is returned as Just ":v". Unnamed parameters, however, are converted to Nothing.

Note that the column index starts at 1, not 0.

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

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

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

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

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

bindText :: Statement -> Int -> Text -> IO ()Source

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

column :: Statement -> Int -> IO SQLData Source

columns :: Statement -> IO [SQLData]Source