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", "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

CONSTANTS

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.0                      2020-08-31         DBD::SQLite::Constants(3)
Impressum