Database.SQLite.Types

Database.SQLite.Types

Portability	portable
Stability	provisional
Maintainer	Don Stewart <dons@galois.com>

Description

Objects, types and constants used in the sqlite3 binding.

Synopsis

type SQLiteInt64 = Int64

type SQLiteWord64 = Word64

newtype SQLite = SQLite (Ptr ())

newtype SQLiteStmt = SQLiteStmt (Ptr ())

newtype SQLiteValue = SQLiteValue (Ptr ())

newtype SQLiteContext = SQLiteContext (Ptr ())

newtype SQLiteBLOB = SQLiteBLOB (Ptr ())

newtype SQLiteUTF16 = SQLiteUTF16 (Ptr ())

newtype SQLiteContextBuffer = SQLiteContextBuffer (Ptr ())

newtype SQLiteCallback a = SQLiteCallback (FunPtr a)

type SQLiteCallbackUserData = Ptr ()

data SQLiteType

type Status = Word32

sQLITE_OK :: Status

sQLITE_ERROR :: Status

sQLITE_INTERNAL :: Status

sQLITE_PERM :: Status

sQLITE_ABORT :: Status

sQLITE_BUSY :: Status

sQLITE_LOCKED :: Status

sQLITE_NOMEM :: Status

sQLITE_READONLY :: Status

sQLITE_INTERRUPT :: Status

sQLITE_IOERR :: Status

sQLITE_CORRUPT :: Status

sQLITE_NOTFOUND :: Status

sQLITE_FULL :: Status

sQLITE_CANTOPEN :: Status

sQLITE_PROTOCOL :: Status

sQLITE_EMPTY :: Status

sQLITE_SCHEMA :: Status

sQLITE_TOOBIG :: Status

sQLITE_CONSTRAINT :: Status

sQLITE_MISMATCH :: Status

sQLITE_MISUSE :: Status

sQLITE_NOLFS :: Status

sQLITE_AUTH :: Status

sQLITE_FORMAT :: Status

sQLITE_RANGE :: Status

sQLITE_NOTADB :: Status

sQLITE_ROW :: Status

sQLITE_DONE :: Status

sQLITE_IOERR_READ :: Status

sQLITE_IOERR_SHORT_READ :: Status

sQLITE_IOERR_WRITE :: Status

sQLITE_IOERR_FSYNC :: Status

sQLITE_IOERR_DIR_FSYNC :: Status

sQLITE_IOERR_TRUNCATE :: Status

sQLITE_IOERR_FSTAT :: Status

sQLITE_IOERR_UNLOCK :: Status

sQLITE_IOERR_RDLOCK :: Status

sQLITE_IOERR_DELETE :: Status

sQLITE_IOERR_BLOCKED :: Status

sQLITE_IOERR_NOMEM :: Status

type OpenFlags = Word32

sQLITE_OPEN_READONLY :: OpenFlags

sQLITE_OPEN_READWRITE :: OpenFlags

sQLITE_OPEN_CREATE :: OpenFlags

sQLITE_OPEN_DELETEONCLOSE :: OpenFlags

sQLITE_OPEN_EXCLUSIVE :: OpenFlags

sQLITE_OPEN_MAIN_DB :: OpenFlags

sQLITE_OPEN_TEMP_DB :: OpenFlags

sQLITE_OPEN_TRANSIENT_DB :: OpenFlags

sQLITE_OPEN_MAIN_JOURNAL :: OpenFlags

sQLITE_OPEN_TEMP_JOURNAL :: OpenFlags

sQLITE_OPEN_SUBJOURNAL :: OpenFlags

sQLITE_OPEN_MASTER_JOURNAL :: OpenFlags

type IOCap = Word32

sQLITE_IOCAP_ATOMIC :: IOCap

sQLITE_IOCAP_ATOMIC512 :: IOCap

sQLITE_IOCAP_ATOMIC1K :: IOCap

sQLITE_IOCAP_ATOMIC2K :: IOCap

sQLITE_IOCAP_ATOMIC4K :: IOCap

sQLITE_IOCAP_ATOMIC8K :: IOCap

sQLITE_IOCAP_ATOMIC16K :: IOCap

sQLITE_IOCAP_ATOMIC32K :: IOCap

sQLITE_IOCAP_ATOMIC64K :: IOCap

