table of contents
DBD::SQLite::Constants(3) | User Contributed Perl Documentation | DBD::SQLite::Constants(3) |
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", "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¶
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¶
version (compile_time_library_version_numbers)¶
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
file_open (flags_for_file_open_operations)¶
function_flags¶
datatypes (fundamental_datatypes)¶
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
2021-08-09 | perl v5.32.1 |