Safe Haskell	None
Language	Haskell2010

Database.SQLite3.Direct

Contents

Connection management
Simple query execution
Statement management
Parameter and column information
Binding values to a prepared statement
Reading the result row
control loading of extensions
Result statistics
Create custom SQL functions
- Extract function arguments
- Set the result of a function
Create custom collations
Interrupting a long-running query
Incremental blob I/O
Online Backup API
Types
- Results and errors
- Special types

Description

This API is a slightly lower-level version of Database.SQLite3 . Namely:

It returns errors instead of throwing them.
It only uses cheap conversions. None of these bindings convert from String or Text .

Synopsis

open :: Utf8 -> IO ( Either ( Error , Utf8 ) Database )
close :: Database -> IO ( Either Error ())
errcode :: Database -> IO Error
errmsg :: Database -> IO Utf8
setTrace :: Database -> Maybe ( Utf8 -> IO ()) -> IO ()
getAutoCommit :: Database -> IO Bool
setSharedCacheEnabled :: Bool -> IO ( Either Error ())
exec :: Database -> Utf8 -> IO ( Either ( Error , Utf8 ) ())
execWithCallback :: Database -> Utf8 -> ExecCallback -> IO ( Either ( Error , Utf8 ) ())
type ExecCallback = ColumnCount -> [ Utf8 ] -> [ Maybe Utf8 ] -> IO ()
prepare :: Database -> Utf8 -> IO ( Either Error ( Maybe Statement ))
getStatementDatabase :: Statement -> IO Database
step :: Statement -> IO ( Either Error StepResult )
stepNoCB :: Statement -> IO ( Either Error StepResult )
reset :: Statement -> IO ( Either Error ())
finalize :: Statement -> IO ( Either Error ())
clearBindings :: Statement -> IO ()
statementSql :: Statement -> IO ( Maybe Utf8 )
bindParameterCount :: Statement -> IO ParamIndex
bindParameterName :: Statement -> ParamIndex -> IO ( Maybe Utf8 )
bindParameterIndex :: Statement -> Utf8 -> IO ( Maybe ParamIndex )
columnCount :: Statement -> IO ColumnCount
columnName :: Statement -> ColumnIndex -> IO ( Maybe Utf8 )
bindInt64 :: Statement -> ParamIndex -> Int64 -> IO ( Either Error ())
bindDouble :: Statement -> ParamIndex -> Double -> IO ( Either Error ())
bindText :: Statement -> ParamIndex -> Utf8 -> IO ( Either Error ())
bindBlob :: Statement -> ParamIndex -> ByteString -> IO ( Either Error ())
bindZeroBlob :: Statement -> ParamIndex -> Int -> IO ( Either Error ())
bindNull :: Statement -> ParamIndex -> IO ( Either Error ())
columnType :: Statement -> ColumnIndex -> IO ColumnType
columnInt64 :: Statement -> ColumnIndex -> IO Int64
columnDouble :: Statement -> ColumnIndex -> IO Double
columnText :: Statement -> ColumnIndex -> IO Utf8
columnBlob :: Statement -> ColumnIndex -> IO ByteString
setLoadExtensionEnabled :: Database -> Bool -> IO ( Either Error ())
lastInsertRowId :: Database -> IO Int64
changes :: Database -> IO Int
totalChanges :: Database -> IO Int
createFunction :: Database -> Utf8 -> Maybe ArgCount -> Bool -> ( FuncContext -> FuncArgs -> IO ()) -> IO ( Either Error ())
createAggregate :: Database -> Utf8 -> Maybe ArgCount -> a -> ( FuncContext -> FuncArgs -> a -> IO a) -> ( FuncContext -> a -> IO ()) -> IO ( Either Error ())
deleteFunction :: Database -> Utf8 -> Maybe ArgCount -> IO ( Either Error ())
funcArgCount :: FuncArgs -> ArgCount
funcArgType :: FuncArgs -> ArgIndex -> IO ColumnType
funcArgInt64 :: FuncArgs -> ArgIndex -> IO Int64
funcArgDouble :: FuncArgs -> ArgIndex -> IO Double
funcArgText :: FuncArgs -> ArgIndex -> IO Utf8
funcArgBlob :: FuncArgs -> ArgIndex -> IO ByteString
funcResultInt64 :: FuncContext -> Int64 -> IO ()
funcResultDouble :: FuncContext -> Double -> IO ()
funcResultText :: FuncContext -> Utf8 -> IO ()
funcResultBlob :: FuncContext -> ByteString -> IO ()
funcResultZeroBlob :: FuncContext -> Int -> IO ()
funcResultNull :: FuncContext -> IO ()
getFuncContextDatabase :: FuncContext -> IO Database
createCollation :: Database -> Utf8 -> ( Utf8 -> Utf8 -> Ordering ) -> IO ( Either Error ())
deleteCollation :: Database -> Utf8 -> IO ( Either Error ())
interrupt :: Database -> IO ()
blobOpen :: Database -> Utf8 -> Utf8 -> Utf8 -> Int64 -> Bool -> IO ( Either Error Blob )
blobClose :: Blob -> IO ( Either Error ())
blobReopen :: Blob -> Int64 -> IO ( Either Error ())
blobBytes :: Blob -> IO Int
blobRead :: Blob -> Int -> Int -> IO ( Either Error ByteString )
blobReadBuf :: Blob -> Ptr a -> Int -> Int -> IO ( Either Error ())
blobWrite :: Blob -> ByteString -> Int -> IO ( Either Error ())
backupInit :: Database -> Utf8 -> Database -> Utf8 -> IO ( Either Error Backup )
backupFinish :: Backup -> IO ( Either Error ())
backupStep :: Backup -> Int -> IO ( Either Error BackupStepResult )
backupRemaining :: Backup -> IO Int
backupPagecount :: Backup -> IO Int
newtype Database = Database ( Ptr CDatabase )
newtype Statement = Statement ( Ptr CStatement )
data ColumnType
- = IntegerColumn
- | FloatColumn
- | TextColumn
- | BlobColumn
- | NullColumn
newtype FuncContext = FuncContext ( Ptr CContext )
data FuncArgs = FuncArgs CArgCount ( Ptr ( Ptr CValue ))
data Blob = Blob Database ( Ptr CBlob )
data Backup = Backup Database ( Ptr CBackup )
data StepResult
- = Row
- | Done
data BackupStepResult
- = BackupOK
- | BackupDone
data Error
- = ErrorOK
- | ErrorError
- | ErrorInternal
- | ErrorPermission
- | ErrorAbort
- | ErrorBusy
- | ErrorLocked
- | ErrorNoMemory
- | ErrorReadOnly
- | ErrorInterrupt
- | ErrorIO
- | ErrorCorrupt
- | ErrorNotFound
- | ErrorFull
- | ErrorCan'tOpen
- | ErrorProtocol
- | ErrorEmpty
- | ErrorSchema
- | ErrorTooBig
- | ErrorConstraint
- | ErrorMismatch
- | ErrorMisuse
- | ErrorNoLargeFileSupport
- | ErrorAuthorization
- | ErrorFormat
- | ErrorRange
- | ErrorNotADatabase
- | ErrorNotice
- | ErrorWarning
- | ErrorRow
- | ErrorDone
newtype Utf8 = Utf8 ByteString
newtype ParamIndex = ParamIndex Int
newtype ColumnIndex = ColumnIndex Int
type ColumnCount = ColumnIndex
newtype ArgCount = ArgCount Int
type ArgIndex = ArgCount

