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, 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
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_CANTOPEN_SYMLINK
- SQLITE_CONSTRAINT_PINNED
- SQLITE_OK_SYMLINK
- SQLITE_IOERR_DATA
- SQLITE_BUSY_TIMEOUT
- SQLITE_CORRUPT_INDEX
- SQLITE_IOERR_CORRUPTFS
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
function_flags
- SQLITE_DETERMINISTIC
- SQLITE_DIRECTONLY
- SQLITE_SUBTYPE
- SQLITE_INNOCUOUS
datatypes (fundamental_datatypes)
- SQLITE_INTEGER
- SQLITE_FLOAT
- SQLITE_BLOB
- SQLITE_NULL
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