sQLITE_IOCAP_SAFE_APPEND :: IOCap

sQLITE_IOCAP_SEQUENTIAL :: IOCap

type LockFlag = Word32

sQLITE_LOCK_NONE :: LockFlag

sQLITE_LOCK_SHARED :: LockFlag

sQLITE_LOCK_RESERVED :: LockFlag

sQLITE_LOCK_PENDING :: LockFlag

sQLITE_LOCK_EXCLUSIVE :: LockFlag

type SyncFlag = Word32

sQLITE_SYNC_NORMAL :: SyncFlag

sQLITE_SYNC_FULL :: SyncFlag

sQLITE_SYNC_DATAONLY :: SyncFlag

type AccessFlag = Word32

sQLITE_ACCESS_EXISTS :: AccessFlag

sQLITE_ACCESS_READWRITE :: AccessFlag

sQLITE_ACCESS_READ :: AccessFlag

type AuthCode = Word32

sQLITE_COPY :: AuthCode

sQLITE_CREATE_INDEX :: AuthCode

sQLITE_CREATE_TABLE :: AuthCode

sQLITE_CREATE_TEMP_INDEX :: AuthCode

sQLITE_CREATE_TEMP_TABLE :: AuthCode

sQLITE_CREATE_TEMP_TRIGGER :: AuthCode

sQLITE_CREATE_TEMP_VIEW :: AuthCode

sQLITE_CREATE_TRIGGER :: AuthCode

sQLITE_CREATE_VIEW :: AuthCode

sQLITE_DELETE :: AuthCode

sQLITE_DROP_INDEX :: AuthCode

sQLITE_DROP_TABLE :: AuthCode

sQLITE_DROP_TEMP_INDEX :: AuthCode

sQLITE_DROP_TEMP_TABLE :: AuthCode

sQLITE_DROP_TEMP_TRIGGER :: AuthCode

sQLITE_DROP_TEMP_VIEW :: AuthCode

sQLITE_DROP_TRIGGER :: AuthCode

sQLITE_DROP_VIEW :: AuthCode

sQLITE_INSERT :: AuthCode

sQLITE_PRAGMA :: AuthCode

sQLITE_READ :: AuthCode

sQLITE_SELECT :: AuthCode

sQLITE_TRANSACTION :: AuthCode

sQLITE_UPDATE :: AuthCode

sQLITE_ATTACH :: AuthCode

sQLITE_DETACH :: AuthCode

sQLITE_ALTER_TABLE :: AuthCode

sQLITE_REINDEX :: AuthCode

sQLITE_ANALYZE :: AuthCode

sQLITE_CREATE_VTABLE :: AuthCode

sQLITE_DROP_VTABLE :: AuthCode

sQLITE_FUNCTION :: AuthCode

type TextEncodeFlag = CInt

sQLITE_UTF8 :: TextEncodeFlag

sQLITE_UTF16LE :: TextEncodeFlag

sQLITE_UTF16BE :: TextEncodeFlag

sQLITE_UTF16 :: TextEncodeFlag

sQLITE_ANY :: TextEncodeFlag

sQLITE_UTF16_ALIGNED :: TextEncodeFlag

type FundamentalDatatype = CInt

sQLITE_INTEGER :: FundamentalDatatype

sQLITE_FLOAT :: FundamentalDatatype

sQLITE_BLOB :: FundamentalDatatype

sQLITE_NULL :: FundamentalDatatype

sQLITE_TEXT :: FundamentalDatatype

isNullStmt :: SQLiteStmt -> Bool

noCallback :: SQLiteCallback a

freeCallback :: SQLiteCallback a -> IO ()

Documentation

type SQLiteInt64 = Int64

type SQLiteWord64 = Word64

newtype SQLite

An open SQLite database object.

Constructors

SQLite (Ptr ())

show/hide

Instances

Storable SQLite

newtype SQLiteStmt

An instance of this object represent single SQL statements. This object is variously known as a prepared statement or a compiled SQL statement or simply as a statement.

Constructors

SQLiteStmt (Ptr ())

show/hide

Instances

Storable SQLiteStmt

newtype SQLiteValue

SQLite uses the sqlite3_value object to represent all values that are or can be stored in a database table. SQLite uses dynamic typing for the values it stores. Values stored in sqlite3_value objects can be be integers, floating point values, strings, BLOBs, or NULL.