Connection management

open :: Utf8 -> IO ( Either ( Error , Utf8 ) Database ) Source #

https://www.sqlite.org/c3ref/open.html

close :: Database -> IO ( Either Error ()) Source #

https://www.sqlite.org/c3ref/close.html

errcode :: Database -> IO Error Source #

https://www.sqlite.org/c3ref/errcode.html

errmsg :: Database -> IO Utf8 Source #

https://www.sqlite.org/c3ref/errcode.html

setTrace :: Database -> Maybe ( Utf8 -> IO ()) -> IO () Source #

https://www.sqlite.org/c3ref/profile.html

Enable/disable tracing of SQL execution. Tracing can be disabled by setting Nothing as the logger callback.

Warning: If the logger callback throws an exception, your whole program will crash. Enable only for debugging!

getAutoCommit :: Database -> IO Bool Source #

https://www.sqlite.org/c3ref/get_autocommit.html

Return True if the connection is in autocommit mode, or False if a transaction started with BEGIN is still active.

Be warned that some errors roll back the transaction automatically, and that ROLLBACK will throw an error if no transaction is active. Use getAutoCommit to avoid such an error:

 autocommit <- getAutoCommit conn
 when (not autocommit) $
     exec conn "ROLLBACK"

setSharedCacheEnabled :: Bool -> IO ( Either Error ()) Source #

https://www.sqlite.org/c3ref/enable_shared_cache.html

Enable or disable shared cache for all future connections.

Simple query execution

https://sqlite.org/c3ref/exec.html

exec :: Database -> Utf8 -> IO ( Either ( Error , Utf8 ) ()) Source #

https://www.sqlite.org/c3ref/exec.html

execWithCallback :: Database -> Utf8 -> ExecCallback -> IO ( Either ( Error , Utf8 ) ()) Source #

Like exec , but invoke the callback for each result row.

If the callback throws an exception, it will be rethrown by execWithCallback .

type ExecCallback Source #

Arguments

= ColumnCount	Number of columns, which is the number of items in the following lists. This will be the same for every row.
-> [ Utf8 ]	List of column names. This will be the same for every row.
-> [ Maybe Utf8 ]	List of column values, as returned by `columnText` .
-> IO ()

Statement management

prepare :: Database -> Utf8 -> IO ( Either Error ( Maybe Statement )) Source #

https://www.sqlite.org/c3ref/prepare.html

If the query contains no SQL statements, this returns Right Nothing .

getStatementDatabase :: Statement -> IO Database Source #

https://www.sqlite.org/c3ref/db_handle.html

step :: Statement -> IO ( Either Error StepResult ) Source #

