Persistensi Data¶
Modul yang dijelaskan di dalam bab ini mendukung untuk menyimpan data Python di dalam sebuah bentuk persisten pada disk. Modul pickle
dan marshal
bisa mengubah banyak tipe data Python ke sebuah aliran byte dan kemudian membuat ulang objek dari bytenya. Berbagai modul terkait DBM mendukung serangkaian format file berbasis hash yang menyimpan pemetaan string ke string lain.
Daftar modul yang dijelaskan di dalam bab ini adalah:
pickle
--- Python object serializationcopyreg
--- Registerpickle
support functionsshelve
--- Python object persistencemarshal
--- Internal Python object serializationdbm
--- Interfaces to Unix "databases"sqlite3
--- DB-API 2.0 interface for SQLite databases- Tutorial
- Reference
- Module functions
- Module constants
LEGACY_TRANSACTION_CONTROL
PARSE_COLNAMES
PARSE_DECLTYPES
SQLITE_OK
SQLITE_DENY
SQLITE_IGNORE
apilevel
paramstyle
sqlite_version
sqlite_version_info
threadsafety
SQLITE_DBCONFIG_DEFENSIVE
SQLITE_DBCONFIG_DQS_DDL
SQLITE_DBCONFIG_DQS_DML
SQLITE_DBCONFIG_ENABLE_FKEY
SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER
SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION
SQLITE_DBCONFIG_ENABLE_QPSG
SQLITE_DBCONFIG_ENABLE_TRIGGER
SQLITE_DBCONFIG_ENABLE_VIEW
SQLITE_DBCONFIG_LEGACY_ALTER_TABLE
SQLITE_DBCONFIG_LEGACY_FILE_FORMAT
SQLITE_DBCONFIG_NO_CKPT_ON_CLOSE
SQLITE_DBCONFIG_RESET_DATABASE
SQLITE_DBCONFIG_TRIGGER_EQP
SQLITE_DBCONFIG_TRUSTED_SCHEMA
SQLITE_DBCONFIG_WRITABLE_SCHEMA
- Connection objects
Connection
cursor()
blobopen()
commit()
rollback()
close()
execute()
executemany()
executescript()
create_function()
create_aggregate()
create_window_function()
create_collation()
interrupt()
set_authorizer()
set_progress_handler()
set_trace_callback()
enable_load_extension()
load_extension()
iterdump()
backup()
getlimit()
setlimit()
getconfig()
setconfig()
serialize()
deserialize()
autocommit
in_transaction
isolation_level
row_factory
text_factory
total_changes
- Cursor objects
- Row objects
- Blob objects
- PrepareProtocol objects
- Pengecualian
- SQLite dan tipe Python
- Default adapters and converters (deprecated)
- Command-line interface
- How-to guides
- How to use placeholders to bind values in SQL queries
- How to adapt custom Python types to SQLite values
- How to convert SQLite values to custom Python types
- Adapter and converter recipes
- How to use connection shortcut methods
- How to use the connection context manager
- How to work with SQLite URIs
- How to create and use row factories
- How to handle non-UTF-8 text encodings
- Explanation