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
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)
Impressum