https://www.sqlite.org/c3ref/step.html

stepNoCB :: Statement -> IO ( Either Error StepResult ) Source #

https://www.sqlite.org/c3ref/step.html

Faster step for statements that don't callback to Haskell functions (e.g. by using custom SQL functions).

reset :: Statement -> IO ( Either Error ()) Source #

https://www.sqlite.org/c3ref/reset.html

Warning:

If the most recent step call failed, this will return the corresponding error.
This does not reset the bindings on a prepared statement. Use clearBindings to do that.

finalize :: Statement -> IO ( Either Error ()) Source #

https://www.sqlite.org/c3ref/finalize.html

Warning: If the most recent step call failed, this will return the corresponding error.

clearBindings :: Statement -> IO () Source #

https://www.sqlite.org/c3ref/clear_bindings.html

Set all parameters in the prepared statement to null.

statementSql :: Statement -> IO ( Maybe Utf8 ) Source #

https://www.sqlite.org/c3ref/sql.html

Return a copy of the original SQL text used to compile the statement.

Parameter and column information

bindParameterCount :: Statement -> IO ParamIndex Source #

https://www.sqlite.org/c3ref/bind_parameter_count.html

This returns the index of the largest (rightmost) parameter. Note that this is not necessarily the number of parameters. If numbered parameters like ?5 are used, there may be gaps in the list.

See ParamIndex for more information.

bindParameterName :: Statement -> ParamIndex -> IO ( Maybe Utf8 ) Source #

https://www.sqlite.org/c3ref/bind_parameter_name.html

bindParameterIndex :: Statement -> Utf8 -> IO ( Maybe ParamIndex ) Source #

https://www.sqlite.org/c3ref/bind_parameter_index.html

columnCount :: Statement -> IO ColumnCount Source #

https://www.sqlite.org/c3ref/column_count.html

columnName :: Statement -> ColumnIndex -> IO ( Maybe Utf8 ) Source #

https://www.sqlite.org/c3ref/column_name.html

Binding values to a prepared statement

https://www.sqlite.org/c3ref/bind_blob.html

bindInt64 :: Statement -> ParamIndex -> Int64 -> IO ( Either Error ()) Source #

bindDouble :: Statement -> ParamIndex -> Double -> IO ( Either Error ()) Source #

bindText :: Statement -> ParamIndex -> Utf8 -> IO ( Either Error ()) Source #

bindBlob :: Statement -> ParamIndex -> ByteString -> IO ( Either Error ()) Source #

bindZeroBlob :: Statement -> ParamIndex -> Int -> IO ( Either Error ()) Source #

bindNull :: Statement -> ParamIndex -> IO ( Either Error ()) Source #

Reading the result row

https://www.sqlite.org/c3ref/column_blob.html

columnType :: Statement -> ColumnIndex -> IO ColumnType Source #

columnInt64 :: Statement -> ColumnIndex -> IO Int64 Source #

columnDouble :: Statement -> ColumnIndex -> IO Double Source #

columnText :: Statement -> ColumnIndex -> IO Utf8 Source #

columnBlob :: Statement -> ColumnIndex -> IO ByteString Source #

control loading of extensions

setLoadExtensionEnabled :: Database -> Bool -> IO ( Either Error ()) Source #

https://www.sqlite.org/c3ref/enable_load_extension.html

Enable or disable extension loading.

Result statistics

lastInsertRowId :: Database -> IO Int64 Source #

https://www.sqlite.org/c3ref/last_insert_rowid.html

changes :: Database -> IO Int Source #

https://www.sqlite.org/c3ref/changes.html

Return the number of rows that were changed, inserted, or deleted by the most recent INSERT , DELETE , or UPDATE statement.

totalChanges :: Database -> IO Int Source #

https://www.sqlite.org/c3ref/total_changes.html

Return the total number of row changes caused by INSERT , DELETE , or UPDATE statements since the Database was opened.

Create custom SQL functions

createFunction Source #

Arguments

:: Database
-> Utf8	Name of the function.
-> Maybe ArgCount	Number of arguments. `Nothing` means that the function accepts any number of arguments.
-> Bool	Is the function deterministic?
-> ( FuncContext -> FuncArgs -> IO ())	Implementation of the function.
-> IO ( Either Error ())

https://sqlite.org/c3ref/create_function.html

Create a custom SQL function or redefine the behavior of an existing function.

createAggregate Source #

Arguments

:: Database
-> Utf8	Name of the function.
-> Maybe ArgCount	Number of arguments.
-> a	Initial aggregate state.
-> ( FuncContext -> FuncArgs -> a -> IO a)	Process one row and update the aggregate state.
-> ( FuncContext -> a -> IO ())	Called after all rows have been processed. Can be used to construct the returned value from the aggregate state.
-> IO ( Either Error ())

Like createFunction except that it creates an aggregate function.

deleteFunction :: Database -> Utf8 -> Maybe ArgCount -> IO ( Either Error ()) Source #

Delete an SQL function (scalar or aggregate).

Extract function arguments

funcArgCount :: FuncArgs -> ArgCount Source #

