DBD::SQLite::Constants
Section: User Contributed Perl Documentation (3pm)
Updated: 2022-11-26
Index
Return to Main Contents
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
-
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_CANTOPEN_SYMLINK
-
- SQLITE_CONSTRAINT_PINNED
-
- SQLITE_OK_SYMLINK
-
- SQLITE_IOERR_DATA
-
- SQLITE_BUSY_TIMEOUT
-
- SQLITE_CORRUPT_INDEX
-
- SQLITE_IOERR_CORRUPTFS
-
- SQLITE_CONSTRAINT_DATATYPE
-
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
-
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
-
Index
- NAME
-
- SYNOPSIS
-
- DESCRIPTION
-
- CONSTANTS
-
- 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
-
This document was created by
man2html,
using the manual pages.
Time: 02:37:39 GMT, April 24, 2024