@@ -18,7 +18,7 @@ from sqlite3 import (
1818 Warning as Warning ,
1919 _IsolationLevel ,
2020)
21- from typing import Any , Final , TypeVar , overload
21+ from typing import Any , Final , Literal , TypeVar , overload
2222from typing_extensions import TypeAlias
2323
2424if sys .version_info >= (3 , 11 ):
@@ -30,45 +30,45 @@ _SqliteData: TypeAlias = str | ReadableBuffer | int | float | None
3030_Adapter : TypeAlias = Callable [[_T ], _SqliteData ]
3131_Converter : TypeAlias = Callable [[bytes ], Any ]
3232
33- PARSE_COLNAMES : Final [ int ]
34- PARSE_DECLTYPES : Final [ int ]
35- SQLITE_ALTER_TABLE : Final [ int ]
36- SQLITE_ANALYZE : Final [ int ]
37- SQLITE_ATTACH : Final [ int ]
38- SQLITE_CREATE_INDEX : Final [ int ]
39- SQLITE_CREATE_TABLE : Final [ int ]
40- SQLITE_CREATE_TEMP_INDEX : Final [ int ]
41- SQLITE_CREATE_TEMP_TABLE : Final [ int ]
42- SQLITE_CREATE_TEMP_TRIGGER : Final [ int ]
43- SQLITE_CREATE_TEMP_VIEW : Final [ int ]
44- SQLITE_CREATE_TRIGGER : Final [ int ]
45- SQLITE_CREATE_VIEW : Final [ int ]
46- SQLITE_CREATE_VTABLE : Final [ int ]
47- SQLITE_DELETE : Final [ int ]
48- SQLITE_DENY : Final [ int ]
49- SQLITE_DETACH : Final [ int ]
50- SQLITE_DONE : Final [ int ]
51- SQLITE_DROP_INDEX : Final [ int ]
52- SQLITE_DROP_TABLE : Final [ int ]
53- SQLITE_DROP_TEMP_INDEX : Final [ int ]
54- SQLITE_DROP_TEMP_TABLE : Final [ int ]
55- SQLITE_DROP_TEMP_TRIGGER : Final [ int ]
56- SQLITE_DROP_TEMP_VIEW : Final [ int ]
57- SQLITE_DROP_TRIGGER : Final [ int ]
58- SQLITE_DROP_VIEW : Final [ int ]
59- SQLITE_DROP_VTABLE : Final [ int ]
60- SQLITE_FUNCTION : Final [ int ]
61- SQLITE_IGNORE : Final [ int ]
62- SQLITE_INSERT : Final [ int ]
63- SQLITE_OK : Final [ int ]
64- SQLITE_PRAGMA : Final [ int ]
65- SQLITE_READ : Final [ int ]
66- SQLITE_RECURSIVE : Final [ int ]
67- SQLITE_REINDEX : Final [ int ]
68- SQLITE_SAVEPOINT : Final [ int ]
69- SQLITE_SELECT : Final [ int ]
70- SQLITE_TRANSACTION : Final [ int ]
71- SQLITE_UPDATE : Final [ int ]
33+ PARSE_COLNAMES : Final = 2
34+ PARSE_DECLTYPES : Final = 1
35+ SQLITE_ALTER_TABLE : Final = 26
36+ SQLITE_ANALYZE : Final = 28
37+ SQLITE_ATTACH : Final = 24
38+ SQLITE_CREATE_INDEX : Final = 1
39+ SQLITE_CREATE_TABLE : Final = 2
40+ SQLITE_CREATE_TEMP_INDEX : Final = 3
41+ SQLITE_CREATE_TEMP_TABLE : Final = 4
42+ SQLITE_CREATE_TEMP_TRIGGER : Final = 5
43+ SQLITE_CREATE_TEMP_VIEW : Final = 6
44+ SQLITE_CREATE_TRIGGER : Final = 7
45+ SQLITE_CREATE_VIEW : Final = 8
46+ SQLITE_CREATE_VTABLE : Final = 29
47+ SQLITE_DELETE : Final = 9
48+ SQLITE_DENY : Final = 1
49+ SQLITE_DETACH : Final = 25
50+ SQLITE_DONE : Final = 101
51+ SQLITE_DROP_INDEX : Final = 10
52+ SQLITE_DROP_TABLE : Final = 11
53+ SQLITE_DROP_TEMP_INDEX : Final = 12
54+ SQLITE_DROP_TEMP_TABLE : Final = 13
55+ SQLITE_DROP_TEMP_TRIGGER : Final = 14
56+ SQLITE_DROP_TEMP_VIEW : Final = 15
57+ SQLITE_DROP_TRIGGER : Final = 16
58+ SQLITE_DROP_VIEW : Final = 17
59+ SQLITE_DROP_VTABLE : Final = 30
60+ SQLITE_FUNCTION : Final = 31
61+ SQLITE_IGNORE : Final = 2
62+ SQLITE_INSERT : Final = 18
63+ SQLITE_OK : Final = 0
64+ SQLITE_PRAGMA : Final = 19
65+ SQLITE_READ : Final = 20
66+ SQLITE_RECURSIVE : Final = 33
67+ SQLITE_REINDEX : Final = 27
68+ SQLITE_SAVEPOINT : Final = 32
69+ SQLITE_SELECT : Final = 21
70+ SQLITE_TRANSACTION : Final = 22
71+ SQLITE_UPDATE : Final = 23
7272adapters : dict [tuple [type [Any ], type [Any ]], _Adapter [Any ]]
7373converters : dict [str , _Converter ]
7474sqlite_version : str
@@ -77,141 +77,141 @@ if sys.version_info < (3, 12):
7777 version : str
7878
7979if sys .version_info >= (3 , 12 ):
80- LEGACY_TRANSACTION_CONTROL : Final [ int ]
81- SQLITE_DBCONFIG_DEFENSIVE : Final [ int ]
82- SQLITE_DBCONFIG_DQS_DDL : Final [ int ]
83- SQLITE_DBCONFIG_DQS_DML : Final [ int ]
84- SQLITE_DBCONFIG_ENABLE_FKEY : Final [ int ]
85- SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER : Final [ int ]
86- SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION : Final [ int ]
87- SQLITE_DBCONFIG_ENABLE_QPSG : Final [ int ]
88- SQLITE_DBCONFIG_ENABLE_TRIGGER : Final [ int ]
89- SQLITE_DBCONFIG_ENABLE_VIEW : Final [ int ]
90- SQLITE_DBCONFIG_LEGACY_ALTER_TABLE : Final [ int ]
91- SQLITE_DBCONFIG_LEGACY_FILE_FORMAT : Final [ int ]
92- SQLITE_DBCONFIG_NO_CKPT_ON_CLOSE : Final [ int ]
93- SQLITE_DBCONFIG_RESET_DATABASE : Final [ int ]
94- SQLITE_DBCONFIG_TRIGGER_EQP : Final [ int ]
95- SQLITE_DBCONFIG_TRUSTED_SCHEMA : Final [ int ]
96- SQLITE_DBCONFIG_WRITABLE_SCHEMA : Final [ int ]
80+ LEGACY_TRANSACTION_CONTROL : Final = - 1
81+ SQLITE_DBCONFIG_DEFENSIVE : Final = 1010
82+ SQLITE_DBCONFIG_DQS_DDL : Final = 1014
83+ SQLITE_DBCONFIG_DQS_DML : Final = 1013
84+ SQLITE_DBCONFIG_ENABLE_FKEY : Final = 1002
85+ SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER : Final = 1004
86+ SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION : Final = 1005
87+ SQLITE_DBCONFIG_ENABLE_QPSG : Final = 1007
88+ SQLITE_DBCONFIG_ENABLE_TRIGGER : Final = 1003
89+ SQLITE_DBCONFIG_ENABLE_VIEW : Final = 1015
90+ SQLITE_DBCONFIG_LEGACY_ALTER_TABLE : Final = 1012
91+ SQLITE_DBCONFIG_LEGACY_FILE_FORMAT : Final = 1016
92+ SQLITE_DBCONFIG_NO_CKPT_ON_CLOSE : Final = 1006
93+ SQLITE_DBCONFIG_RESET_DATABASE : Final = 1009
94+ SQLITE_DBCONFIG_TRIGGER_EQP : Final = 1008
95+ SQLITE_DBCONFIG_TRUSTED_SCHEMA : Final = 1017
96+ SQLITE_DBCONFIG_WRITABLE_SCHEMA : Final = 1011
9797
9898if sys .version_info >= (3 , 11 ):
99- SQLITE_ABORT : Final [ int ]
100- SQLITE_ABORT_ROLLBACK : Final [ int ]
101- SQLITE_AUTH : Final [ int ]
102- SQLITE_AUTH_USER : Final [ int ]
103- SQLITE_BUSY : Final [ int ]
104- SQLITE_BUSY_RECOVERY : Final [ int ]
105- SQLITE_BUSY_SNAPSHOT : Final [ int ]
106- SQLITE_BUSY_TIMEOUT : Final [ int ]
107- SQLITE_CANTOPEN : Final [ int ]
108- SQLITE_CANTOPEN_CONVPATH : Final [ int ]
109- SQLITE_CANTOPEN_DIRTYWAL : Final [ int ]
110- SQLITE_CANTOPEN_FULLPATH : Final [ int ]
111- SQLITE_CANTOPEN_ISDIR : Final [ int ]
112- SQLITE_CANTOPEN_NOTEMPDIR : Final [ int ]
113- SQLITE_CANTOPEN_SYMLINK : Final [ int ]
114- SQLITE_CONSTRAINT : Final [ int ]
115- SQLITE_CONSTRAINT_CHECK : Final [ int ]
116- SQLITE_CONSTRAINT_COMMITHOOK : Final [ int ]
117- SQLITE_CONSTRAINT_FOREIGNKEY : Final [ int ]
118- SQLITE_CONSTRAINT_FUNCTION : Final [ int ]
119- SQLITE_CONSTRAINT_NOTNULL : Final [ int ]
120- SQLITE_CONSTRAINT_PINNED : Final [ int ]
121- SQLITE_CONSTRAINT_PRIMARYKEY : Final [ int ]
122- SQLITE_CONSTRAINT_ROWID : Final [ int ]
123- SQLITE_CONSTRAINT_TRIGGER : Final [ int ]
124- SQLITE_CONSTRAINT_UNIQUE : Final [ int ]
125- SQLITE_CONSTRAINT_VTAB : Final [ int ]
126- SQLITE_CORRUPT : Final [ int ]
127- SQLITE_CORRUPT_INDEX : Final [ int ]
128- SQLITE_CORRUPT_SEQUENCE : Final [ int ]
129- SQLITE_CORRUPT_VTAB : Final [ int ]
130- SQLITE_EMPTY : Final [ int ]
131- SQLITE_ERROR : Final [ int ]
132- SQLITE_ERROR_MISSING_COLLSEQ : Final [ int ]
133- SQLITE_ERROR_RETRY : Final [ int ]
134- SQLITE_ERROR_SNAPSHOT : Final [ int ]
135- SQLITE_FORMAT : Final [ int ]
136- SQLITE_FULL : Final [ int ]
137- SQLITE_INTERNAL : Final [ int ]
138- SQLITE_INTERRUPT : Final [ int ]
139- SQLITE_IOERR : Final [ int ]
140- SQLITE_IOERR_ACCESS : Final [ int ]
141- SQLITE_IOERR_AUTH : Final [ int ]
142- SQLITE_IOERR_BEGIN_ATOMIC : Final [ int ]
143- SQLITE_IOERR_BLOCKED : Final [ int ]
144- SQLITE_IOERR_CHECKRESERVEDLOCK : Final [ int ]
145- SQLITE_IOERR_CLOSE : Final [ int ]
146- SQLITE_IOERR_COMMIT_ATOMIC : Final [ int ]
147- SQLITE_IOERR_CONVPATH : Final [ int ]
148- SQLITE_IOERR_CORRUPTFS : Final [ int ]
149- SQLITE_IOERR_DATA : Final [ int ]
150- SQLITE_IOERR_DELETE : Final [ int ]
151- SQLITE_IOERR_DELETE_NOENT : Final [ int ]
152- SQLITE_IOERR_DIR_CLOSE : Final [ int ]
153- SQLITE_IOERR_DIR_FSYNC : Final [ int ]
154- SQLITE_IOERR_FSTAT : Final [ int ]
155- SQLITE_IOERR_FSYNC : Final [ int ]
156- SQLITE_IOERR_GETTEMPPATH : Final [ int ]
157- SQLITE_IOERR_LOCK : Final [ int ]
158- SQLITE_IOERR_MMAP : Final [ int ]
159- SQLITE_IOERR_NOMEM : Final [ int ]
160- SQLITE_IOERR_RDLOCK : Final [ int ]
161- SQLITE_IOERR_READ : Final [ int ]
162- SQLITE_IOERR_ROLLBACK_ATOMIC : Final [ int ]
163- SQLITE_IOERR_SEEK : Final [ int ]
164- SQLITE_IOERR_SHMLOCK : Final [ int ]
165- SQLITE_IOERR_SHMMAP : Final [ int ]
166- SQLITE_IOERR_SHMOPEN : Final [ int ]
167- SQLITE_IOERR_SHMSIZE : Final [ int ]
168- SQLITE_IOERR_SHORT_READ : Final [ int ]
169- SQLITE_IOERR_TRUNCATE : Final [ int ]
170- SQLITE_IOERR_UNLOCK : Final [ int ]
171- SQLITE_IOERR_VNODE : Final [ int ]
172- SQLITE_IOERR_WRITE : Final [ int ]
173- SQLITE_LIMIT_ATTACHED : Final [ int ]
174- SQLITE_LIMIT_COLUMN : Final [ int ]
175- SQLITE_LIMIT_COMPOUND_SELECT : Final [ int ]
176- SQLITE_LIMIT_EXPR_DEPTH : Final [ int ]
177- SQLITE_LIMIT_FUNCTION_ARG : Final [ int ]
178- SQLITE_LIMIT_LENGTH : Final [ int ]
179- SQLITE_LIMIT_LIKE_PATTERN_LENGTH : Final [ int ]
180- SQLITE_LIMIT_SQL_LENGTH : Final [ int ]
181- SQLITE_LIMIT_TRIGGER_DEPTH : Final [ int ]
182- SQLITE_LIMIT_VARIABLE_NUMBER : Final [ int ]
183- SQLITE_LIMIT_VDBE_OP : Final [ int ]
184- SQLITE_LIMIT_WORKER_THREADS : Final [ int ]
185- SQLITE_LOCKED : Final [ int ]
186- SQLITE_LOCKED_SHAREDCACHE : Final [ int ]
187- SQLITE_LOCKED_VTAB : Final [ int ]
188- SQLITE_MISMATCH : Final [ int ]
189- SQLITE_MISUSE : Final [ int ]
190- SQLITE_NOLFS : Final [ int ]
191- SQLITE_NOMEM : Final [ int ]
192- SQLITE_NOTADB : Final [ int ]
193- SQLITE_NOTFOUND : Final [ int ]
194- SQLITE_NOTICE : Final [ int ]
195- SQLITE_NOTICE_RECOVER_ROLLBACK : Final [ int ]
196- SQLITE_NOTICE_RECOVER_WAL : Final [ int ]
197- SQLITE_OK_LOAD_PERMANENTLY : Final [ int ]
198- SQLITE_OK_SYMLINK : Final [ int ]
199- SQLITE_PERM : Final [ int ]
200- SQLITE_PROTOCOL : Final [ int ]
201- SQLITE_RANGE : Final [ int ]
202- SQLITE_READONLY : Final [ int ]
203- SQLITE_READONLY_CANTINIT : Final [ int ]
204- SQLITE_READONLY_CANTLOCK : Final [ int ]
205- SQLITE_READONLY_DBMOVED : Final [ int ]
206- SQLITE_READONLY_DIRECTORY : Final [ int ]
207- SQLITE_READONLY_RECOVERY : Final [ int ]
208- SQLITE_READONLY_ROLLBACK : Final [ int ]
209- SQLITE_ROW : Final [ int ]
210- SQLITE_SCHEMA : Final [ int ]
211- SQLITE_TOOBIG : Final [ int ]
212- SQLITE_WARNING : Final [ int ]
213- SQLITE_WARNING_AUTOINDEX : Final [ int ]
214- threadsafety : Final [ int ]
99+ SQLITE_ABORT : Final = 4
100+ SQLITE_ABORT_ROLLBACK : Final = 516
101+ SQLITE_AUTH : Final = 23
102+ SQLITE_AUTH_USER : Final = 279
103+ SQLITE_BUSY : Final = 5
104+ SQLITE_BUSY_RECOVERY : Final = 261
105+ SQLITE_BUSY_SNAPSHOT : Final = 517
106+ SQLITE_BUSY_TIMEOUT : Final = 773
107+ SQLITE_CANTOPEN : Final = 14
108+ SQLITE_CANTOPEN_CONVPATH : Final = 1038
109+ SQLITE_CANTOPEN_DIRTYWAL : Final = 1294
110+ SQLITE_CANTOPEN_FULLPATH : Final = 782
111+ SQLITE_CANTOPEN_ISDIR : Final = 526
112+ SQLITE_CANTOPEN_NOTEMPDIR : Final = 270
113+ SQLITE_CANTOPEN_SYMLINK : Final = 1550
114+ SQLITE_CONSTRAINT : Final = 19
115+ SQLITE_CONSTRAINT_CHECK : Final = 275
116+ SQLITE_CONSTRAINT_COMMITHOOK : Final = 531
117+ SQLITE_CONSTRAINT_FOREIGNKEY : Final = 787
118+ SQLITE_CONSTRAINT_FUNCTION : Final = 1043
119+ SQLITE_CONSTRAINT_NOTNULL : Final = 1299
120+ SQLITE_CONSTRAINT_PINNED : Final = 2835
121+ SQLITE_CONSTRAINT_PRIMARYKEY : Final = 1555
122+ SQLITE_CONSTRAINT_ROWID : Final = 2579
123+ SQLITE_CONSTRAINT_TRIGGER : Final = 1811
124+ SQLITE_CONSTRAINT_UNIQUE : Final = 2067
125+ SQLITE_CONSTRAINT_VTAB : Final = 2323
126+ SQLITE_CORRUPT : Final = 11
127+ SQLITE_CORRUPT_INDEX : Final = 779
128+ SQLITE_CORRUPT_SEQUENCE : Final = 523
129+ SQLITE_CORRUPT_VTAB : Final = 267
130+ SQLITE_EMPTY : Final = 16
131+ SQLITE_ERROR : Final = 1
132+ SQLITE_ERROR_MISSING_COLLSEQ : Final = 257
133+ SQLITE_ERROR_RETRY : Final = 513
134+ SQLITE_ERROR_SNAPSHOT : Final = 769
135+ SQLITE_FORMAT : Final = 24
136+ SQLITE_FULL : Final = 13
137+ SQLITE_INTERNAL : Final = 2
138+ SQLITE_INTERRUPT : Final = 9
139+ SQLITE_IOERR : Final = 10
140+ SQLITE_IOERR_ACCESS : Final = 3338
141+ SQLITE_IOERR_AUTH : Final = 7178
142+ SQLITE_IOERR_BEGIN_ATOMIC : Final = 7434
143+ SQLITE_IOERR_BLOCKED : Final = 2826
144+ SQLITE_IOERR_CHECKRESERVEDLOCK : Final = 3594
145+ SQLITE_IOERR_CLOSE : Final = 4106
146+ SQLITE_IOERR_COMMIT_ATOMIC : Final = 7690
147+ SQLITE_IOERR_CONVPATH : Final = 6666
148+ SQLITE_IOERR_CORRUPTFS : Final = 8458
149+ SQLITE_IOERR_DATA : Final = 8202
150+ SQLITE_IOERR_DELETE : Final = 2570
151+ SQLITE_IOERR_DELETE_NOENT : Final = 5898
152+ SQLITE_IOERR_DIR_CLOSE : Final = 4362
153+ SQLITE_IOERR_DIR_FSYNC : Final = 1290
154+ SQLITE_IOERR_FSTAT : Final = 1802
155+ SQLITE_IOERR_FSYNC : Final = 1034
156+ SQLITE_IOERR_GETTEMPPATH : Final = 6410
157+ SQLITE_IOERR_LOCK : Final = 3850
158+ SQLITE_IOERR_MMAP : Final = 6154
159+ SQLITE_IOERR_NOMEM : Final = 3082
160+ SQLITE_IOERR_RDLOCK : Final = 2314
161+ SQLITE_IOERR_READ : Final = 266
162+ SQLITE_IOERR_ROLLBACK_ATOMIC : Final = 7946
163+ SQLITE_IOERR_SEEK : Final = 5642
164+ SQLITE_IOERR_SHMLOCK : Final = 5130
165+ SQLITE_IOERR_SHMMAP : Final = 5386
166+ SQLITE_IOERR_SHMOPEN : Final = 4618
167+ SQLITE_IOERR_SHMSIZE : Final = 4874
168+ SQLITE_IOERR_SHORT_READ : Final = 522
169+ SQLITE_IOERR_TRUNCATE : Final = 1546
170+ SQLITE_IOERR_UNLOCK : Final = 2058
171+ SQLITE_IOERR_VNODE : Final = 6922
172+ SQLITE_IOERR_WRITE : Final = 778
173+ SQLITE_LIMIT_ATTACHED : Final = 7
174+ SQLITE_LIMIT_COLUMN : Final = 22
175+ SQLITE_LIMIT_COMPOUND_SELECT : Final = 4
176+ SQLITE_LIMIT_EXPR_DEPTH : Final = 3
177+ SQLITE_LIMIT_FUNCTION_ARG : Final = 6
178+ SQLITE_LIMIT_LENGTH : Final = 0
179+ SQLITE_LIMIT_LIKE_PATTERN_LENGTH : Final = 8
180+ SQLITE_LIMIT_SQL_LENGTH : Final = 1
181+ SQLITE_LIMIT_TRIGGER_DEPTH : Final = 10
182+ SQLITE_LIMIT_VARIABLE_NUMBER : Final = 9
183+ SQLITE_LIMIT_VDBE_OP : Final = 5
184+ SQLITE_LIMIT_WORKER_THREADS : Final = 11
185+ SQLITE_LOCKED : Final = 6
186+ SQLITE_LOCKED_SHAREDCACHE : Final = 262
187+ SQLITE_LOCKED_VTAB : Final = 518
188+ SQLITE_MISMATCH : Final = 20
189+ SQLITE_MISUSE : Final = 21
190+ SQLITE_NOLFS : Final = 22
191+ SQLITE_NOMEM : Final = 7
192+ SQLITE_NOTADB : Final = 26
193+ SQLITE_NOTFOUND : Final = 12
194+ SQLITE_NOTICE : Final = 27
195+ SQLITE_NOTICE_RECOVER_ROLLBACK : Final = 539
196+ SQLITE_NOTICE_RECOVER_WAL : Final = 283
197+ SQLITE_OK_LOAD_PERMANENTLY : Final = 256
198+ SQLITE_OK_SYMLINK : Final = 512
199+ SQLITE_PERM : Final = 3
200+ SQLITE_PROTOCOL : Final = 15
201+ SQLITE_RANGE : Final = 25
202+ SQLITE_READONLY : Final = 8
203+ SQLITE_READONLY_CANTINIT : Final = 1288
204+ SQLITE_READONLY_CANTLOCK : Final = 520
205+ SQLITE_READONLY_DBMOVED : Final = 1032
206+ SQLITE_READONLY_DIRECTORY : Final = 1544
207+ SQLITE_READONLY_RECOVERY : Final = 264
208+ SQLITE_READONLY_ROLLBACK : Final = 776
209+ SQLITE_ROW : Final = 100
210+ SQLITE_SCHEMA : Final = 17
211+ SQLITE_TOOBIG : Final = 18
212+ SQLITE_WARNING : Final = 28
213+ SQLITE_WARNING_AUTOINDEX : Final = 284
214+ threadsafety : Literal [ 0 , 1 , 3 ]
215215
216216# Can take or return anything depending on what's in the registry.
217217@overload
0 commit comments