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
86 extended_result_codes
87 SQLITE_IOERR_LOCK
88 SQLITE_IOERR_READ
89 SQLITE_IOERR_SHORT_READ
90 SQLITE_IOERR_WRITE
91 SQLITE_IOERR_FSYNC
92 SQLITE_IOERR_DIR_FSYNC
93 SQLITE_IOERR_TRUNCATE
94 SQLITE_IOERR_FSTAT
95 SQLITE_IOERR_UNLOCK
96 SQLITE_IOERR_RDLOCK
97 SQLITE_IOERR_DELETE
98 SQLITE_IOERR_BLOCKED
99 SQLITE_IOERR_NOMEM
100 SQLITE_IOERR_ACCESS
101 SQLITE_IOERR_CHECKRESERVEDLOCK
102 SQLITE_IOERR_CLOSE
103 SQLITE_IOERR_DIR_CLOSE
104 SQLITE_LOCKED_SHAREDCACHE
105 SQLITE_IOERR_SHMOPEN
106 SQLITE_IOERR_SHMSIZE
107 SQLITE_IOERR_SHMLOCK
108 SQLITE_BUSY_RECOVERY
109 SQLITE_CANTOPEN_NOTEMPDIR
110 SQLITE_IOERR_SHMMAP
111 SQLITE_IOERR_SEEK
112 SQLITE_CORRUPT_VTAB
113 SQLITE_READONLY_RECOVERY
114 SQLITE_READONLY_CANTLOCK
115 SQLITE_ABORT_ROLLBACK
116 SQLITE_CANTOPEN_ISDIR
117 SQLITE_IOERR_DELETE_NOENT
118 SQLITE_CANTOPEN_FULLPATH
119 SQLITE_READONLY_ROLLBACK
120 SQLITE_CONSTRAINT_CHECK
121 SQLITE_CONSTRAINT_COMMITHOOK
122 SQLITE_CONSTRAINT_FOREIGNKEY
123 SQLITE_CONSTRAINT_FUNCTION
124 SQLITE_CONSTRAINT_NOTNULL
125 SQLITE_CONSTRAINT_PRIMARYKEY
126 SQLITE_CONSTRAINT_TRIGGER
127 SQLITE_CONSTRAINT_UNIQUE
128 SQLITE_CONSTRAINT_VTAB
129 SQLITE_IOERR_MMAP
130 SQLITE_NOTICE_RECOVER_WAL
131 SQLITE_NOTICE_RECOVER_ROLLBACK
132 SQLITE_IOERR_GETTEMPPATH
133 SQLITE_BUSY_SNAPSHOT
134 SQLITE_WARNING_AUTOINDEX
135 SQLITE_IOERR_CONVPATH
136 SQLITE_CANTOPEN_CONVPATH
137 SQLITE_CONSTRAINT_ROWID
138 SQLITE_READONLY_DBMOVED
139 SQLITE_AUTH_USER
140 SQLITE_IOERR_VNODE
141 SQLITE_IOERR_AUTH
142 SQLITE_IOERR_BEGIN_ATOMIC
143 SQLITE_IOERR_COMMIT_ATOMIC
144 SQLITE_IOERR_ROLLBACK_ATOMIC
145 SQLITE_ERROR_MISSING_COLLSEQ
146 SQLITE_ERROR_RETRY
147 SQLITE_READONLY_CANTINIT
148 SQLITE_READONLY_DIRECTORY
149 SQLITE_LOCKED_VTAB
150 SQLITE_CORRUPT_SEQUENCE
151 SQLITE_ERROR_SNAPSHOT
152 SQLITE_CANTOPEN_DIRTYWAL
153
154 file_open (flags_for_file_open_operations)
155 SQLITE_OPEN_READONLY
156 SQLITE_OPEN_READWRITE
157 SQLITE_OPEN_CREATE
158 SQLITE_OPEN_NOMUTEX
159 SQLITE_OPEN_FULLMUTEX
160 SQLITE_OPEN_SHAREDCACHE
161 SQLITE_OPEN_PRIVATECACHE
162 SQLITE_OPEN_URI
163 SQLITE_OPEN_MEMORY
164
165 function_flags
166 SQLITE_DETERMINISTIC
167
168 datatypes (fundamental_datatypes)
169 SQLITE_INTEGER
170 SQLITE_FLOAT
171 SQLITE_BLOB
172 SQLITE_NULL
173
174 result_codes
175 SQLITE_OK
176 SQLITE_ERROR
177 SQLITE_INTERNAL
178 SQLITE_PERM
179 SQLITE_ABORT
180 SQLITE_BUSY
181 SQLITE_LOCKED
182 SQLITE_NOMEM
183 SQLITE_READONLY
184 SQLITE_INTERRUPT
185 SQLITE_IOERR
186 SQLITE_CORRUPT
187 SQLITE_NOTFOUND
188 SQLITE_FULL
189 SQLITE_CANTOPEN
190 SQLITE_PROTOCOL
191 SQLITE_EMPTY
192 SQLITE_SCHEMA
193 SQLITE_TOOBIG
194 SQLITE_CONSTRAINT
195 SQLITE_MISMATCH
196 SQLITE_MISUSE
197 SQLITE_NOLFS
198 SQLITE_AUTH
199 SQLITE_FORMAT
200 SQLITE_RANGE
201 SQLITE_NOTADB
202 SQLITE_ROW
203 SQLITE_DONE
204 SQLITE_NOTICE
205 SQLITE_WARNING
206
207 run_time_limit_categories
208 SQLITE_LIMIT_LENGTH
209 SQLITE_LIMIT_SQL_LENGTH
210 SQLITE_LIMIT_COLUMN
211 SQLITE_LIMIT_EXPR_DEPTH
212 SQLITE_LIMIT_COMPOUND_SELECT
213 SQLITE_LIMIT_VDBE_OP
214 SQLITE_LIMIT_FUNCTION_ARG
215 SQLITE_LIMIT_ATTACHED
216 SQLITE_LIMIT_LIKE_PATTERN_LENGTH
217 SQLITE_LIMIT_VARIABLE_NUMBER
218 SQLITE_LIMIT_TRIGGER_DEPTH
219 SQLITE_LIMIT_WORKER_THREADS
220
221
222
223perl v5.30.0 2019-08-13 DBD::SQLite::Constants(3)