NAME

DBD::SQLite::Constants - common SQLite constants

SYNOPSIS

DBD::SQLite::Constants qw/:result_codes/;

DESCRIPTION

You can import necessary SQLite constants from this module. Available tags are all, allowed_return_values_from_sqlite3_txn_state, authorizer_action_codes, authorizer_return_codes, version (compile_time_library_version_numbers), database_connection_configuration_options, dbd_sqlite_string_mode, extended_result_codes, file_open (flags_for_file_open_operations), function_flags, datatypes (fundamental_datatypes), result_codes, run_time_limit_categories. See http://sqlite.org/c3ref/constlist.html for the complete list of constants.

This module does not export anything by default.

CONSTANTS

allowed_return_values_from_sqlite3_txn_state

SQLITE_TXN_NONE
SQLITE_TXN_READ
SQLITE_TXN_WRITE

authorizer_action_codes

SQLITE_CREATE_INDEX
SQLITE_CREATE_TABLE
SQLITE_CREATE_TEMP_INDEX
SQLITE_CREATE_TEMP_TABLE
SQLITE_CREATE_TEMP_TRIGGER
SQLITE_CREATE_TEMP_VIEW
SQLITE_CREATE_TRIGGER
SQLITE_CREATE_VIEW
SQLITE_DELETE
SQLITE_DROP_INDEX
SQLITE_DROP_TABLE
SQLITE_DROP_TEMP_INDEX
SQLITE_DROP_TEMP_TABLE
SQLITE_DROP_TEMP_TRIGGER
SQLITE_DROP_TEMP_VIEW
SQLITE_DROP_TRIGGER
SQLITE_DROP_VIEW
SQLITE_INSERT
SQLITE_PRAGMA
SQLITE_READ
SQLITE_SELECT
SQLITE_TRANSACTION
SQLITE_UPDATE
SQLITE_ATTACH
SQLITE_DETACH
SQLITE_ALTER_TABLE
SQLITE_REINDEX
SQLITE_ANALYZE
SQLITE_CREATE_VTABLE
SQLITE_DROP_VTABLE
SQLITE_FUNCTION
SQLITE_COPY
SQLITE_SAVEPOINT
SQLITE_RECURSIVE

authorizer_return_codes

SQLITE_DENY
SQLITE_IGNORE

version (compile_time_library_version_numbers)

SQLITE_VERSION_NUMBER

database_connection_configuration_options

SQLITE_DBCONFIG_LOOKASIDE
SQLITE_DBCONFIG_ENABLE_FKEY
SQLITE_DBCONFIG_ENABLE_TRIGGER
SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER
SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION
SQLITE_DBCONFIG_MAINDBNAME
SQLITE_DBCONFIG_NO_CKPT_ON_CLOSE
SQLITE_DBCONFIG_ENABLE_QPSG
SQLITE_DBCONFIG_TRIGGER_EQP
SQLITE_DBCONFIG_MAX
SQLITE_DBCONFIG_RESET_DATABASE
SQLITE_DBCONFIG_DEFENSIVE
SQLITE_DBCONFIG_WRITABLE_SCHEMA
SQLITE_DBCONFIG_LEGACY_ALTER_TABLE
SQLITE_DBCONFIG_DQS_DML
SQLITE_DBCONFIG_DQS_DDL
SQLITE_DBCONFIG_ENABLE_VIEW
SQLITE_DBCONFIG_LEGACY_FILE_FORMAT
SQLITE_DBCONFIG_TRUSTED_SCHEMA
SQLITE_DBCONFIG_STMT_SCANSTATUS
SQLITE_DBCONFIG_REVERSE_SCANORDER

dbd_sqlite_string_mode

DBD_SQLITE_STRING_MODE_PV
DBD_SQLITE_STRING_MODE_BYTES
DBD_SQLITE_STRING_MODE_UNICODE_NAIVE
DBD_SQLITE_STRING_MODE_UNICODE_FALLBACK
DBD_SQLITE_STRING_MODE_UNICODE_STRICT

extended_result_codes

