Go to main content

man pages section 3: Library Interfaces and Headers

Exit Print View

Updated: Wednesday, July 27, 2022
 
 

DBD::SQLite::Constants (3)

Name

DBD::SQLite::Constants - common SQLite constants

Synopsis

DBD::SQLite::Constants qw/:result_codes/;

Description

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", "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

   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


ATTRIBUTES
       See attributes(7) for descriptions of the following attributes:

       +---------------+-------------------------------+
       |ATTRIBUTE TYPE |       ATTRIBUTE VALUE         |
       +---------------+-------------------------------+
       |Availability   | library/perl-5/dbd-sqlite-532 |
       +---------------+-------------------------------+
       |Stability      | Volatile                      |
       +---------------+-------------------------------+
NOTES
       Source code for open source software components in Oracle Solaris can
       be found at https://www.oracle.com/downloads/opensource/solaris-source-
       code-downloads.html.

       This software was built from source available at
       https://github.com/oracle/solaris-userland.  The original community
       source was downloaded from
       http://backpan.perl.org/authors/id/I/IS/ISHIGAKI/DBD-
       SQLite-1.70.tar.gz.

       Further information about this software can be found on the open source
       community website at https://github.com/DBD-SQLite/DBD-SQLite.



perl v5.32.0                      2022-06-28         DBD::SQLite::Constants(3)