funcArgType :: FuncArgs -> ArgIndex -> IO ColumnType Source #

funcArgInt64 :: FuncArgs -> ArgIndex -> IO Int64 Source #

funcArgDouble :: FuncArgs -> ArgIndex -> IO Double Source #

funcArgText :: FuncArgs -> ArgIndex -> IO Utf8 Source #

funcArgBlob :: FuncArgs -> ArgIndex -> IO ByteString Source #

Set the result of a function

funcResultInt64 :: FuncContext -> Int64 -> IO () Source #

funcResultDouble :: FuncContext -> Double -> IO () Source #

funcResultText :: FuncContext -> Utf8 -> IO () Source #

funcResultBlob :: FuncContext -> ByteString -> IO () Source #

funcResultZeroBlob :: FuncContext -> Int -> IO () Source #

funcResultNull :: FuncContext -> IO () Source #

getFuncContextDatabase :: FuncContext -> IO Database Source #

https://www.sqlite.org/c3ref/context_db_handle.html

Create custom collations

createCollation Source #

Arguments

:: Database
-> Utf8	Name of the collation.
-> ( Utf8 -> Utf8 -> Ordering )	Comparison function.
-> IO ( Either Error ())

https://www.sqlite.org/c3ref/create_collation.html

deleteCollation :: Database -> Utf8 -> IO ( Either Error ()) Source #

Delete a collation.

Interrupting a long-running query

interrupt :: Database -> IO () Source #

https://www.sqlite.org/c3ref/interrupt.html

Cause any pending operation on the Database handle to stop at its earliest opportunity. This simply sets a flag and returns immediately. It does not wait for the pending operation to finish.

You'll need to compile with -threaded for this to do any good. Without -threaded , FFI calls block the whole RTS, meaning interrupt would never run at the same time as step .

Incremental blob I/O

blobOpen Source #

Arguments

:: Database
-> Utf8	The symbolic name of the database (e.g. "main").
-> Utf8	The table name.
-> Utf8	The column name.
-> Int64	The `ROWID` of the row.
-> Bool	Open the blob for read-write.
-> IO ( Either Error Blob )

https://www.sqlite.org/c3ref/blob_open.html

Open a blob for incremental I/O.

blobClose :: Blob -> IO ( Either Error ()) Source #

https://www.sqlite.org/c3ref/blob_close.html

blobReopen Source #

Arguments

:: Blob
-> Int64	The `ROWID` of the row.
-> IO ( Either Error ())

https://www.sqlite.org/c3ref/blob_reopen.html

blobBytes :: Blob -> IO Int Source #

https://www.sqlite.org/c3ref/blob_bytes.html

blobRead Source #

Arguments

:: Blob
-> Int	Number of bytes to read.
-> Int	Offset within the blob.
-> IO ( Either Error ByteString )

https://www.sqlite.org/c3ref/blob_read.html

blobReadBuf :: Blob -> Ptr a -> Int -> Int -> IO ( Either Error ()) Source #

blobWrite Source #

Arguments

:: Blob
-> ByteString
-> Int	Offset within the blob.
-> IO ( Either Error ())

https://www.sqlite.org/c3ref/blob_write.html

Online Backup API

https://www.sqlite.org/backup.html and https://www.sqlite.org/c3ref/backup_finish.html

backupInit Source #

Arguments

:: Database	Destination database handle.
-> Utf8	Destination database name.
-> Database	Source database handle.
-> Utf8	Source database name.
-> IO ( Either Error Backup )

https://www.sqlite.org/c3ref/backup_finish.html#sqlite3backupinit

backupFinish :: Backup -> IO ( Either Error ()) Source #

https://www.sqlite.org/c3ref/backup_finish.html#sqlite3backupfinish

backupStep Source #

Arguments

:: Backup
-> Int	Number of pages to copy; if negative, all remaining source pages are copied.
-> IO ( Either Error BackupStepResult )

https://www.sqlite.org/c3ref/backup_finish.html#sqlite3backupstep

backupRemaining :: Backup -> IO Int Source #

https://www.sqlite.org/c3ref/backup_finish.html#sqlite3backupremaining

backupPagecount :: Backup -> IO Int Source #

https://www.sqlite.org/c3ref/backup_finish.html#sqlite3backuppagecount

Types

newtype Database Source #

Constructors

Database ( Ptr CDatabase )

Instances

Instances details

Eq Database Source #
Instance details Defined in Database.SQLite3.Direct Methods (==) :: Database -> Database -> Bool Source # (/=) :: Database -> Database -> Bool Source #
Show Database Source #
Instance details Defined in Database.SQLite3.Direct Methods showsPrec :: Int -> Database -> ShowS Source # show :: Database -> String Source # showList :: [ Database ] -> ShowS Source #

newtype Statement Source #

Constructors

Statement ( Ptr CStatement )

Instances

Instances details

Eq Statement Source #
Instance details Defined in Database.SQLite3.Direct Methods (==) :: Statement -> Statement -> Bool Source # (/=) :: Statement -> Statement -> Bool Source #
Show Statement Source #
Instance details Defined in Database.SQLite3.Direct Methods showsPrec :: Int -> Statement -> ShowS Source # show :: Statement -> String Source # showList :: [ Statement ] -> ShowS Source #

