1DBD::SQLite::Constants(U3s)er Contributed Perl DocumentatDiBoDn::SQLite::Constants(3)
2
6 DBD::SQLite::Constants - common SQLite constants
7
9 DBD::SQLite::Constants qw/:result_codes/;
10
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 This module does not export anything by default.
24
26 allowed_return_values_from_sqlite3_txn_state
27 SQLITE_TXN_NONE
28 SQLITE_TXN_READ
29 SQLITE_TXN_WRITE
30 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 authorizer_return_codes
68 SQLITE_DENY
69 SQLITE_IGNORE
70 version (compile_time_library_version_numbers)
72 SQLITE_VERSION_NUMBER
73 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 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 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 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 function_flags
191 SQLITE_DETERMINISTIC
192 SQLITE_DIRECTONLY
193 SQLITE_SUBTYPE
194 SQLITE_INNOCUOUS
195 datatypes (fundamental_datatypes)
197 SQLITE_INTEGER
198 SQLITE_FLOAT
199 SQLITE_BLOB
200 SQLITE_NULL
201 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 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
248perl v5.36.0 2022-07-22 DBD::SQLite::Constants(3)