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
 
| 2022-09-27 | perl v5.26.1 |