Skip to content

gh-69093: Add mapping protocol support to sqlite3.Blob #91599

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
JelleZijlstra merged 10 commits into from
Apr 22, 2022
Merged

gh-69093: Add mapping protocol support to sqlite3.Blob #91599

Show file tree
Hide file tree
Changes from 1 commit
Commits
Show all changes
10 commits
Select commit Hold shift + click to select a range
38b2cdb
gh-69093: Add mapping protocol support to sqlite3.Blob
Apr 16, 2022
8bc5762
Merge branch 'main' into sqlite-blob-add-mapping-protocol
Apr 16, 2022
86e324a
Cast
Apr 16, 2022
37a5c38
Assert lenght and offset
Apr 16, 2022
a179749
Accept all buffer objects
Apr 16, 2022
ed6a9b6
Address review: reword docs and modify example
Apr 18, 2022
233f940
bugfix: use correct offset in inner read/write
Apr 18, 2022
9cbc339
Update Misc/NEWS.d/next/Library/2022-04-14-01-00-31.gh-issue-69093.bm…
Apr 19, 2022
7df4b9d
Address review: verify writes
Apr 19, 2022
cb2619e
Address review: Py_ssize_t iso. int
Apr 19, 2022
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Next Next commit
Accept all buffer objects
  • Loading branch information
Erlend E. Aasland committed Apr 17, 2022
commit a1797495a901bc708b2227e6f6262e0d1ae1a174
9 changes: 9 additions & 0 deletions Lib/test/test_sqlite3/test_dbapi.py
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -1178,6 +1178,15 @@ def test_blob_set_item(self):
actual = self.cx.execute("select b from test").fetchone()[0]
self.assertEqual(actual, expected)

def test_blob_set_buffer_object(self):
from array import array
self.blob[0] = memoryview(b"1")
Comment thread
erlend-aasland marked this conversation as resolved.
self.blob[0] = bytearray(b"1")
self.blob[0] = array("b", [1])
self.blob[0:5] = memoryview(b"12345")
self.blob[0:5] = bytearray(b"12345")
self.blob[0:5] = array("b", [1, 2, 3, 4, 5])
Comment thread
erlend-aasland marked this conversation as resolved.

def test_blob_set_item_negative_index(self):
self.blob[-1] = b"z"
self.assertEqual(self.blob[-1], b"z")
Expand Down
20 changes: 13 additions & 7 deletions Modules/_sqlite/blob.c
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -455,18 +455,24 @@ ass_subscript_index(pysqlite_Blob *self, PyObject *item, PyObject *value)
"Blob doesn't support item deletion");
return -1;
}
if (!PyBytes_Check(value) || PyBytes_Size(value) != 1) {
PyErr_SetString(PyExc_ValueError,
"Blob assignment must be a single byte");
Py_ssize_t i = get_subscript_index(self, item);
if (i < 0) {
return -1;
}

Py_ssize_t i = get_subscript_index(self, item);
if (i < 0) {
Py_buffer vbuf;
if (PyObject_GetBuffer(value, &vbuf, PyBUF_SIMPLE) < 0) {
return -1;
}
const char *buf = PyBytes_AS_STRING(value);
return inner_write(self, buf, 1, i);
int rc = -1;
if (vbuf.len != 1) {
PyErr_SetString(PyExc_ValueError, "Blob assignment must be a single byte");
}
else {
rc = inner_write(self, (const char *)vbuf.buf, 1, i);
}
PyBuffer_Release(&vbuf);
return rc;
}

static int
Expand Down