diff options
| author | Erlend Egeberg Aasland <erlend.aasland@innova.no> | 2022-04-22 01:45:16 (GMT) |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2022-04-22 01:45:16 (GMT) |
| commit | 29afb7d2efed6ee48a67dafdc1a1f34dd60153cf (patch) | |
| tree | c1a3cd0033011f3286c1ec97fb7cdc82cdf3250e /Doc/includes | |
| parent | 1317b70f89606bd14597116b7ab68a968ea6c017 (diff) | |
| download | cpython-29afb7d2efed6ee48a67dafdc1a1f34dd60153cf.zip cpython-29afb7d2efed6ee48a67dafdc1a1f34dd60153cf.tar.gz cpython-29afb7d2efed6ee48a67dafdc1a1f34dd60153cf.tar.bz2 | |
gh-69093: Add indexing and slicing support to sqlite3.Blob (#91599)
Authored-by: Aviv Palivoda <palaviv@gmail.com>
Co-authored-by: Erlend E. Aasland <erlend.aasland@innova.no>
Diffstat (limited to 'Doc/includes')
| -rw-r--r-- | Doc/includes/sqlite3/blob.py | 11 |
1 files changed, 7 insertions, 4 deletions
diff --git a/Doc/includes/sqlite3/blob.py b/Doc/includes/sqlite3/blob.py index b3694ad..d947059 100644 --- a/Doc/includes/sqlite3/blob.py +++ b/Doc/includes/sqlite3/blob.py @@ -2,15 +2,18 @@ import sqlite3 con = sqlite3.connect(":memory:") con.execute("create table test(blob_col blob)") -con.execute("insert into test(blob_col) values (zeroblob(10))") +con.execute("insert into test(blob_col) values (zeroblob(13))") # Write to our blob, using two write operations: with con.blobopen("test", "blob_col", 1) as blob: - blob.write(b"Hello") - blob.write(b"World") + blob.write(b"hello, ") + blob.write(b"world.") + # Modify the first and last bytes of our blob + blob[0] = b"H" + blob[-1] = b"!" # Read the contents of our blob with con.blobopen("test", "blob_col", 1) as blob: greeting = blob.read() -print(greeting) # outputs "b'HelloWorld'" +print(greeting) # outputs "b'Hello, world!'" |