:: Ptr CDatabase
-> FunPtr (CTraceCallback a)	Optional callback function called for each row
-> Ptr a	Context passed to the callback
-> IO (Ptr ())	Returns context pointer from previously registered trace

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

type CTraceCallback a Source #

Arguments

= Ptr a
-> CString	UTF-8 rendering of the SQL statement text as the statement first begins executing
-> IO ()

mkCTraceCallback :: CTraceCallback a -> IO (FunPtr (CTraceCallback a)) Source #

c_sqlite3_get_autocommit :: Ptr CDatabase -> IO CInt Source #

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

c_sqlite3_enable_shared_cache :: CInt -> IO CError Source #

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

Simple query execution

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

c_sqlite3_exec Source #

Arguments

:: Ptr CDatabase
-> CString	SQL statement, UTF-8 encoded
-> FunPtr (CExecCallback a)	Optional callback function called for each row
-> Ptr a	Context passed to the callback
-> Ptr CString	OUT: Error message string
-> IO CError

type CExecCallback a Source #

Arguments

= Ptr a
-> CColumnCount	Number of columns, which is the number of elements in the following arrays.
-> Ptr CString	Array of column values, as returned by `c_sqlite3_column_text`. Null values are represented as null pointers.
-> Ptr CString	Array of column names
-> IO CInt	If the callback returns non-zero, then `c_sqlite3_exec` returns `SQLITE_ABORT` (`ErrorAbort`).

mkCExecCallback :: CExecCallback a -> IO (FunPtr (CExecCallback a)) Source #

A couple important things to know about callbacks from Haskell code:

If the callback throws an exception, apparently, the whole program is terminated.
Remember to call freeHaskellFunPtr when you are done with the wrapper, to avoid leaking memory.

Statement management

c_sqlite3_prepare_v2 Source #

Arguments

:: Ptr CDatabase
-> CString	SQL statement, UTF-8 encoded
-> CNumBytes	Maximum length of the SQL statement, in bytes. If this is negative, then the SQL statement is treated as a NUL-terminated string.
-> Ptr (Ptr CStatement)	OUT: Statement handle. This must not be null.
-> Ptr CString	OUT: Pointer to unused portion of zSql
-> IO CError

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

If the query contains no SQL statements, this returns SQLITE_OK and sets the Ptr CStatement to null.

c_sqlite3_db_handle :: Ptr CStatement -> IO (Ptr CDatabase) Source #

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

c_sqlite3_step :: Ptr CStatement -> IO CError Source #

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

c_sqlite3_reset :: Ptr CStatement -> IO CError Source #

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

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

c_sqlite3_finalize :: Ptr CStatement -> IO CError Source #

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

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

c_sqlite3_clear_bindings :: Ptr CStatement -> IO CError Source #

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

A look at the source reveals that this function always returns SQLITE_OK.

c_sqlite3_sql :: Ptr CStatement -> IO CString Source #

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

Parameter and column information

c_sqlite3_bind_parameter_count :: Ptr CStatement -> IO CParamIndex Source #

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

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

c_sqlite3_bind_parameter_name :: Ptr CStatement -> CParamIndex -> IO CString Source #

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

c_sqlite3_bind_parameter_index :: Ptr CStatement -> CString -> IO CParamIndex Source #

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

c_sqlite3_column_count :: Ptr CStatement -> IO CColumnCount Source #

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

c_sqlite3_column_name :: Ptr CStatement -> CColumnIndex -> IO CString Source #

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

Binding Values To Prepared Statements

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

c_sqlite3_bind_blob Source #

Arguments

:: Ptr CStatement
-> CParamIndex	Index of the SQL parameter to be set
-> Ptr a	Value to bind to the parameter. Warning: If this pointer is `NULL`, this will bind a null value, rather than an empty blob.
-> CNumBytes	Length, in bytes. This must not be negative.
-> Ptr CDestructor
-> IO CError

c_sqlite3_bind_zeroblob :: Ptr CStatement -> CParamIndex -> CInt -> IO CError Source #

c_sqlite3_bind_text Source #

Arguments

:: Ptr CStatement
-> CParamIndex
-> CString	Warning: If this pointer is `NULL`, this will bind a null value, rather than an empty text.
-> CNumBytes	Length, in bytes. If this is negative, the value is treated as a NUL-terminated string.
-> Ptr CDestructor
-> IO CError

c_sqlite3_bind_double :: Ptr CStatement -> CParamIndex -> Double -> IO CError Source #

c_sqlite3_bind_int64 :: Ptr CStatement -> CParamIndex -> Int64 -> IO CError Source #

c_sqlite3_bind_null :: Ptr CStatement -> CParamIndex -> IO CError Source #

Result Values From A Query

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

c_sqlite3_column_type :: Ptr CStatement -> CColumnIndex -> IO CColumnType Source #

c_sqlite3_column_bytes :: Ptr CStatement -> CColumnIndex -> IO CNumBytes Source #

c_sqlite3_column_blob :: Ptr CStatement -> CColumnIndex -> IO (Ptr a) Source #

c_sqlite3_column_int64 :: Ptr CStatement -> CColumnIndex -> IO Int64 Source #

c_sqlite3_column_double :: Ptr CStatement -> CColumnIndex -> IO Double Source #

c_sqlite3_column_text :: Ptr CStatement -> CColumnIndex -> IO CString Source #

Result statistics

c_sqlite3_last_insert_rowid :: Ptr CDatabase -> IO Int64 Source #

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

c_sqlite3_changes :: Ptr CDatabase -> IO CInt Source #

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

c_sqlite3_total_changes :: Ptr CDatabase -> IO CInt Source #

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