data ColumnType Source #

https://www.sqlite.org/c3ref/c_blob.html

Constructors

IntegerColumn
FloatColumn
TextColumn
BlobColumn
NullColumn

Instances

Instances details

Eq ColumnType Source #
Instance details Defined in Database.SQLite3.Bindings.Types Methods (==) :: ColumnType -> ColumnType -> Bool Source # (/=) :: ColumnType -> ColumnType -> Bool Source #
Show ColumnType Source #
Instance details Defined in Database.SQLite3.Bindings.Types Methods showsPrec :: Int -> ColumnType -> ShowS Source # show :: ColumnType -> String Source # showList :: [ ColumnType ] -> ShowS Source #
FFIType ColumnType CColumnType Source #
Instance details Defined in Database.SQLite3.Bindings.Types Methods toFFI :: ColumnType -> CColumnType Source # fromFFI :: CColumnType -> ColumnType Source #

newtype FuncContext Source #

The context in which a custom SQL function is executed.

Constructors

FuncContext ( Ptr CContext )

Instances

Instances details

Eq FuncContext Source #
Instance details Defined in Database.SQLite3.Direct Methods (==) :: FuncContext -> FuncContext -> Bool Source # (/=) :: FuncContext -> FuncContext -> Bool Source #
Show FuncContext Source #
Instance details Defined in Database.SQLite3.Direct Methods showsPrec :: Int -> FuncContext -> ShowS Source # show :: FuncContext -> String Source # showList :: [ FuncContext ] -> ShowS Source #

data FuncArgs Source #

The arguments of a custom SQL function.

Constructors

FuncArgs CArgCount ( Ptr ( Ptr CValue ))

data Blob Source #

The type of blob handles used for incremental blob I/O

Constructors

Blob Database ( Ptr CBlob )

Instances

Instances details

Eq Blob Source #
Instance details Defined in Database.SQLite3.Direct Methods (==) :: Blob -> Blob -> Bool Source # (/=) :: Blob -> Blob -> Bool Source #
Show Blob Source #
Instance details Defined in Database.SQLite3.Direct Methods showsPrec :: Int -> Blob -> ShowS Source # show :: Blob -> String Source # showList :: [ Blob ] -> ShowS Source #

data Backup Source #

A handle for an online backup process.

Constructors

Backup Database ( Ptr CBackup )

Instances

Instances details

Eq Backup Source #
Instance details Defined in Database.SQLite3.Direct Methods (==) :: Backup -> Backup -> Bool Source # (/=) :: Backup -> Backup -> Bool Source #
Show Backup Source #
Instance details Defined in Database.SQLite3.Direct Methods showsPrec :: Int -> Backup -> ShowS Source # show :: Backup -> String Source # showList :: [ Backup ] -> ShowS Source #

Results and errors

data StepResult Source #

Constructors

Row
Done

Instances

Instances details

Eq StepResult Source #
Instance details Defined in Database.SQLite3.Direct Methods (==) :: StepResult -> StepResult -> Bool Source # (/=) :: StepResult -> StepResult -> Bool Source #
Show StepResult Source #
Instance details Defined in Database.SQLite3.Direct Methods showsPrec :: Int -> StepResult -> ShowS Source # show :: StepResult -> String Source # showList :: [ StepResult ] -> ShowS Source #

data BackupStepResult Source #

Constructors

BackupOK	There are still more pages to be copied.
BackupDone	All pages were successfully copied.

Instances

Instances details

Eq BackupStepResult Source #
Instance details Defined in Database.SQLite3.Direct Methods (==) :: BackupStepResult -> BackupStepResult -> Bool Source # (/=) :: BackupStepResult -> BackupStepResult -> Bool Source #
Show BackupStepResult Source #
Instance details Defined in Database.SQLite3.Direct Methods showsPrec :: Int -> BackupStepResult -> ShowS Source # show :: BackupStepResult -> String Source # showList :: [ BackupStepResult ] -> ShowS Source #

data Error Source #

https://www.sqlite.org/c3ref/c_abort.html

Constructors

ErrorOK	Successful result
ErrorError	SQL error or missing database
ErrorInternal	Internal logic error in SQLite
ErrorPermission	Access permission denied
ErrorAbort	Callback routine requested an abort
ErrorBusy	The database file is locked
ErrorLocked	A table in the database is locked
ErrorNoMemory	A `malloc()` failed
ErrorReadOnly	Attempt to write a readonly database
ErrorInterrupt	Operation terminated by `sqlite3_interrupt()`
ErrorIO	Some kind of disk I/O error occurred
ErrorCorrupt	The database disk image is malformed
ErrorNotFound	Unknown opcode in `sqlite3_file_control()`
ErrorFull	Insertion failed because database is full
ErrorCan'tOpen	Unable to open the database file
ErrorProtocol	Database lock protocol error
ErrorEmpty	Database is empty
ErrorSchema	The database schema changed
ErrorTooBig	String or BLOB exceeds size limit
ErrorConstraint	Abort due to constraint violation
ErrorMismatch	Data type mismatch
ErrorMisuse	Library used incorrectly
ErrorNoLargeFileSupport	Uses OS features not supported on host
ErrorAuthorization	Authorization denied
ErrorFormat	Auxiliary database format error
ErrorRange	2nd parameter to sqlite3_bind out of range
ErrorNotADatabase	File opened that is not a database file
ErrorNotice	Notifications from sqlite3_log()
ErrorWarning	Warnings from sqlite3_log()
ErrorRow	`sqlite3_step()` has another row ready
ErrorDone	`sqlite3_step()` has finished executing

