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