Constructors

SQLiteValue (Ptr ())

show/hide

Instances

Storable SQLiteValue

IsValue SQLiteValue

newtype SQLiteContext

The context in which an SQL function executes is stored in an sqlite3_context object. A pointer to an sqlite3_context object is always first parameter to application-defined SQL functions.

Constructors

SQLiteContext (Ptr ())

show/hide

Instances

Storable SQLiteContext

newtype SQLiteBLOB

A BLOB handle

Constructors

SQLiteBLOB (Ptr ())

show/hide

Instances

Storable SQLiteBLOB

newtype SQLiteUTF16

Constructors

SQLiteUTF16 (Ptr ())

show/hide

Instances

Storable SQLiteUTF16

newtype SQLiteContextBuffer

Constructors

SQLiteContextBuffer (Ptr ())

show/hide

Instances

Storable SQLiteContextBuffer

newtype SQLiteCallback a

Constructors

SQLiteCallback (FunPtr a)

show/hide

Instances

Storable (SQLiteCallback a)

type SQLiteCallbackUserData = Ptr ()

data SQLiteType

SQLite types

Constructors

SQLiteInt
SQLiteFloat
SQLiteText
SQLiteBlob
SQLiteNull

show/hide

Instances

Enum SQLiteType

type Status = Word32

sQLITE_OK :: Status

SQLite C status codes.

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

sQLITE_ERROR :: Status

sQLITE_INTERNAL :: Status

sQLITE_PERM :: Status

sQLITE_ABORT :: Status

sQLITE_BUSY :: Status

sQLITE_LOCKED :: Status

sQLITE_NOMEM :: Status

sQLITE_READONLY :: Status

sQLITE_INTERRUPT :: Status

sQLITE_IOERR :: Status

sQLITE_CORRUPT :: Status

sQLITE_NOTFOUND :: Status

sQLITE_FULL :: Status

sQLITE_CANTOPEN :: Status

sQLITE_PROTOCOL :: Status

sQLITE_EMPTY :: Status

sQLITE_SCHEMA :: Status

sQLITE_TOOBIG :: Status

sQLITE_CONSTRAINT :: Status

sQLITE_MISMATCH :: Status

sQLITE_MISUSE :: Status

sQLITE_NOLFS :: Status

sQLITE_AUTH :: Status

sQLITE_FORMAT :: Status

sQLITE_RANGE :: Status

sQLITE_NOTADB :: Status

sQLITE_ROW :: Status

sQLITE_DONE :: Status

sQLITE_IOERR_READ :: Status

SQLite extended result codes:

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

sQLITE_IOERR_SHORT_READ :: Status

sQLITE_IOERR_WRITE :: Status

sQLITE_IOERR_FSYNC :: Status

sQLITE_IOERR_DIR_FSYNC :: Status

sQLITE_IOERR_TRUNCATE :: Status

sQLITE_IOERR_FSTAT :: Status

sQLITE_IOERR_UNLOCK :: Status

sQLITE_IOERR_RDLOCK :: Status

sQLITE_IOERR_DELETE :: Status

sQLITE_IOERR_BLOCKED :: Status

sQLITE_IOERR_NOMEM :: Status

type OpenFlags = Word32

sQLITE_OPEN_READONLY :: OpenFlags

SQLite flags for open operations.

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

sQLITE_OPEN_READWRITE :: OpenFlags

sQLITE_OPEN_CREATE :: OpenFlags

sQLITE_OPEN_DELETEONCLOSE :: OpenFlags

sQLITE_OPEN_EXCLUSIVE :: OpenFlags

sQLITE_OPEN_MAIN_DB :: OpenFlags

sQLITE_OPEN_TEMP_DB :: OpenFlags

sQLITE_OPEN_TRANSIENT_DB :: OpenFlags

sQLITE_OPEN_MAIN_JOURNAL :: OpenFlags

sQLITE_OPEN_TEMP_JOURNAL :: OpenFlags

sQLITE_OPEN_SUBJOURNAL :: OpenFlags

sQLITE_OPEN_MASTER_JOURNAL :: OpenFlags

type IOCap = Word32

sQLITE_IOCAP_ATOMIC :: IOCap

Device characteristics

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

sQLITE_IOCAP_ATOMIC512 :: IOCap