SQLITE_IOERR_LOCK
SQLITE_IOERR_READ
SQLITE_IOERR_SHORT_READ
SQLITE_IOERR_WRITE
SQLITE_IOERR_FSYNC
SQLITE_IOERR_DIR_FSYNC
SQLITE_IOERR_TRUNCATE
SQLITE_IOERR_FSTAT
SQLITE_IOERR_UNLOCK
SQLITE_IOERR_RDLOCK
SQLITE_IOERR_DELETE
SQLITE_IOERR_BLOCKED
SQLITE_IOERR_NOMEM
SQLITE_IOERR_ACCESS
SQLITE_IOERR_CHECKRESERVEDLOCK
SQLITE_IOERR_CLOSE
SQLITE_IOERR_DIR_CLOSE
SQLITE_LOCKED_SHAREDCACHE
SQLITE_IOERR_SHMOPEN
SQLITE_IOERR_SHMSIZE
SQLITE_IOERR_SHMLOCK
SQLITE_BUSY_RECOVERY
SQLITE_CANTOPEN_NOTEMPDIR
SQLITE_IOERR_SHMMAP
SQLITE_IOERR_SEEK
SQLITE_CORRUPT_VTAB
SQLITE_READONLY_RECOVERY
SQLITE_READONLY_CANTLOCK
SQLITE_ABORT_ROLLBACK
SQLITE_CANTOPEN_ISDIR
SQLITE_IOERR_DELETE_NOENT
SQLITE_CANTOPEN_FULLPATH
SQLITE_READONLY_ROLLBACK
SQLITE_CONSTRAINT_CHECK
SQLITE_CONSTRAINT_COMMITHOOK
SQLITE_CONSTRAINT_FOREIGNKEY
SQLITE_CONSTRAINT_FUNCTION
SQLITE_CONSTRAINT_NOTNULL
SQLITE_CONSTRAINT_PRIMARYKEY
SQLITE_CONSTRAINT_TRIGGER
SQLITE_CONSTRAINT_UNIQUE
SQLITE_CONSTRAINT_VTAB
SQLITE_IOERR_MMAP
SQLITE_NOTICE_RECOVER_WAL
SQLITE_NOTICE_RECOVER_ROLLBACK
SQLITE_IOERR_GETTEMPPATH
SQLITE_BUSY_SNAPSHOT
SQLITE_WARNING_AUTOINDEX
SQLITE_IOERR_CONVPATH
SQLITE_CANTOPEN_CONVPATH
SQLITE_CONSTRAINT_ROWID
SQLITE_READONLY_DBMOVED
SQLITE_AUTH_USER
SQLITE_IOERR_VNODE
SQLITE_IOERR_AUTH
SQLITE_IOERR_BEGIN_ATOMIC
SQLITE_IOERR_COMMIT_ATOMIC
SQLITE_IOERR_ROLLBACK_ATOMIC
SQLITE_ERROR_MISSING_COLLSEQ
SQLITE_ERROR_RETRY
SQLITE_READONLY_CANTINIT
SQLITE_READONLY_DIRECTORY
SQLITE_LOCKED_VTAB
SQLITE_CORRUPT_SEQUENCE
SQLITE_ERROR_SNAPSHOT
SQLITE_CANTOPEN_DIRTYWAL
SQLITE_CONSTRAINT_PINNED
SQLITE_IOERR_DATA
SQLITE_BUSY_TIMEOUT
SQLITE_CORRUPT_INDEX
SQLITE_IOERR_CORRUPTFS
SQLITE_CONSTRAINT_DATATYPE
SQLITE_NOTICE_RBU
SQLITE_IOERR_IN_PAGE

file_open (flags_for_file_open_operations)

SQLITE_OPEN_READONLY
SQLITE_OPEN_READWRITE
SQLITE_OPEN_CREATE
SQLITE_OPEN_NOMUTEX
SQLITE_OPEN_FULLMUTEX
SQLITE_OPEN_SHAREDCACHE
SQLITE_OPEN_PRIVATECACHE
SQLITE_OPEN_URI
SQLITE_OPEN_MEMORY
SQLITE_OPEN_NOFOLLOW
SQLITE_OPEN_SUPER_JOURNAL
SQLITE_OPEN_EXRESCODE

function_flags

SQLITE_DETERMINISTIC
SQLITE_DIRECTONLY
SQLITE_SUBTYPE
SQLITE_INNOCUOUS
SQLITE_RESULT_SUBTYPE

datatypes (fundamental_datatypes)

SQLITE_INTEGER
SQLITE_FLOAT
SQLITE_BLOB
SQLITE_NULL
SQLITE_TEXT

result_codes

SQLITE_OK
SQLITE_ERROR
SQLITE_INTERNAL
SQLITE_PERM
SQLITE_ABORT
SQLITE_BUSY
SQLITE_LOCKED
SQLITE_NOMEM
SQLITE_READONLY
SQLITE_INTERRUPT
SQLITE_IOERR
SQLITE_CORRUPT
SQLITE_NOTFOUND
SQLITE_FULL
SQLITE_CANTOPEN
SQLITE_PROTOCOL
SQLITE_EMPTY
SQLITE_SCHEMA
SQLITE_TOOBIG
SQLITE_CONSTRAINT
SQLITE_MISMATCH
SQLITE_MISUSE
SQLITE_NOLFS
SQLITE_AUTH
SQLITE_FORMAT
SQLITE_RANGE
SQLITE_NOTADB
SQLITE_ROW
SQLITE_DONE
SQLITE_NOTICE
SQLITE_WARNING

run_time_limit_categories

SQLITE_LIMIT_LENGTH
SQLITE_LIMIT_SQL_LENGTH
SQLITE_LIMIT_COLUMN
SQLITE_LIMIT_EXPR_DEPTH
SQLITE_LIMIT_COMPOUND_SELECT
SQLITE_LIMIT_VDBE_OP
SQLITE_LIMIT_FUNCTION_ARG
SQLITE_LIMIT_ATTACHED
SQLITE_LIMIT_LIKE_PATTERN_LENGTH
SQLITE_LIMIT_VARIABLE_NUMBER
SQLITE_LIMIT_TRIGGER_DEPTH
SQLITE_LIMIT_WORKER_THREADS