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