Instances

Instances details

Eq Error Source #
Instance details Defined in Database.SQLite3.Bindings.Types Methods (==) :: Error -> Error -> Bool Source # (/=) :: Error -> Error -> Bool Source #
Show Error Source #
Instance details Defined in Database.SQLite3.Bindings.Types Methods showsPrec :: Int -> Error -> ShowS Source # show :: Error -> String Source # showList :: [ Error ] -> ShowS Source #
FFIType Error CError Source #
Instance details Defined in Database.SQLite3.Bindings.Types Methods toFFI :: Error -> CError Source # fromFFI :: CError -> Error Source #

Special types

newtype Utf8 Source #

A ByteString containing UTF8-encoded text with no NUL characters.

Constructors

Utf8 ByteString

Instances

Instances details

Eq Utf8 Source #
Instance details Defined in Database.SQLite3.Direct Methods (==) :: Utf8 -> Utf8 -> Bool Source # (/=) :: Utf8 -> Utf8 -> Bool Source #
Ord Utf8 Source #
Instance details Defined in Database.SQLite3.Direct Methods compare :: Utf8 -> Utf8 -> Ordering Source # (<) :: Utf8 -> Utf8 -> Bool Source # (<=) :: Utf8 -> Utf8 -> Bool Source # (>) :: Utf8 -> Utf8 -> Bool Source # (>=) :: Utf8 -> Utf8 -> Bool Source # max :: Utf8 -> Utf8 -> Utf8 Source # min :: Utf8 -> Utf8 -> Utf8 Source #
Show Utf8 Source #
Instance details Defined in Database.SQLite3.Direct Methods showsPrec :: Int -> Utf8 -> ShowS Source # show :: Utf8 -> String Source # showList :: [ Utf8 ] -> ShowS Source #
IsString Utf8 Source #	fromString = Utf8 . `encodeUtf8` . `pack`
Instance details Defined in Database.SQLite3.Direct Methods fromString :: String -> Utf8 Source #
Semigroup Utf8 Source #
Instance details Defined in Database.SQLite3.Direct Methods (<>) :: Utf8 -> Utf8 -> Utf8 Source # sconcat :: NonEmpty Utf8 -> Utf8 Source # stimes :: Integral b => b -> Utf8 -> Utf8 Source #
Monoid Utf8 Source #
Instance details Defined in Database.SQLite3.Direct Methods mempty :: Utf8 Source # mappend :: Utf8 -> Utf8 -> Utf8 Source # mconcat :: [ Utf8 ] -> Utf8 Source #

newtype ParamIndex Source #

Index of a parameter in a parameterized query. Parameter indices start from 1.

When a query is prepare d, SQLite allocates an array indexed from 1 to the highest parameter index. For example:

>Right stmt <- prepare conn "SELECT ?1, ?5, ?3, ?"
>bindParameterCount stmt
ParamIndex 6

This will allocate an array indexed from 1 to 6 ( ? takes the highest preceding index plus one). The array is initialized with null values. When you bind a parameter with bindSQLData , it assigns a new value to one of these indices.

See https://www.sqlite.org/lang_expr.html#varparam for the syntax of parameter placeholders, and how parameter indices are assigned.

Constructors

ParamIndex Int

Instances

Instances details

