Participer au site avec un Tip
Rechercher
 
Bug Suggérer des Améliorations / Corrections
Share Partager sur Facebook Partager sur Twitter
Links Notre chaîne YouTube Notre discord

Améliorations / Corrections

Vous avez des améliorations (ou des corrections) à proposer pour ce document : je vous remerçie par avance de m'en faire part, cela m'aide à améliorer le site.

Emplacement :

Description des améliorations :

Python 3.11.3

Contenu du module « sqlite3 »

Liste des classes du module sqlite3

Nom de la classe Description
Blob
Connection SQLite database connection object. [extrait de Connection.__doc__]
Cursor SQLite database cursor class. [extrait de Cursor.__doc__]
PrepareProtocol PEP 246 style object adaption protocol type. [extrait de PrepareProtocol.__doc__]
Row

Liste des exceptions du module sqlite3

Nom de la classe d'exception Description
DatabaseError
DataError
Error
IntegrityError
InterfaceError
InternalError
NotSupportedError
OperationalError
ProgrammingError
Warning

Liste des fonctions du module sqlite3

Signature de la fonction Description
adapt Adapt given object to given protocol. [extrait de adapt.__doc__]
complete_statement(statement) Checks if a string contains a complete SQL statement. [extrait de complete_statement.__doc__]
connect Opens a connection to the SQLite database file database. [extrait de connect.__doc__]
DateFromTicks(ticks)
enable_callback_tracebacks(enable) Enable or disable callback functions throwing errors to stderr. [extrait de enable_callback_tracebacks.__doc__]
enable_shared_cache(enable)
register_adapter(type, adapter) Register a function to adapt Python objects to SQLite values. [extrait de register_adapter.__doc__]
register_converter(typename, converter) Register a function to convert SQLite values to Python objects. [extrait de register_converter.__doc__]
TimeFromTicks(ticks)
TimestampFromTicks(ticks)

Liste des variables globales du module sqlite3

