1DBD::SQLite::Constants(U3s)er Contributed Perl DocumentatDiBoDn::SQLite::Constants(3)
2
3
4

NAME

6       DBD::SQLite::Constants - common SQLite constants
7

SYNOPSIS

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

DESCRIPTION

12       You can import necessary SQLite constants from this module. Available
13       tags are "all", "allowed_return_values_from_sqlite3_txn_state",
14       "authorizer_action_codes", "authorizer_return_codes", "version"
15       ("compile_time_library_version_numbers"),
16       "database_connection_configuration_options", "dbd_sqlite_string_mode",
17       "extended_result_codes", "file_open"
18       ("flags_for_file_open_operations"), "function_flags", "datatypes"
19       ("fundamental_datatypes"), "result_codes", "run_time_limit_categories".
20       See <http://sqlite.org/c3ref/constlist.html> for the complete list of
21       constants.
22
23       This module does not export anything by default.
24

CONSTANTS

26   allowed_return_values_from_sqlite3_txn_state
27       SQLITE_TXN_NONE
28       SQLITE_TXN_READ
29       SQLITE_TXN_WRITE
30
31   authorizer_action_codes
32       SQLITE_CREATE_INDEX
33       SQLITE_CREATE_TABLE
34       SQLITE_CREATE_TEMP_INDEX
35       SQLITE_CREATE_TEMP_TABLE
36       SQLITE_CREATE_TEMP_TRIGGER
37       SQLITE_CREATE_TEMP_VIEW
38       SQLITE_CREATE_TRIGGER
39       SQLITE_CREATE_VIEW
40       SQLITE_DELETE
41       SQLITE_DROP_INDEX
42       SQLITE_DROP_TABLE
43       SQLITE_DROP_TEMP_INDEX
44       SQLITE_DROP_TEMP_TABLE
45       SQLITE_DROP_TEMP_TRIGGER
46       SQLITE_DROP_TEMP_VIEW
47       SQLITE_DROP_TRIGGER
48       SQLITE_DROP_VIEW
49       SQLITE_INSERT
50       SQLITE_PRAGMA
51       SQLITE_READ
52       SQLITE_SELECT
53       SQLITE_TRANSACTION
54       SQLITE_UPDATE
55       SQLITE_ATTACH
56       SQLITE_DETACH
57       SQLITE_ALTER_TABLE
58       SQLITE_REINDEX
59       SQLITE_ANALYZE
60       SQLITE_CREATE_VTABLE
61       SQLITE_DROP_VTABLE
62       SQLITE_FUNCTION
63       SQLITE_COPY
64       SQLITE_SAVEPOINT
65       SQLITE_RECURSIVE
66
67   authorizer_return_codes
68       SQLITE_DENY
69       SQLITE_IGNORE
70
71   version (compile_time_library_version_numbers)
72       SQLITE_VERSION_NUMBER
73
74   database_connection_configuration_options
75       SQLITE_DBCONFIG_LOOKASIDE
76       SQLITE_DBCONFIG_ENABLE_FKEY
77       SQLITE_DBCONFIG_ENABLE_TRIGGER
78       SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER
79       SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION
80       SQLITE_DBCONFIG_MAINDBNAME
81       SQLITE_DBCONFIG_NO_CKPT_ON_CLOSE
82       SQLITE_DBCONFIG_ENABLE_QPSG
83       SQLITE_DBCONFIG_TRIGGER_EQP
84       SQLITE_DBCONFIG_MAX
85       SQLITE_DBCONFIG_RESET_DATABASE
86       SQLITE_DBCONFIG_DEFENSIVE
87       SQLITE_DBCONFIG_WRITABLE_SCHEMA
88       SQLITE_DBCONFIG_LEGACY_ALTER_TABLE
89       SQLITE_DBCONFIG_DQS_DML
90       SQLITE_DBCONFIG_DQS_DDL
91       SQLITE_DBCONFIG_ENABLE_VIEW
92       SQLITE_DBCONFIG_LEGACY_FILE_FORMAT
93       SQLITE_DBCONFIG_TRUSTED_SCHEMA
94
95   dbd_sqlite_string_mode
96       DBD_SQLITE_STRING_MODE_PV
97       DBD_SQLITE_STRING_MODE_BYTES
98       DBD_SQLITE_STRING_MODE_UNICODE_NAIVE
99       DBD_SQLITE_STRING_MODE_UNICODE_FALLBACK
100       DBD_SQLITE_STRING_MODE_UNICODE_STRICT
101
102   extended_result_codes
103       SQLITE_IOERR_LOCK
104       SQLITE_IOERR_READ
105       SQLITE_IOERR_SHORT_READ
106       SQLITE_IOERR_WRITE
107       SQLITE_IOERR_FSYNC
108       SQLITE_IOERR_DIR_FSYNC
109       SQLITE_IOERR_TRUNCATE
110       SQLITE_IOERR_FSTAT
111       SQLITE_IOERR_UNLOCK
112       SQLITE_IOERR_RDLOCK
113       SQLITE_IOERR_DELETE
114       SQLITE_IOERR_BLOCKED
115       SQLITE_IOERR_NOMEM
116       SQLITE_IOERR_ACCESS
117       SQLITE_IOERR_CHECKRESERVEDLOCK
118       SQLITE_IOERR_CLOSE
119       SQLITE_IOERR_DIR_CLOSE
120       SQLITE_LOCKED_SHAREDCACHE
121       SQLITE_IOERR_SHMOPEN
122       SQLITE_IOERR_SHMSIZE
123       SQLITE_IOERR_SHMLOCK
124       SQLITE_BUSY_RECOVERY
125       SQLITE_CANTOPEN_NOTEMPDIR
126       SQLITE_IOERR_SHMMAP
127       SQLITE_IOERR_SEEK
128       SQLITE_CORRUPT_VTAB
129       SQLITE_READONLY_RECOVERY
130       SQLITE_READONLY_CANTLOCK
131       SQLITE_ABORT_ROLLBACK
132       SQLITE_CANTOPEN_ISDIR
133       SQLITE_IOERR_DELETE_NOENT
134       SQLITE_CANTOPEN_FULLPATH
135       SQLITE_READONLY_ROLLBACK
136       SQLITE_CONSTRAINT_CHECK
137       SQLITE_CONSTRAINT_COMMITHOOK
138       SQLITE_CONSTRAINT_FOREIGNKEY
139       SQLITE_CONSTRAINT_FUNCTION
140       SQLITE_CONSTRAINT_NOTNULL
141       SQLITE_CONSTRAINT_PRIMARYKEY
142       SQLITE_CONSTRAINT_TRIGGER
143       SQLITE_CONSTRAINT_UNIQUE
144       SQLITE_CONSTRAINT_VTAB
145       SQLITE_IOERR_MMAP
146       SQLITE_NOTICE_RECOVER_WAL
147       SQLITE_NOTICE_RECOVER_ROLLBACK
148       SQLITE_IOERR_GETTEMPPATH
149       SQLITE_BUSY_SNAPSHOT
150       SQLITE_WARNING_AUTOINDEX
151       SQLITE_IOERR_CONVPATH
152       SQLITE_CANTOPEN_CONVPATH
153       SQLITE_CONSTRAINT_ROWID
154       SQLITE_READONLY_DBMOVED
155       SQLITE_AUTH_USER
156       SQLITE_IOERR_VNODE
157       SQLITE_IOERR_AUTH
158       SQLITE_IOERR_BEGIN_ATOMIC
159       SQLITE_IOERR_COMMIT_ATOMIC
160       SQLITE_IOERR_ROLLBACK_ATOMIC
161       SQLITE_ERROR_MISSING_COLLSEQ
162       SQLITE_ERROR_RETRY
163       SQLITE_READONLY_CANTINIT
164       SQLITE_READONLY_DIRECTORY
165       SQLITE_LOCKED_VTAB
166       SQLITE_CORRUPT_SEQUENCE
167       SQLITE_ERROR_SNAPSHOT
168       SQLITE_CANTOPEN_DIRTYWAL
169       SQLITE_CANTOPEN_SYMLINK
170       SQLITE_CONSTRAINT_PINNED
171       SQLITE_OK_SYMLINK
172       SQLITE_IOERR_DATA
173       SQLITE_BUSY_TIMEOUT
174       SQLITE_CORRUPT_INDEX
175       SQLITE_IOERR_CORRUPTFS
176
177   file_open (flags_for_file_open_operations)
178       SQLITE_OPEN_READONLY
179       SQLITE_OPEN_READWRITE
180       SQLITE_OPEN_CREATE
181       SQLITE_OPEN_NOMUTEX
182       SQLITE_OPEN_FULLMUTEX
183       SQLITE_OPEN_SHAREDCACHE
184       SQLITE_OPEN_PRIVATECACHE
185       SQLITE_OPEN_URI
186       SQLITE_OPEN_MEMORY
187       SQLITE_OPEN_NOFOLLOW
188       SQLITE_OPEN_SUPER_JOURNAL
189
190   function_flags
191       SQLITE_DETERMINISTIC
192       SQLITE_DIRECTONLY
193       SQLITE_SUBTYPE
194       SQLITE_INNOCUOUS
195
196   datatypes (fundamental_datatypes)
197       SQLITE_INTEGER
198       SQLITE_FLOAT
199       SQLITE_BLOB
200       SQLITE_NULL
201
202   result_codes
203       SQLITE_OK
204       SQLITE_ERROR
205       SQLITE_INTERNAL
206       SQLITE_PERM
207       SQLITE_ABORT
208       SQLITE_BUSY
209       SQLITE_LOCKED
210       SQLITE_NOMEM
211       SQLITE_READONLY
212       SQLITE_INTERRUPT
213       SQLITE_IOERR
214       SQLITE_CORRUPT
215       SQLITE_NOTFOUND
216       SQLITE_FULL
217       SQLITE_CANTOPEN
218       SQLITE_PROTOCOL
219       SQLITE_EMPTY
220       SQLITE_SCHEMA
221       SQLITE_TOOBIG
222       SQLITE_CONSTRAINT
223       SQLITE_MISMATCH
224       SQLITE_MISUSE
225       SQLITE_NOLFS
226       SQLITE_AUTH
227       SQLITE_FORMAT
228       SQLITE_RANGE
229       SQLITE_NOTADB
230       SQLITE_ROW
231       SQLITE_DONE
232       SQLITE_NOTICE
233       SQLITE_WARNING
234
235   run_time_limit_categories
236       SQLITE_LIMIT_LENGTH
237       SQLITE_LIMIT_SQL_LENGTH
238       SQLITE_LIMIT_COLUMN
239       SQLITE_LIMIT_EXPR_DEPTH
240       SQLITE_LIMIT_COMPOUND_SELECT
241       SQLITE_LIMIT_VDBE_OP
242       SQLITE_LIMIT_FUNCTION_ARG
243       SQLITE_LIMIT_ATTACHED
244       SQLITE_LIMIT_LIKE_PATTERN_LENGTH
245       SQLITE_LIMIT_VARIABLE_NUMBER
246       SQLITE_LIMIT_TRIGGER_DEPTH
247       SQLITE_LIMIT_WORKER_THREADS
248
249
250
251perl v5.36.0                      2022-07-22         DBD::SQLite::Constants(3)
Impressum