Create Or Redefine SQL Functions

c_sqlite3_create_function_v2 Source #

Arguments

:: Ptr CDatabase
-> CString	Name of the function
-> CArgCount	Number of arguments
-> CInt	Preferred text encoding (also used to pass flags)
-> Ptr a	User data
-> FunPtr CFunc
-> FunPtr CFunc
-> FunPtr CFuncFinal
-> FunPtr (CFuncDestroy a)
-> IO CError

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

type CFunc = Ptr CContext -> CArgCount -> Ptr (Ptr CValue) -> IO () Source #

type CFuncFinal = Ptr CContext -> IO () Source #

type CFuncDestroy a = Ptr a -> IO () Source #

mkCFunc :: CFunc -> IO (FunPtr CFunc) Source #

mkCFuncFinal :: CFuncFinal -> IO (FunPtr CFuncFinal) Source #

mkCFuncDestroy :: CFuncDestroy a -> IO (FunPtr (CFuncDestroy a)) Source #

c_sqlite3_user_data :: Ptr CContext -> IO (Ptr a) Source #

http://www.sqlite.org/c3ref/user_data.html

c_sqlite3_context_db_handle :: Ptr CContext -> IO (Ptr CDatabase) Source #

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

c_sqlite3_aggregate_context :: Ptr CContext -> CNumBytes -> IO (Ptr a) Source #

http://www.sqlite.org/c3ref/aggregate_context.html

Obtaining SQL Function Parameter Values

http://www.sqlite.org/c3ref/value_blob.html

c_sqlite3_value_type :: Ptr CValue -> IO CColumnType Source #

c_sqlite3_value_bytes :: Ptr CValue -> IO CNumBytes Source #

c_sqlite3_value_blob :: Ptr CValue -> IO (Ptr a) Source #

c_sqlite3_value_text :: Ptr CValue -> IO CString Source #

c_sqlite3_value_int64 :: Ptr CValue -> IO Int64 Source #

c_sqlite3_value_double :: Ptr CValue -> IO Double Source #

Setting The Result Of An SQL Function

http://www.sqlite.org/c3ref/result_blob.html

c_sqlite3_result_null :: Ptr CContext -> IO () Source #

c_sqlite3_result_blob :: Ptr CContext -> Ptr a -> CNumBytes -> Ptr CDestructor -> IO () Source #

c_sqlite3_result_zeroblob :: Ptr CContext -> CNumBytes -> IO () Source #

c_sqlite3_result_text :: Ptr CContext -> CString -> CNumBytes -> Ptr CDestructor -> IO () Source #

c_sqlite3_result_int64 :: Ptr CContext -> Int64 -> IO () Source #

c_sqlite3_result_double :: Ptr CContext -> Double -> IO () Source #

c_sqlite3_result_value :: Ptr CContext -> Ptr CValue -> IO () Source #

c_sqlite3_result_error :: Ptr CContext -> CString -> CNumBytes -> IO () Source #

Define New Collating Sequences

c_sqlite3_create_collation_v2 Source #

Arguments

:: Ptr CDatabase
-> CString	Name of the collation
-> CInt	Text encoding
-> Ptr a	User data
-> FunPtr (CCompare a)
-> FunPtr (CFuncDestroy a)
-> IO CError

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

type CCompare a = Ptr a -> CNumBytes -> CString -> CNumBytes -> CString -> IO CInt Source #

mkCCompare :: CCompare a -> IO (FunPtr (CCompare a)) Source #

Miscellaneous

c_sqlite3_free :: Ptr a -> IO () Source #

http://sqlite.org/c3ref/free.html

Extensions

c_sqlite3_enable_load_extension :: Ptr CDatabase -> Bool -> IO CError Source #

http://sqlite.org/c3ref/enable_load_extension.html

Write-Ahead Log Commit Hook

c_sqlite3_wal_hook :: Ptr CDatabase -> FunPtr CWalHook -> Ptr a -> IO (Ptr ()) Source #

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

type CWalHook = Ptr () -> Ptr CDatabase -> CString -> CInt -> IO CError Source #

mkCWalHook :: CWalHook -> IO (FunPtr CWalHook) Source #

Incremental blob I/O

c_sqlite3_blob_open Source #

Arguments

:: Ptr CDatabase
-> CString	Database name
-> CString	Table name
-> CString	Column name
-> Int64	Row ROWID
-> CInt	Flags
-> Ptr (Ptr CBlob)	OUT: Blob handle, will be NULL on error
-> IO CError

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

c_sqlite3_blob_close :: Ptr CBlob -> IO CError Source #

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

c_sqlite3_blob_reopen :: Ptr CBlob -> Int64 -> IO CError Source #

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

c_sqlite3_blob_bytes :: Ptr CBlob -> IO CInt Source #

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

c_sqlite3_blob_read :: Ptr CBlob -> Ptr a -> CInt -> CInt -> IO CError Source #

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

c_sqlite3_blob_write :: Ptr CBlob -> Ptr a -> CInt -> CInt -> IO CError Source #

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

c_sqlite3_backup_init Source #

Arguments

:: Ptr CDatabase	Destination database handle
-> CString	Destination database name
-> Ptr CDatabase	Source database handle
-> CString	Source database name
-> IO (Ptr CBackup)

c_sqlite3_backup_finish :: Ptr CBackup -> IO CError Source #

c_sqlite3_backup_step :: Ptr CBackup -> CInt -> IO CError Source #

c_sqlite3_backup_remaining :: Ptr CBackup -> IO CInt Source #

c_sqlite3_backup_pagecount :: Ptr CBackup -> IO CInt Source #