Bounded ParamIndex Source #	Limit min/max bounds to fit into SQLite's native parameter ranges.
Instance details Defined in Database.SQLite3.Bindings.Types Methods minBound :: ParamIndex Source # maxBound :: ParamIndex Source #
Enum ParamIndex Source #
Instance details Defined in Database.SQLite3.Bindings.Types Methods succ :: ParamIndex -> ParamIndex Source # pred :: ParamIndex -> ParamIndex Source # toEnum :: Int -> ParamIndex Source # fromEnum :: ParamIndex -> Int Source # enumFrom :: ParamIndex -> [ ParamIndex ] Source # enumFromThen :: ParamIndex -> ParamIndex -> [ ParamIndex ] Source # enumFromTo :: ParamIndex -> ParamIndex -> [ ParamIndex ] Source # enumFromThenTo :: ParamIndex -> ParamIndex -> ParamIndex -> [ ParamIndex ] Source #
Eq ParamIndex Source #
Instance details Defined in Database.SQLite3.Bindings.Types Methods (==) :: ParamIndex -> ParamIndex -> Bool Source # (/=) :: ParamIndex -> ParamIndex -> Bool Source #
Integral ParamIndex Source #
Instance details Defined in Database.SQLite3.Bindings.Types Methods quot :: ParamIndex -> ParamIndex -> ParamIndex Source # rem :: ParamIndex -> ParamIndex -> ParamIndex Source # div :: ParamIndex -> ParamIndex -> ParamIndex Source # mod :: ParamIndex -> ParamIndex -> ParamIndex Source # quotRem :: ParamIndex -> ParamIndex -> ( ParamIndex , ParamIndex ) Source # divMod :: ParamIndex -> ParamIndex -> ( ParamIndex , ParamIndex ) Source # toInteger :: ParamIndex -> Integer Source #
Num ParamIndex Source #
Instance details Defined in Database.SQLite3.Bindings.Types Methods (+) :: ParamIndex -> ParamIndex -> ParamIndex Source # (-) :: ParamIndex -> ParamIndex -> ParamIndex Source # (*) :: ParamIndex -> ParamIndex -> ParamIndex Source # negate :: ParamIndex -> ParamIndex Source # abs :: ParamIndex -> ParamIndex Source # signum :: ParamIndex -> ParamIndex Source # fromInteger :: Integer -> ParamIndex Source #
Ord ParamIndex Source #
Instance details Defined in Database.SQLite3.Bindings.Types Methods compare :: ParamIndex -> ParamIndex -> Ordering Source # (<) :: ParamIndex -> ParamIndex -> Bool Source # (<=) :: ParamIndex -> ParamIndex -> Bool Source # (>) :: ParamIndex -> ParamIndex -> Bool Source # (>=) :: ParamIndex -> ParamIndex -> Bool Source # max :: ParamIndex -> ParamIndex -> ParamIndex Source # min :: ParamIndex -> ParamIndex -> ParamIndex Source #
Real ParamIndex Source #
Instance details Defined in Database.SQLite3.Bindings.Types Methods toRational :: ParamIndex -> Rational Source #
Show ParamIndex Source #	This just shows the underlying integer, without the data constructor.
Instance details Defined in Database.SQLite3.Bindings.Types Methods showsPrec :: Int -> ParamIndex -> ShowS Source # show :: ParamIndex -> String Source # showList :: [ ParamIndex ] -> ShowS Source #
FFIType ParamIndex CParamIndex Source #
Instance details Defined in Database.SQLite3.Bindings.Types Methods toFFI :: ParamIndex -> CParamIndex Source # fromFFI :: CParamIndex -> ParamIndex Source #

newtype ColumnIndex Source #

Index of a column in a result set. Column indices start from 0.

Constructors

ColumnIndex Int

Instances

Instances details

Bounded ColumnIndex Source #	Limit min/max bounds to fit into SQLite's native parameter ranges.
Instance details Defined in Database.SQLite3.Bindings.Types Methods minBound :: ColumnIndex Source # maxBound :: ColumnIndex Source #
Enum ColumnIndex Source #
Instance details Defined in Database.SQLite3.Bindings.Types Methods succ :: ColumnIndex -> ColumnIndex Source # pred :: ColumnIndex -> ColumnIndex Source # toEnum :: Int -> ColumnIndex Source # fromEnum :: ColumnIndex -> Int Source # enumFrom :: ColumnIndex -> [ ColumnIndex ] Source # enumFromThen :: ColumnIndex -> ColumnIndex -> [ ColumnIndex ] Source # enumFromTo :: ColumnIndex -> ColumnIndex -> [ ColumnIndex ] Source # enumFromThenTo :: ColumnIndex -> ColumnIndex -> ColumnIndex -> [ ColumnIndex ] Source #
Eq ColumnIndex Source #
Instance details Defined in Database.SQLite3.Bindings.Types Methods (==) :: ColumnIndex -> ColumnIndex -> Bool Source # (/=) :: ColumnIndex -> ColumnIndex -> Bool Source #
Integral ColumnIndex Source #
Instance details Defined in Database.SQLite3.Bindings.Types Methods quot :: ColumnIndex -> ColumnIndex -> ColumnIndex Source # rem :: ColumnIndex -> ColumnIndex -> ColumnIndex Source # div :: ColumnIndex -> ColumnIndex -> ColumnIndex Source # mod :: ColumnIndex -> ColumnIndex -> ColumnIndex Source # quotRem :: ColumnIndex -> ColumnIndex -> ( ColumnIndex , ColumnIndex ) Source # divMod :: ColumnIndex -> ColumnIndex -> ( ColumnIndex , ColumnIndex ) Source # toInteger :: ColumnIndex -> Integer Source #
Num ColumnIndex Source #
Instance details Defined in Database.SQLite3.Bindings.Types Methods (+) :: ColumnIndex -> ColumnIndex -> ColumnIndex Source # (-) :: ColumnIndex -> ColumnIndex -> ColumnIndex Source # (*) :: ColumnIndex -> ColumnIndex -> ColumnIndex Source # negate :: ColumnIndex -> ColumnIndex Source # abs :: ColumnIndex -> ColumnIndex Source # signum :: ColumnIndex -> ColumnIndex Source # fromInteger :: Integer -> ColumnIndex Source #
Ord ColumnIndex Source #
Instance details Defined in Database.SQLite3.Bindings.Types Methods compare :: ColumnIndex -> ColumnIndex -> Ordering Source # (<) :: ColumnIndex -> ColumnIndex -> Bool Source # (<=) :: ColumnIndex -> ColumnIndex -> Bool Source # (>) :: ColumnIndex -> ColumnIndex -> Bool Source # (>=) :: ColumnIndex -> ColumnIndex -> Bool Source # max :: ColumnIndex -> ColumnIndex -> ColumnIndex Source # min :: ColumnIndex -> ColumnIndex -> ColumnIndex Source #
Real ColumnIndex Source #
Instance details Defined in Database.SQLite3.Bindings.Types Methods toRational :: ColumnIndex -> Rational Source #
Show ColumnIndex Source #	This just shows the underlying integer, without the data constructor.
Instance details Defined in Database.SQLite3.Bindings.Types Methods showsPrec :: Int -> ColumnIndex -> ShowS Source # show :: ColumnIndex -> String Source # showList :: [ ColumnIndex ] -> ShowS Source #
FFIType ColumnIndex CColumnIndex Source #
Instance details Defined in Database.SQLite3.Bindings.Types Methods toFFI :: ColumnIndex -> CColumnIndex Source # fromFFI :: CColumnIndex -> ColumnIndex Source #

