-- Hoogle documentation, generated by Haddock
-- See Hoogle, http://www.haskell.org/hoogle/
-- | Low-level binding to SQLite3. Includes UTF8 and BLOB support.
--
-- This package is not very different from the other SQLite3 bindings out
-- there, but it fixes a few deficiencies I was finding. It is not as
-- complete as bindings-sqlite3, but is slightly higher-level, in that it
-- supports marshalling of data values to and from the database. In
-- particular, it supports strings encoded as UTF8, and BLOBs represented
-- as ByteStrings. Version 2.1 improves handling of invalid UTF-8 and
-- changes error handling to be more complete. It also adds a build flag
-- to build against the system sqlite instead of the bundled one,
-- optionally (disabled by default). Version 2.0 uses Text for strings
-- instead of String. Version 1.1.0.1 switches to the Faction packaging
-- system and makes no other changes. Version 1.1 adds the SQLite
-- amalgamation file (version 3.7.5) to the project, so that there are no
-- external dependencies.
@package direct-sqlite
@version 2.1
module Database.SQLite3
data Database
data Statement
data Error
ErrorOK :: Error
ErrorError :: Error
ErrorInternal :: Error
ErrorPermission :: Error
ErrorAbort :: Error
ErrorBusy :: Error
ErrorLocked :: Error
ErrorNoMemory :: Error
ErrorReadOnly :: Error
ErrorInterrupt :: Error
ErrorIO :: Error
ErrorNotFound :: Error
ErrorCorrupt :: Error
ErrorFull :: Error
ErrorCan'tOpen :: Error
ErrorProtocol :: Error
ErrorEmpty :: Error
ErrorSchema :: Error
ErrorTooBig :: Error
ErrorConstraint :: Error
ErrorMismatch :: Error
ErrorMisuse :: Error
ErrorNoLargeFileSupport :: Error
ErrorAuthorization :: Error
ErrorFormat :: Error
ErrorRange :: Error
ErrorNotADatabase :: Error
ErrorRow :: Error
ErrorDone :: Error
data StepResult
Row :: StepResult
Done :: StepResult
data SQLData
SQLInteger :: Int64 -> SQLData
SQLFloat :: Double -> SQLData
SQLText :: Text -> SQLData
SQLBlob :: ByteString -> SQLData
SQLNull :: SQLData
open :: String -> IO Database
close :: Database -> IO ()
prepare :: Database -> String -> IO Statement
step :: Statement -> IO StepResult
reset :: Statement -> IO ()
finalize :: Statement -> IO ()
-- | Find the number SQL parameters in a prepared statement.
bindParameterCount :: Statement -> IO Int
-- | 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.
bindParameterName :: Statement -> Int -> IO (Maybe String)
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 -> Text -> IO ()
bind :: Statement -> [SQLData] -> IO ()
column :: Statement -> Int -> IO SQLData
columns :: Statement -> IO [SQLData]
instance Typeable SQLData
instance Eq Error
instance Show Error
instance Eq StepResult
instance Show StepResult
instance Eq ColumnType
instance Show ColumnType
instance Eq SQLData
instance Show SQLData