```{index} single: DBD::SQLite::Constants ``` # DBD::SQLite::Constants common SQLite constants ## SYNOPSIS ```perl 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`), `flags_for_sqlite3_setlk_timeout`, `function_flags`, `datatypes` (`fundamental_datatypes`), `result_codes`, `run_time_limit_categories`. See [http://sqlite.org/c3ref/constlist.html](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 - SQLITE\_DBCONFIG\_ENABLE\_ATTACH\_CREATE - SQLITE\_DBCONFIG\_ENABLE\_ATTACH\_WRITE - SQLITE\_DBCONFIG\_ENABLE\_COMMENTS ### 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 - SQLITE\_NOTICE\_RBU - SQLITE\_IOERR\_IN\_PAGE - SQLITE\_ERROR\_RESERVESIZE - SQLITE\_ERROR\_KEY - SQLITE\_ERROR\_UNABLE - SQLITE\_IOERR\_BADKEY - SQLITE\_IOERR\_CODEC ### 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 ### flags\_for\_sqlite3\_setlk\_timeout - SQLITE\_SETLK\_BLOCK\_ON\_CONNECT ### function\_flags - SQLITE\_DETERMINISTIC - SQLITE\_DIRECTONLY - SQLITE\_SUBTYPE - SQLITE\_INNOCUOUS - SQLITE\_RESULT\_SUBTYPE - SQLITE\_SELFORDER1 ### 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