type ColumnCount = ColumnIndex Source #

Number of columns in a result set.

newtype ArgCount Source #

Number of arguments of a user defined SQL function.

Constructors

ArgCount Int

Instances

Instances details

Bounded ArgCount Source #
Instance details Defined in Database.SQLite3.Bindings.Types Methods minBound :: ArgCount Source # maxBound :: ArgCount Source #
Enum ArgCount Source #
Instance details Defined in Database.SQLite3.Bindings.Types Methods succ :: ArgCount -> ArgCount Source # pred :: ArgCount -> ArgCount Source # toEnum :: Int -> ArgCount Source # fromEnum :: ArgCount -> Int Source # enumFrom :: ArgCount -> [ ArgCount ] Source # enumFromThen :: ArgCount -> ArgCount -> [ ArgCount ] Source # enumFromTo :: ArgCount -> ArgCount -> [ ArgCount ] Source # enumFromThenTo :: ArgCount -> ArgCount -> ArgCount -> [ ArgCount ] Source #
Eq ArgCount Source #
Instance details Defined in Database.SQLite3.Bindings.Types Methods (==) :: ArgCount -> ArgCount -> Bool Source # (/=) :: ArgCount -> ArgCount -> Bool Source #
Integral ArgCount Source #
Instance details Defined in Database.SQLite3.Bindings.Types Methods quot :: ArgCount -> ArgCount -> ArgCount Source # rem :: ArgCount -> ArgCount -> ArgCount Source # div :: ArgCount -> ArgCount -> ArgCount Source # mod :: ArgCount -> ArgCount -> ArgCount Source # quotRem :: ArgCount -> ArgCount -> ( ArgCount , ArgCount ) Source # divMod :: ArgCount -> ArgCount -> ( ArgCount , ArgCount ) Source # toInteger :: ArgCount -> Integer Source #
Num ArgCount Source #
Instance details Defined in Database.SQLite3.Bindings.Types Methods (+) :: ArgCount -> ArgCount -> ArgCount Source # (-) :: ArgCount -> ArgCount -> ArgCount Source # (*) :: ArgCount -> ArgCount -> ArgCount Source # negate :: ArgCount -> ArgCount Source # abs :: ArgCount -> ArgCount Source # signum :: ArgCount -> ArgCount Source # fromInteger :: Integer -> ArgCount Source #
Ord ArgCount Source #
Instance details Defined in Database.SQLite3.Bindings.Types Methods compare :: ArgCount -> ArgCount -> Ordering Source # (<) :: ArgCount -> ArgCount -> Bool Source # (<=) :: ArgCount -> ArgCount -> Bool Source # (>) :: ArgCount -> ArgCount -> Bool Source # (>=) :: ArgCount -> ArgCount -> Bool Source # max :: ArgCount -> ArgCount -> ArgCount Source # min :: ArgCount -> ArgCount -> ArgCount Source #
Real ArgCount Source #
Instance details Defined in Database.SQLite3.Bindings.Types Methods toRational :: ArgCount -> Rational Source #
Show ArgCount Source #	This just shows the underlying integer, without the data constructor.
Instance details Defined in Database.SQLite3.Bindings.Types Methods showsPrec :: Int -> ArgCount -> ShowS Source # show :: ArgCount -> String Source # showList :: [ ArgCount ] -> ShowS Source #
FFIType ArgCount CArgCount Source #
Instance details Defined in Database.SQLite3.Bindings.Types Methods toFFI :: ArgCount -> CArgCount Source # fromFFI :: CArgCount -> ArgCount Source #

type ArgIndex = ArgCount Source #

Index of an argument to a custom function. Indices start from 0.