sQLITE_IOCAP_ATOMIC1K :: IOCap

sQLITE_IOCAP_ATOMIC2K :: IOCap

sQLITE_IOCAP_ATOMIC4K :: IOCap

sQLITE_IOCAP_ATOMIC8K :: IOCap

sQLITE_IOCAP_ATOMIC16K :: IOCap

sQLITE_IOCAP_ATOMIC32K :: IOCap

sQLITE_IOCAP_ATOMIC64K :: IOCap

sQLITE_IOCAP_SAFE_APPEND :: IOCap

sQLITE_IOCAP_SEQUENTIAL :: IOCap

type LockFlag = Word32

sQLITE_LOCK_NONE :: LockFlag

File locking levels

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

sQLITE_LOCK_SHARED :: LockFlag

sQLITE_LOCK_RESERVED :: LockFlag

sQLITE_LOCK_PENDING :: LockFlag

sQLITE_LOCK_EXCLUSIVE :: LockFlag

type SyncFlag = Word32

sQLITE_SYNC_NORMAL :: SyncFlag

Synchronization flags

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

sQLITE_SYNC_FULL :: SyncFlag

sQLITE_SYNC_DATAONLY :: SyncFlag

type AccessFlag = Word32

sQLITE_ACCESS_EXISTS :: AccessFlag

xAccess methods

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

sQLITE_ACCESS_READWRITE :: AccessFlag

sQLITE_ACCESS_READ :: AccessFlag

type AuthCode = Word32

sQLITE_COPY :: AuthCode

Authorizer Action Codes

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

sQLITE_CREATE_INDEX :: AuthCode

sQLITE_CREATE_TABLE :: AuthCode

sQLITE_CREATE_TEMP_INDEX :: AuthCode

sQLITE_CREATE_TEMP_TABLE :: AuthCode

sQLITE_CREATE_TEMP_TRIGGER :: AuthCode

sQLITE_CREATE_TEMP_VIEW :: AuthCode

sQLITE_CREATE_TRIGGER :: AuthCode

sQLITE_CREATE_VIEW :: AuthCode

sQLITE_DELETE :: AuthCode

sQLITE_DROP_INDEX :: AuthCode

sQLITE_DROP_TABLE :: AuthCode

sQLITE_DROP_TEMP_INDEX :: AuthCode

sQLITE_DROP_TEMP_TABLE :: AuthCode

sQLITE_DROP_TEMP_TRIGGER :: AuthCode

sQLITE_DROP_TEMP_VIEW :: AuthCode

sQLITE_DROP_TRIGGER :: AuthCode

sQLITE_DROP_VIEW :: AuthCode

sQLITE_INSERT :: AuthCode

sQLITE_PRAGMA :: AuthCode

sQLITE_READ :: AuthCode

sQLITE_SELECT :: AuthCode

sQLITE_TRANSACTION :: AuthCode

sQLITE_UPDATE :: AuthCode

sQLITE_ATTACH :: AuthCode

sQLITE_DETACH :: AuthCode

sQLITE_ALTER_TABLE :: AuthCode

sQLITE_REINDEX :: AuthCode

sQLITE_ANALYZE :: AuthCode

sQLITE_CREATE_VTABLE :: AuthCode

sQLITE_DROP_VTABLE :: AuthCode

sQLITE_FUNCTION :: AuthCode

type TextEncodeFlag = CInt

sQLITE_UTF8 :: TextEncodeFlag

Text encodings

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

sQLITE_UTF16LE :: TextEncodeFlag

sQLITE_UTF16BE :: TextEncodeFlag

sQLITE_UTF16 :: TextEncodeFlag

sQLITE_ANY :: TextEncodeFlag

sQLITE_UTF16_ALIGNED :: TextEncodeFlag

type FundamentalDatatype = CInt

sQLITE_INTEGER :: FundamentalDatatype

Fundamental datatypes

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

sQLITE_FLOAT :: FundamentalDatatype

sQLITE_BLOB :: FundamentalDatatype

sQLITE_NULL :: FundamentalDatatype

sQLITE_TEXT :: FundamentalDatatype

isNullStmt :: SQLiteStmt -> Bool

noCallback :: SQLiteCallback a

freeCallback :: SQLiteCallback a -> IO ()

Produced by Haddock version 2.4.2