Nom de la variable globale Valeur
adapters {(<class 'datetime.date'>, <class 'sqlite3.PrepareProtocol'>): <function register_adapters_and_converters.<locals>.adapt_date at 0x7f720d4a6c00>, (<class 'datetime.datetime'>, <class 'sqlite3.PrepareProtocol'>): <function register_adapters_and_converters.<locals>.adapt_datetime at 0x7f720d4a6ca0>}
apilevel 2.0
converters {'DATE': <function register_adapters_and_converters.<locals>.convert_date at 0x7f720d4a6d40>, 'TIMESTAMP': <function register_adapters_and_converters.<locals>.convert_timestamp at 0x7f720d4a6de0>}
paramstyle qmark
PARSE_COLNAMES 2
PARSE_DECLTYPES 1
SQLITE_ABORT 4
SQLITE_ABORT_ROLLBACK 516
SQLITE_ALTER_TABLE 26
SQLITE_ANALYZE 28
SQLITE_ATTACH 24
SQLITE_AUTH 23
SQLITE_AUTH_USER 279
SQLITE_BUSY 5
SQLITE_BUSY_RECOVERY 261
SQLITE_BUSY_SNAPSHOT 517
SQLITE_BUSY_TIMEOUT 773
SQLITE_CANTOPEN 14
SQLITE_CANTOPEN_CONVPATH 1038
SQLITE_CANTOPEN_DIRTYWAL 1294
SQLITE_CANTOPEN_FULLPATH 782
SQLITE_CANTOPEN_ISDIR 526
SQLITE_CANTOPEN_NOTEMPDIR 270
SQLITE_CANTOPEN_SYMLINK 1550
SQLITE_CONSTRAINT 19
SQLITE_CONSTRAINT_CHECK 275
SQLITE_CONSTRAINT_COMMITHOOK 531
SQLITE_CONSTRAINT_FOREIGNKEY 787
SQLITE_CONSTRAINT_FUNCTION 1043
SQLITE_CONSTRAINT_NOTNULL 1299
SQLITE_CONSTRAINT_PINNED 2835
SQLITE_CONSTRAINT_PRIMARYKEY 1555
SQLITE_CONSTRAINT_ROWID 2579
SQLITE_CONSTRAINT_TRIGGER 1811
SQLITE_CONSTRAINT_UNIQUE 2067
SQLITE_CONSTRAINT_VTAB 2323
SQLITE_CORRUPT 11
SQLITE_CORRUPT_INDEX 779
SQLITE_CORRUPT_SEQUENCE 523
SQLITE_CORRUPT_VTAB 267
SQLITE_CREATE_INDEX 1
SQLITE_CREATE_TABLE 2
SQLITE_CREATE_TEMP_INDEX 3
SQLITE_CREATE_TEMP_TABLE 4
SQLITE_CREATE_TEMP_TRIGGER 5
SQLITE_CREATE_TEMP_VIEW 6
SQLITE_CREATE_TRIGGER 7
SQLITE_CREATE_VIEW 8
SQLITE_CREATE_VTABLE 29
SQLITE_DELETE 9
SQLITE_DENY 1
SQLITE_DETACH 25
SQLITE_DONE 101
SQLITE_DROP_INDEX 10
SQLITE_DROP_TABLE 11
SQLITE_DROP_TEMP_INDEX 12
SQLITE_DROP_TEMP_TABLE 13
SQLITE_DROP_TEMP_TRIGGER 14
SQLITE_DROP_TEMP_VIEW 15
SQLITE_DROP_TRIGGER 16
SQLITE_DROP_VIEW 17
SQLITE_DROP_VTABLE 30
SQLITE_EMPTY 16
SQLITE_ERROR 1
SQLITE_ERROR_MISSING_COLLSEQ 257
SQLITE_ERROR_RETRY 513
SQLITE_ERROR_SNAPSHOT 769
SQLITE_FORMAT 24
SQLITE_FULL 13
SQLITE_FUNCTION 31
SQLITE_IGNORE 2
SQLITE_INSERT 18
SQLITE_INTERNAL 2
SQLITE_INTERRUPT 9
SQLITE_IOERR 10
SQLITE_IOERR_ACCESS 3338
SQLITE_IOERR_AUTH 7178
SQLITE_IOERR_BEGIN_ATOMIC 7434
SQLITE_IOERR_BLOCKED 2826
SQLITE_IOERR_CHECKRESERVEDLOCK 3594
SQLITE_IOERR_CLOSE 4106
SQLITE_IOERR_COMMIT_ATOMIC 7690
SQLITE_IOERR_CONVPATH 6666
SQLITE_IOERR_CORRUPTFS 8458
SQLITE_IOERR_DATA 8202
SQLITE_IOERR_DELETE 2570
SQLITE_IOERR_DELETE_NOENT 5898
SQLITE_IOERR_DIR_CLOSE 4362
SQLITE_IOERR_DIR_FSYNC 1290
SQLITE_IOERR_FSTAT 1802
SQLITE_IOERR_FSYNC 1034
SQLITE_IOERR_GETTEMPPATH 6410
SQLITE_IOERR_LOCK 3850
SQLITE_IOERR_MMAP 6154
SQLITE_IOERR_NOMEM 3082
SQLITE_IOERR_RDLOCK 2314
SQLITE_IOERR_READ 266
SQLITE_IOERR_ROLLBACK_ATOMIC 7946
SQLITE_IOERR_SEEK 5642
SQLITE_IOERR_SHMLOCK 5130
SQLITE_IOERR_SHMMAP 5386
SQLITE_IOERR_SHMOPEN 4618
SQLITE_IOERR_SHMSIZE 4874
SQLITE_IOERR_SHORT_READ 522
SQLITE_IOERR_TRUNCATE 1546
SQLITE_IOERR_UNLOCK 2058
SQLITE_IOERR_VNODE 6922
SQLITE_IOERR_WRITE 778
SQLITE_LIMIT_ATTACHED 7
SQLITE_LIMIT_COLUMN 2
SQLITE_LIMIT_COMPOUND_SELECT 4
SQLITE_LIMIT_EXPR_DEPTH 3
SQLITE_LIMIT_FUNCTION_ARG 6
SQLITE_LIMIT_LENGTH 0
SQLITE_LIMIT_LIKE_PATTERN_LENGTH 8
SQLITE_LIMIT_SQL_LENGTH 1
SQLITE_LIMIT_TRIGGER_DEPTH 10
SQLITE_LIMIT_VARIABLE_NUMBER 9
SQLITE_LIMIT_VDBE_OP 5
SQLITE_LIMIT_WORKER_THREADS 11
SQLITE_LOCKED 6
SQLITE_LOCKED_SHAREDCACHE 262
SQLITE_LOCKED_VTAB 518
SQLITE_MISMATCH 20
SQLITE_MISUSE 21
SQLITE_NOLFS 22
SQLITE_NOMEM 7
SQLITE_NOTADB 26
SQLITE_NOTFOUND 12
SQLITE_NOTICE 27
SQLITE_NOTICE_RECOVER_ROLLBACK 539
SQLITE_NOTICE_RECOVER_WAL 283
SQLITE_OK 0
SQLITE_OK_LOAD_PERMANENTLY 256
SQLITE_OK_SYMLINK 512
SQLITE_PERM 3
SQLITE_PRAGMA 19
SQLITE_PROTOCOL 15
SQLITE_RANGE 25
SQLITE_READ 20
SQLITE_READONLY 8
SQLITE_READONLY_CANTINIT 1288
SQLITE_READONLY_CANTLOCK 520
SQLITE_READONLY_DBMOVED 1032
SQLITE_READONLY_DIRECTORY 1544
SQLITE_READONLY_RECOVERY 264
SQLITE_READONLY_ROLLBACK 776
SQLITE_RECURSIVE 33
SQLITE_REINDEX 27
SQLITE_ROW 100
SQLITE_SAVEPOINT 32
SQLITE_SCHEMA 17
SQLITE_SELECT 21
SQLITE_TOOBIG 18
SQLITE_TRANSACTION 22
SQLITE_UPDATE 23
sqlite_version 3.40.1
sqlite_version_info (3, 40, 1)
SQLITE_WARNING 28
SQLITE_WARNING_AUTOINDEX 284
threadsafety 3
version 2.6.0
version_info (2, 6, 0)

Liste des alias du module sqlite3

Nom de l'alias Définition ciblée
Binary memoryview
Date date
Time time
Timestamp datetime





Le tutoriel Python complet (Text+Vidéos)
Le tutoriel Python en vidéos
Evaluez vos compétences en Python