Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 1 | /* cursor.c - the cursor type |
| 2 | * |
Gerhard Häring | f9cee22 | 2010-03-05 15:20:03 +0000 | [diff] [blame] | 3 | * Copyright (C) 2004-2010 Gerhard Häring <gh@ghaering.de> |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 4 | * |
| 5 | * This file is part of pysqlite. |
| 6 | * |
| 7 | * This software is provided 'as-is', without any express or implied |
| 8 | * warranty. In no event will the authors be held liable for any damages |
| 9 | * arising from the use of this software. |
| 10 | * |
| 11 | * Permission is granted to anyone to use this software for any purpose, |
| 12 | * including commercial applications, and to alter it and redistribute it |
| 13 | * freely, subject to the following restrictions: |
| 14 | * |
| 15 | * 1. The origin of this software must not be misrepresented; you must not |
| 16 | * claim that you wrote the original software. If you use this software |
| 17 | * in a product, an acknowledgment in the product documentation would be |
| 18 | * appreciated but is not required. |
| 19 | * 2. Altered source versions must be plainly marked as such, and must not be |
| 20 | * misrepresented as being the original software. |
| 21 | * 3. This notice may not be removed or altered from any source distribution. |
| 22 | */ |
| 23 | |
| 24 | #include "cursor.h" |
| 25 | #include "module.h" |
| 26 | #include "util.h" |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 27 | |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 28 | PyObject* pysqlite_cursor_iternext(pysqlite_Cursor* self); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 29 | |
Serhiy Storchaka | 2d06e84 | 2015-12-25 19:53:18 +0200 | [diff] [blame] | 30 | static const char errmsg_fetch_across_rollback[] = "Cursor needed to be reset because of commit/rollback and can no longer be fetched from."; |
Gerhard Häring | f9cee22 | 2010-03-05 15:20:03 +0000 | [diff] [blame] | 31 | |
Guido van Rossum | 6374bb5 | 2007-06-13 16:28:25 +0000 | [diff] [blame] | 32 | static pysqlite_StatementKind detect_statement_type(const char* statement) |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 33 | { |
| 34 | char buf[20]; |
Guido van Rossum | 6374bb5 | 2007-06-13 16:28:25 +0000 | [diff] [blame] | 35 | const char* src; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 36 | char* dst; |
| 37 | |
| 38 | src = statement; |
| 39 | /* skip over whitepace */ |
| 40 | while (*src == '\r' || *src == '\n' || *src == ' ' || *src == '\t') { |
| 41 | src++; |
| 42 | } |
| 43 | |
| 44 | if (*src == 0) |
| 45 | return STATEMENT_INVALID; |
| 46 | |
| 47 | dst = buf; |
| 48 | *dst = 0; |
Victor Stinner | cfcde8c | 2014-08-17 21:09:30 +0200 | [diff] [blame] | 49 | while (Py_ISALPHA(*src) && (dst - buf) < ((Py_ssize_t)sizeof(buf) - 2)) { |
Antoine Pitrou | 1665d2c | 2011-10-04 13:35:28 +0200 | [diff] [blame] | 50 | *dst++ = Py_TOLOWER(*src++); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 51 | } |
| 52 | |
| 53 | *dst = 0; |
| 54 | |
| 55 | if (!strcmp(buf, "select")) { |
| 56 | return STATEMENT_SELECT; |
| 57 | } else if (!strcmp(buf, "insert")) { |
| 58 | return STATEMENT_INSERT; |
| 59 | } else if (!strcmp(buf, "update")) { |
| 60 | return STATEMENT_UPDATE; |
| 61 | } else if (!strcmp(buf, "delete")) { |
| 62 | return STATEMENT_DELETE; |
| 63 | } else if (!strcmp(buf, "replace")) { |
| 64 | return STATEMENT_REPLACE; |
| 65 | } else { |
| 66 | return STATEMENT_OTHER; |
| 67 | } |
| 68 | } |
| 69 | |
Gerhard Häring | f9cee22 | 2010-03-05 15:20:03 +0000 | [diff] [blame] | 70 | static int pysqlite_cursor_init(pysqlite_Cursor* self, PyObject* args, PyObject* kwargs) |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 71 | { |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 72 | pysqlite_Connection* connection; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 73 | |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 74 | if (!PyArg_ParseTuple(args, "O!", &pysqlite_ConnectionType, &connection)) |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 75 | { |
Gerhard Häring | e7ea745 | 2008-03-29 00:45:29 +0000 | [diff] [blame] | 76 | return -1; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 77 | } |
| 78 | |
| 79 | Py_INCREF(connection); |
| 80 | self->connection = connection; |
| 81 | self->statement = NULL; |
| 82 | self->next_row = NULL; |
Gerhard Häring | f9cee22 | 2010-03-05 15:20:03 +0000 | [diff] [blame] | 83 | self->in_weakreflist = NULL; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 84 | |
| 85 | self->row_cast_map = PyList_New(0); |
| 86 | if (!self->row_cast_map) { |
| 87 | return -1; |
| 88 | } |
| 89 | |
| 90 | Py_INCREF(Py_None); |
| 91 | self->description = Py_None; |
| 92 | |
| 93 | Py_INCREF(Py_None); |
| 94 | self->lastrowid= Py_None; |
| 95 | |
| 96 | self->arraysize = 1; |
Gerhard Häring | f9cee22 | 2010-03-05 15:20:03 +0000 | [diff] [blame] | 97 | self->closed = 0; |
| 98 | self->reset = 0; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 99 | |
Georg Brandl | f78e02b | 2008-06-10 17:40:04 +0000 | [diff] [blame] | 100 | self->rowcount = -1L; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 101 | |
| 102 | Py_INCREF(Py_None); |
| 103 | self->row_factory = Py_None; |
| 104 | |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 105 | if (!pysqlite_check_thread(self->connection)) { |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 106 | return -1; |
| 107 | } |
| 108 | |
Gerhard Häring | f9cee22 | 2010-03-05 15:20:03 +0000 | [diff] [blame] | 109 | if (!pysqlite_connection_register_cursor(connection, (PyObject*)self)) { |
| 110 | return -1; |
| 111 | } |
| 112 | |
| 113 | self->initialized = 1; |
| 114 | |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 115 | return 0; |
| 116 | } |
| 117 | |
Gerhard Häring | f9cee22 | 2010-03-05 15:20:03 +0000 | [diff] [blame] | 118 | static void pysqlite_cursor_dealloc(pysqlite_Cursor* self) |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 119 | { |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 120 | /* Reset the statement if the user has not closed the cursor */ |
| 121 | if (self->statement) { |
Brett Cannon | b94767f | 2011-02-22 20:15:44 +0000 | [diff] [blame] | 122 | pysqlite_statement_reset(self->statement); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 123 | Py_DECREF(self->statement); |
| 124 | } |
| 125 | |
| 126 | Py_XDECREF(self->connection); |
| 127 | Py_XDECREF(self->row_cast_map); |
| 128 | Py_XDECREF(self->description); |
| 129 | Py_XDECREF(self->lastrowid); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 130 | Py_XDECREF(self->row_factory); |
| 131 | Py_XDECREF(self->next_row); |
| 132 | |
Gerhard Häring | f9cee22 | 2010-03-05 15:20:03 +0000 | [diff] [blame] | 133 | if (self->in_weakreflist != NULL) { |
| 134 | PyObject_ClearWeakRefs((PyObject*)self); |
| 135 | } |
| 136 | |
Christian Heimes | 90aa764 | 2007-12-19 02:45:37 +0000 | [diff] [blame] | 137 | Py_TYPE(self)->tp_free((PyObject*)self); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 138 | } |
| 139 | |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 140 | PyObject* _pysqlite_get_converter(PyObject* key) |
Thomas Wouters | 0e3f591 | 2006-08-11 14:57:12 +0000 | [diff] [blame] | 141 | { |
| 142 | PyObject* upcase_key; |
| 143 | PyObject* retval; |
Martin v. Löwis | bd928fe | 2011-10-14 10:20:37 +0200 | [diff] [blame] | 144 | _Py_IDENTIFIER(upper); |
Thomas Wouters | 0e3f591 | 2006-08-11 14:57:12 +0000 | [diff] [blame] | 145 | |
Martin v. Löwis | afe55bb | 2011-10-09 10:38:36 +0200 | [diff] [blame] | 146 | upcase_key = _PyObject_CallMethodId(key, &PyId_upper, ""); |
Thomas Wouters | 0e3f591 | 2006-08-11 14:57:12 +0000 | [diff] [blame] | 147 | if (!upcase_key) { |
| 148 | return NULL; |
| 149 | } |
| 150 | |
| 151 | retval = PyDict_GetItem(converters, upcase_key); |
| 152 | Py_DECREF(upcase_key); |
| 153 | |
| 154 | return retval; |
| 155 | } |
| 156 | |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 157 | int pysqlite_build_row_cast_map(pysqlite_Cursor* self) |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 158 | { |
| 159 | int i; |
| 160 | const char* type_start = (const char*)-1; |
| 161 | const char* pos; |
| 162 | |
| 163 | const char* colname; |
| 164 | const char* decltype; |
| 165 | PyObject* py_decltype; |
| 166 | PyObject* converter; |
| 167 | PyObject* key; |
| 168 | |
| 169 | if (!self->connection->detect_types) { |
| 170 | return 0; |
| 171 | } |
| 172 | |
Serhiy Storchaka | 4884271 | 2016-04-06 09:45:48 +0300 | [diff] [blame] | 173 | Py_XSETREF(self->row_cast_map, PyList_New(0)); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 174 | |
| 175 | for (i = 0; i < sqlite3_column_count(self->statement->st); i++) { |
| 176 | converter = NULL; |
| 177 | |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 178 | if (self->connection->detect_types & PARSE_COLNAMES) { |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 179 | colname = sqlite3_column_name(self->statement->st, i); |
Thomas Wouters | 477c8d5 | 2006-05-27 19:21:47 +0000 | [diff] [blame] | 180 | if (colname) { |
| 181 | for (pos = colname; *pos != 0; pos++) { |
| 182 | if (*pos == '[') { |
| 183 | type_start = pos + 1; |
| 184 | } else if (*pos == ']' && type_start != (const char*)-1) { |
Brett Cannon | 4043001 | 2007-10-22 20:24:51 +0000 | [diff] [blame] | 185 | key = PyUnicode_FromStringAndSize(type_start, pos - type_start); |
Thomas Wouters | 477c8d5 | 2006-05-27 19:21:47 +0000 | [diff] [blame] | 186 | if (!key) { |
| 187 | /* creating a string failed, but it is too complicated |
| 188 | * to propagate the error here, we just assume there is |
| 189 | * no converter and proceed */ |
| 190 | break; |
| 191 | } |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 192 | |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 193 | converter = _pysqlite_get_converter(key); |
Thomas Wouters | 477c8d5 | 2006-05-27 19:21:47 +0000 | [diff] [blame] | 194 | Py_DECREF(key); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 195 | break; |
| 196 | } |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 197 | } |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 198 | } |
| 199 | } |
| 200 | |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 201 | if (!converter && self->connection->detect_types & PARSE_DECLTYPES) { |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 202 | decltype = sqlite3_column_decltype(self->statement->st, i); |
| 203 | if (decltype) { |
| 204 | for (pos = decltype;;pos++) { |
Christian Heimes | 81ee3ef | 2008-05-04 22:42:01 +0000 | [diff] [blame] | 205 | /* Converter names are split at '(' and blanks. |
| 206 | * This allows 'INTEGER NOT NULL' to be treated as 'INTEGER' and |
| 207 | * 'NUMBER(10)' to be treated as 'NUMBER', for example. |
| 208 | * In other words, it will work as people expect it to work.*/ |
| 209 | if (*pos == ' ' || *pos == '(' || *pos == 0) { |
Brett Cannon | 4043001 | 2007-10-22 20:24:51 +0000 | [diff] [blame] | 210 | py_decltype = PyUnicode_FromStringAndSize(decltype, pos - decltype); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 211 | if (!py_decltype) { |
| 212 | return -1; |
| 213 | } |
| 214 | break; |
| 215 | } |
| 216 | } |
| 217 | |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 218 | converter = _pysqlite_get_converter(py_decltype); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 219 | Py_DECREF(py_decltype); |
| 220 | } |
| 221 | } |
| 222 | |
| 223 | if (!converter) { |
| 224 | converter = Py_None; |
| 225 | } |
| 226 | |
| 227 | if (PyList_Append(self->row_cast_map, converter) != 0) { |
| 228 | if (converter != Py_None) { |
| 229 | Py_DECREF(converter); |
| 230 | } |
Serhiy Storchaka | 505ff75 | 2014-02-09 13:33:53 +0200 | [diff] [blame] | 231 | Py_CLEAR(self->row_cast_map); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 232 | |
| 233 | return -1; |
| 234 | } |
| 235 | } |
| 236 | |
| 237 | return 0; |
| 238 | } |
| 239 | |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 240 | PyObject* _pysqlite_build_column_name(const char* colname) |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 241 | { |
| 242 | const char* pos; |
| 243 | |
| 244 | if (!colname) { |
Berker Peksag | fe21de9 | 2016-04-09 07:34:39 +0300 | [diff] [blame] | 245 | Py_RETURN_NONE; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 246 | } |
| 247 | |
| 248 | for (pos = colname;; pos++) { |
Thomas Wouters | 0e3f591 | 2006-08-11 14:57:12 +0000 | [diff] [blame] | 249 | if (*pos == 0 || *pos == '[') { |
| 250 | if ((*pos == '[') && (pos > colname) && (*(pos-1) == ' ')) { |
| 251 | pos--; |
| 252 | } |
Gerhard Häring | 6d21456 | 2007-08-10 18:15:11 +0000 | [diff] [blame] | 253 | return PyUnicode_FromStringAndSize(colname, pos - colname); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 254 | } |
| 255 | } |
| 256 | } |
| 257 | |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 258 | /* |
| 259 | * Returns a row from the currently active SQLite statement |
| 260 | * |
| 261 | * Precondidition: |
| 262 | * - sqlite3_step() has been called before and it returned SQLITE_ROW. |
| 263 | */ |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 264 | PyObject* _pysqlite_fetch_one_row(pysqlite_Cursor* self) |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 265 | { |
| 266 | int i, numcols; |
| 267 | PyObject* row; |
| 268 | PyObject* item = NULL; |
| 269 | int coltype; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 270 | PyObject* converter; |
| 271 | PyObject* converted; |
| 272 | Py_ssize_t nbytes; |
| 273 | PyObject* buffer; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 274 | const char* val_str; |
| 275 | char buf[200]; |
Thomas Wouters | 477c8d5 | 2006-05-27 19:21:47 +0000 | [diff] [blame] | 276 | const char* colname; |
Gerhard Häring | 873d9ff | 2008-02-29 22:22:09 +0000 | [diff] [blame] | 277 | PyObject* buf_bytes; |
| 278 | PyObject* error_obj; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 279 | |
Gerhard Häring | f9cee22 | 2010-03-05 15:20:03 +0000 | [diff] [blame] | 280 | if (self->reset) { |
| 281 | PyErr_SetString(pysqlite_InterfaceError, errmsg_fetch_across_rollback); |
| 282 | return NULL; |
| 283 | } |
| 284 | |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 285 | Py_BEGIN_ALLOW_THREADS |
| 286 | numcols = sqlite3_data_count(self->statement->st); |
| 287 | Py_END_ALLOW_THREADS |
| 288 | |
| 289 | row = PyTuple_New(numcols); |
Victor Stinner | 297d104 | 2014-06-26 23:32:00 +0200 | [diff] [blame] | 290 | if (!row) |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 291 | return NULL; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 292 | |
| 293 | for (i = 0; i < numcols; i++) { |
| 294 | if (self->connection->detect_types) { |
| 295 | converter = PyList_GetItem(self->row_cast_map, i); |
| 296 | if (!converter) { |
| 297 | converter = Py_None; |
| 298 | } |
| 299 | } else { |
| 300 | converter = Py_None; |
| 301 | } |
| 302 | |
| 303 | if (converter != Py_None) { |
Thomas Wouters | 0e3f591 | 2006-08-11 14:57:12 +0000 | [diff] [blame] | 304 | nbytes = sqlite3_column_bytes(self->statement->st, i); |
| 305 | val_str = (const char*)sqlite3_column_blob(self->statement->st, i); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 306 | if (!val_str) { |
| 307 | Py_INCREF(Py_None); |
| 308 | converted = Py_None; |
| 309 | } else { |
Christian Heimes | 72b710a | 2008-05-26 13:28:38 +0000 | [diff] [blame] | 310 | item = PyBytes_FromStringAndSize(val_str, nbytes); |
Victor Stinner | 297d104 | 2014-06-26 23:32:00 +0200 | [diff] [blame] | 311 | if (!item) |
| 312 | goto error; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 313 | converted = PyObject_CallFunction(converter, "O", item); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 314 | Py_DECREF(item); |
Victor Stinner | 297d104 | 2014-06-26 23:32:00 +0200 | [diff] [blame] | 315 | if (!converted) |
Thomas Wouters | 0e3f591 | 2006-08-11 14:57:12 +0000 | [diff] [blame] | 316 | break; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 317 | } |
| 318 | } else { |
| 319 | Py_BEGIN_ALLOW_THREADS |
| 320 | coltype = sqlite3_column_type(self->statement->st, i); |
| 321 | Py_END_ALLOW_THREADS |
| 322 | if (coltype == SQLITE_NULL) { |
| 323 | Py_INCREF(Py_None); |
| 324 | converted = Py_None; |
| 325 | } else if (coltype == SQLITE_INTEGER) { |
Serhiy Storchaka | 3cf96ac | 2013-02-07 17:01:47 +0200 | [diff] [blame] | 326 | converted = _pysqlite_long_from_int64(sqlite3_column_int64(self->statement->st, i)); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 327 | } else if (coltype == SQLITE_FLOAT) { |
| 328 | converted = PyFloat_FromDouble(sqlite3_column_double(self->statement->st, i)); |
| 329 | } else if (coltype == SQLITE_TEXT) { |
| 330 | val_str = (const char*)sqlite3_column_text(self->statement->st, i); |
Petri Lehtinen | 023fe33 | 2012-02-01 22:18:19 +0200 | [diff] [blame] | 331 | nbytes = sqlite3_column_bytes(self->statement->st, i); |
Petri Lehtinen | bc35beb | 2012-02-09 21:09:03 +0200 | [diff] [blame] | 332 | if (self->connection->text_factory == (PyObject*)&PyUnicode_Type) { |
| 333 | converted = PyUnicode_FromStringAndSize(val_str, nbytes); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 334 | if (!converted) { |
Victor Stinner | 4abda5d | 2013-07-18 01:54:37 +0200 | [diff] [blame] | 335 | PyErr_Clear(); |
Thomas Wouters | 477c8d5 | 2006-05-27 19:21:47 +0000 | [diff] [blame] | 336 | colname = sqlite3_column_name(self->statement->st, i); |
Thomas Wouters | 0e3f591 | 2006-08-11 14:57:12 +0000 | [diff] [blame] | 337 | if (!colname) { |
Thomas Wouters | 477c8d5 | 2006-05-27 19:21:47 +0000 | [diff] [blame] | 338 | colname = "<unknown column name>"; |
| 339 | } |
Thomas Wouters | 0e3f591 | 2006-08-11 14:57:12 +0000 | [diff] [blame] | 340 | PyOS_snprintf(buf, sizeof(buf) - 1, "Could not decode to UTF-8 column '%s' with text '%s'", |
Thomas Wouters | 477c8d5 | 2006-05-27 19:21:47 +0000 | [diff] [blame] | 341 | colname , val_str); |
Victor Stinner | 8699950 | 2010-05-19 01:27:23 +0000 | [diff] [blame] | 342 | buf_bytes = PyByteArray_FromStringAndSize(buf, strlen(buf)); |
Gerhard Häring | 873d9ff | 2008-02-29 22:22:09 +0000 | [diff] [blame] | 343 | if (!buf_bytes) { |
| 344 | PyErr_SetString(pysqlite_OperationalError, "Could not decode to UTF-8"); |
| 345 | } else { |
| 346 | error_obj = PyUnicode_FromEncodedObject(buf_bytes, "ascii", "replace"); |
| 347 | if (!error_obj) { |
| 348 | PyErr_SetString(pysqlite_OperationalError, "Could not decode to UTF-8"); |
Gerhard Häring | 873d9ff | 2008-02-29 22:22:09 +0000 | [diff] [blame] | 349 | } else { |
| 350 | PyErr_SetObject(pysqlite_OperationalError, error_obj); |
Gerhard Häring | e871ad59 | 2008-03-29 14:11:55 +0000 | [diff] [blame] | 351 | Py_DECREF(error_obj); |
Gerhard Häring | 873d9ff | 2008-02-29 22:22:09 +0000 | [diff] [blame] | 352 | } |
| 353 | Py_DECREF(buf_bytes); |
| 354 | } |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 355 | } |
Christian Heimes | 72b710a | 2008-05-26 13:28:38 +0000 | [diff] [blame] | 356 | } else if (self->connection->text_factory == (PyObject*)&PyBytes_Type) { |
Petri Lehtinen | 023fe33 | 2012-02-01 22:18:19 +0200 | [diff] [blame] | 357 | converted = PyBytes_FromStringAndSize(val_str, nbytes); |
Christian Heimes | 9c4756e | 2008-05-26 13:22:05 +0000 | [diff] [blame] | 358 | } else if (self->connection->text_factory == (PyObject*)&PyByteArray_Type) { |
Petri Lehtinen | 023fe33 | 2012-02-01 22:18:19 +0200 | [diff] [blame] | 359 | converted = PyByteArray_FromStringAndSize(val_str, nbytes); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 360 | } else { |
Petri Lehtinen | 023fe33 | 2012-02-01 22:18:19 +0200 | [diff] [blame] | 361 | converted = PyObject_CallFunction(self->connection->text_factory, "y#", val_str, nbytes); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 362 | } |
| 363 | } else { |
| 364 | /* coltype == SQLITE_BLOB */ |
| 365 | nbytes = sqlite3_column_bytes(self->statement->st, i); |
Christian Heimes | 72b710a | 2008-05-26 13:28:38 +0000 | [diff] [blame] | 366 | buffer = PyBytes_FromStringAndSize( |
Guido van Rossum | bae07c9 | 2007-10-08 02:46:15 +0000 | [diff] [blame] | 367 | sqlite3_column_blob(self->statement->st, i), nbytes); |
Victor Stinner | 297d104 | 2014-06-26 23:32:00 +0200 | [diff] [blame] | 368 | if (!buffer) |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 369 | break; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 370 | converted = buffer; |
| 371 | } |
| 372 | } |
| 373 | |
Thomas Wouters | 0e3f591 | 2006-08-11 14:57:12 +0000 | [diff] [blame] | 374 | if (converted) { |
| 375 | PyTuple_SetItem(row, i, converted); |
| 376 | } else { |
| 377 | Py_INCREF(Py_None); |
| 378 | PyTuple_SetItem(row, i, Py_None); |
| 379 | } |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 380 | } |
| 381 | |
Victor Stinner | 297d104 | 2014-06-26 23:32:00 +0200 | [diff] [blame] | 382 | if (PyErr_Occurred()) |
| 383 | goto error; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 384 | |
| 385 | return row; |
Victor Stinner | 297d104 | 2014-06-26 23:32:00 +0200 | [diff] [blame] | 386 | |
| 387 | error: |
| 388 | Py_DECREF(row); |
| 389 | return NULL; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 390 | } |
| 391 | |
Gerhard Häring | f9cee22 | 2010-03-05 15:20:03 +0000 | [diff] [blame] | 392 | /* |
| 393 | * Checks if a cursor object is usable. |
| 394 | * |
| 395 | * 0 => error; 1 => ok |
| 396 | */ |
| 397 | static int check_cursor(pysqlite_Cursor* cur) |
| 398 | { |
| 399 | if (!cur->initialized) { |
| 400 | PyErr_SetString(pysqlite_ProgrammingError, "Base Cursor.__init__ not called."); |
| 401 | return 0; |
| 402 | } |
| 403 | |
| 404 | if (cur->closed) { |
| 405 | PyErr_SetString(pysqlite_ProgrammingError, "Cannot operate on a closed cursor."); |
| 406 | return 0; |
Gerhard Häring | f9cee22 | 2010-03-05 15:20:03 +0000 | [diff] [blame] | 407 | } |
Gerhard Haering | 936d518 | 2011-05-09 12:24:09 +0200 | [diff] [blame] | 408 | |
| 409 | if (cur->locked) { |
| 410 | PyErr_SetString(pysqlite_ProgrammingError, "Recursive use of cursors not allowed."); |
| 411 | return 0; |
| 412 | } |
| 413 | |
| 414 | return pysqlite_check_thread(cur->connection) && pysqlite_check_connection(cur->connection); |
Gerhard Häring | f9cee22 | 2010-03-05 15:20:03 +0000 | [diff] [blame] | 415 | } |
| 416 | |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 417 | PyObject* _pysqlite_query_execute(pysqlite_Cursor* self, int multiple, PyObject* args) |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 418 | { |
| 419 | PyObject* operation; |
Guido van Rossum | 83857e3 | 2007-05-09 23:37:01 +0000 | [diff] [blame] | 420 | const char* operation_cstr; |
| 421 | Py_ssize_t operation_len; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 422 | PyObject* parameters_list = NULL; |
| 423 | PyObject* parameters_iter = NULL; |
| 424 | PyObject* parameters = NULL; |
| 425 | int i; |
| 426 | int rc; |
| 427 | PyObject* func_args; |
| 428 | PyObject* result; |
| 429 | int numcols; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 430 | int statement_type; |
| 431 | PyObject* descriptor; |
| 432 | PyObject* second_argument = NULL; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 433 | |
Gerhard Häring | f9cee22 | 2010-03-05 15:20:03 +0000 | [diff] [blame] | 434 | if (!check_cursor(self)) { |
Gerhard Haering | 936d518 | 2011-05-09 12:24:09 +0200 | [diff] [blame] | 435 | goto error; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 436 | } |
Georg Brandl | f78e02b | 2008-06-10 17:40:04 +0000 | [diff] [blame] | 437 | |
Gerhard Haering | 936d518 | 2011-05-09 12:24:09 +0200 | [diff] [blame] | 438 | self->locked = 1; |
Gerhard Häring | f9cee22 | 2010-03-05 15:20:03 +0000 | [diff] [blame] | 439 | self->reset = 0; |
| 440 | |
Serhiy Storchaka | 505ff75 | 2014-02-09 13:33:53 +0200 | [diff] [blame] | 441 | Py_CLEAR(self->next_row); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 442 | |
| 443 | if (multiple) { |
| 444 | /* executemany() */ |
| 445 | if (!PyArg_ParseTuple(args, "OO", &operation, &second_argument)) { |
Gerhard Haering | 936d518 | 2011-05-09 12:24:09 +0200 | [diff] [blame] | 446 | goto error; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 447 | } |
| 448 | |
Guido van Rossum | 98297ee | 2007-11-06 21:34:58 +0000 | [diff] [blame] | 449 | if (!PyUnicode_Check(operation)) { |
| 450 | PyErr_SetString(PyExc_ValueError, "operation parameter must be str"); |
Gerhard Haering | 936d518 | 2011-05-09 12:24:09 +0200 | [diff] [blame] | 451 | goto error; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 452 | } |
| 453 | |
| 454 | if (PyIter_Check(second_argument)) { |
| 455 | /* iterator */ |
| 456 | Py_INCREF(second_argument); |
| 457 | parameters_iter = second_argument; |
| 458 | } else { |
| 459 | /* sequence */ |
| 460 | parameters_iter = PyObject_GetIter(second_argument); |
Thomas Wouters | 477c8d5 | 2006-05-27 19:21:47 +0000 | [diff] [blame] | 461 | if (!parameters_iter) { |
Gerhard Haering | 936d518 | 2011-05-09 12:24:09 +0200 | [diff] [blame] | 462 | goto error; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 463 | } |
| 464 | } |
| 465 | } else { |
| 466 | /* execute() */ |
| 467 | if (!PyArg_ParseTuple(args, "O|O", &operation, &second_argument)) { |
Gerhard Haering | 936d518 | 2011-05-09 12:24:09 +0200 | [diff] [blame] | 468 | goto error; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 469 | } |
| 470 | |
Guido van Rossum | 98297ee | 2007-11-06 21:34:58 +0000 | [diff] [blame] | 471 | if (!PyUnicode_Check(operation)) { |
| 472 | PyErr_SetString(PyExc_ValueError, "operation parameter must be str"); |
Gerhard Haering | 936d518 | 2011-05-09 12:24:09 +0200 | [diff] [blame] | 473 | goto error; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 474 | } |
| 475 | |
| 476 | parameters_list = PyList_New(0); |
| 477 | if (!parameters_list) { |
Gerhard Haering | 936d518 | 2011-05-09 12:24:09 +0200 | [diff] [blame] | 478 | goto error; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 479 | } |
| 480 | |
| 481 | if (second_argument == NULL) { |
| 482 | second_argument = PyTuple_New(0); |
| 483 | if (!second_argument) { |
| 484 | goto error; |
| 485 | } |
| 486 | } else { |
| 487 | Py_INCREF(second_argument); |
| 488 | } |
| 489 | if (PyList_Append(parameters_list, second_argument) != 0) { |
| 490 | Py_DECREF(second_argument); |
| 491 | goto error; |
| 492 | } |
| 493 | Py_DECREF(second_argument); |
| 494 | |
| 495 | parameters_iter = PyObject_GetIter(parameters_list); |
| 496 | if (!parameters_iter) { |
| 497 | goto error; |
| 498 | } |
| 499 | } |
| 500 | |
| 501 | if (self->statement != NULL) { |
| 502 | /* There is an active statement */ |
Brett Cannon | b94767f | 2011-02-22 20:15:44 +0000 | [diff] [blame] | 503 | pysqlite_statement_reset(self->statement); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 504 | } |
| 505 | |
Marc-André Lemburg | 4cc0f24 | 2008-08-07 18:54:33 +0000 | [diff] [blame] | 506 | operation_cstr = _PyUnicode_AsStringAndSize(operation, &operation_len); |
Victor Stinner | 8699950 | 2010-05-19 01:27:23 +0000 | [diff] [blame] | 507 | if (operation_cstr == NULL) |
Guido van Rossum | 83857e3 | 2007-05-09 23:37:01 +0000 | [diff] [blame] | 508 | goto error; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 509 | |
Georg Brandl | f78e02b | 2008-06-10 17:40:04 +0000 | [diff] [blame] | 510 | /* reset description and rowcount */ |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 511 | Py_INCREF(Py_None); |
Serhiy Storchaka | 57a01d3 | 2016-04-10 18:05:40 +0300 | [diff] [blame] | 512 | Py_SETREF(self->description, Py_None); |
Georg Brandl | f78e02b | 2008-06-10 17:40:04 +0000 | [diff] [blame] | 513 | self->rowcount = -1L; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 514 | |
Gerhard Häring | e7ea745 | 2008-03-29 00:45:29 +0000 | [diff] [blame] | 515 | func_args = PyTuple_New(1); |
| 516 | if (!func_args) { |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 517 | goto error; |
| 518 | } |
Gerhard Häring | e7ea745 | 2008-03-29 00:45:29 +0000 | [diff] [blame] | 519 | Py_INCREF(operation); |
| 520 | if (PyTuple_SetItem(func_args, 0, operation) != 0) { |
| 521 | goto error; |
| 522 | } |
| 523 | |
| 524 | if (self->statement) { |
| 525 | (void)pysqlite_statement_reset(self->statement); |
Gerhard Häring | e7ea745 | 2008-03-29 00:45:29 +0000 | [diff] [blame] | 526 | } |
| 527 | |
Serhiy Storchaka | 4884271 | 2016-04-06 09:45:48 +0300 | [diff] [blame] | 528 | Py_XSETREF(self->statement, |
Serhiy Storchaka | 191321d | 2015-12-27 15:41:34 +0200 | [diff] [blame] | 529 | (pysqlite_Statement *)pysqlite_cache_get(self->connection->statement_cache, func_args)); |
Gerhard Häring | e7ea745 | 2008-03-29 00:45:29 +0000 | [diff] [blame] | 530 | Py_DECREF(func_args); |
| 531 | |
| 532 | if (!self->statement) { |
| 533 | goto error; |
| 534 | } |
| 535 | |
| 536 | if (self->statement->in_use) { |
Serhiy Storchaka | 57a01d3 | 2016-04-10 18:05:40 +0300 | [diff] [blame] | 537 | Py_SETREF(self->statement, |
Serhiy Storchaka | 5a57ade | 2015-12-24 10:35:59 +0200 | [diff] [blame] | 538 | PyObject_New(pysqlite_Statement, &pysqlite_StatementType)); |
Gerhard Häring | e7ea745 | 2008-03-29 00:45:29 +0000 | [diff] [blame] | 539 | if (!self->statement) { |
| 540 | goto error; |
| 541 | } |
| 542 | rc = pysqlite_statement_create(self->statement, self->connection, operation); |
| 543 | if (rc != SQLITE_OK) { |
Alexandre Vassalotti | 1839bac | 2008-07-13 21:57:48 +0000 | [diff] [blame] | 544 | Py_CLEAR(self->statement); |
Gerhard Häring | e7ea745 | 2008-03-29 00:45:29 +0000 | [diff] [blame] | 545 | goto error; |
| 546 | } |
| 547 | } |
| 548 | |
| 549 | pysqlite_statement_reset(self->statement); |
| 550 | pysqlite_statement_mark_dirty(self->statement); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 551 | |
| 552 | statement_type = detect_statement_type(operation_cstr); |
| 553 | if (self->connection->begin_statement) { |
| 554 | switch (statement_type) { |
| 555 | case STATEMENT_UPDATE: |
| 556 | case STATEMENT_DELETE: |
| 557 | case STATEMENT_INSERT: |
| 558 | case STATEMENT_REPLACE: |
| 559 | if (!self->connection->inTransaction) { |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 560 | result = _pysqlite_connection_begin(self->connection); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 561 | if (!result) { |
| 562 | goto error; |
| 563 | } |
| 564 | Py_DECREF(result); |
| 565 | } |
| 566 | break; |
| 567 | case STATEMENT_OTHER: |
| 568 | /* it's a DDL statement or something similar |
| 569 | - we better COMMIT first so it works for all cases */ |
| 570 | if (self->connection->inTransaction) { |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 571 | result = pysqlite_connection_commit(self->connection, NULL); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 572 | if (!result) { |
| 573 | goto error; |
| 574 | } |
| 575 | Py_DECREF(result); |
| 576 | } |
| 577 | break; |
| 578 | case STATEMENT_SELECT: |
| 579 | if (multiple) { |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 580 | PyErr_SetString(pysqlite_ProgrammingError, |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 581 | "You cannot execute SELECT statements in executemany()."); |
| 582 | goto error; |
| 583 | } |
| 584 | break; |
| 585 | } |
| 586 | } |
| 587 | |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 588 | |
| 589 | while (1) { |
| 590 | parameters = PyIter_Next(parameters_iter); |
| 591 | if (!parameters) { |
| 592 | break; |
| 593 | } |
| 594 | |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 595 | pysqlite_statement_mark_dirty(self->statement); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 596 | |
Petri Lehtinen | bc35beb | 2012-02-09 21:09:03 +0200 | [diff] [blame] | 597 | pysqlite_statement_bind_parameters(self->statement, parameters); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 598 | if (PyErr_Occurred()) { |
| 599 | goto error; |
| 600 | } |
| 601 | |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 602 | /* Keep trying the SQL statement until the schema stops changing. */ |
| 603 | while (1) { |
| 604 | /* Actually execute the SQL statement. */ |
Benjamin Peterson | d7b0328 | 2008-09-13 15:58:53 +0000 | [diff] [blame] | 605 | rc = pysqlite_step(self->statement->st, self->connection); |
Victor Stinner | 297d104 | 2014-06-26 23:32:00 +0200 | [diff] [blame] | 606 | if (PyErr_Occurred()) { |
| 607 | (void)pysqlite_statement_reset(self->statement); |
| 608 | goto error; |
| 609 | } |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 610 | if (rc == SQLITE_DONE || rc == SQLITE_ROW) { |
| 611 | /* If it worked, let's get out of the loop */ |
| 612 | break; |
| 613 | } |
| 614 | /* Something went wrong. Re-set the statement and try again. */ |
| 615 | rc = pysqlite_statement_reset(self->statement); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 616 | if (rc == SQLITE_SCHEMA) { |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 617 | /* If this was a result of the schema changing, let's try |
| 618 | again. */ |
| 619 | rc = pysqlite_statement_recompile(self->statement, parameters); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 620 | if (rc == SQLITE_OK) { |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 621 | continue; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 622 | } else { |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 623 | /* If the database gave us an error, promote it to Python. */ |
Gerhard Häring | e7ea745 | 2008-03-29 00:45:29 +0000 | [diff] [blame] | 624 | (void)pysqlite_statement_reset(self->statement); |
| 625 | _pysqlite_seterror(self->connection->db, NULL); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 626 | goto error; |
| 627 | } |
| 628 | } else { |
Thomas Wouters | 0e3f591 | 2006-08-11 14:57:12 +0000 | [diff] [blame] | 629 | if (PyErr_Occurred()) { |
| 630 | /* there was an error that occurred in a user-defined callback */ |
| 631 | if (_enable_callback_tracebacks) { |
| 632 | PyErr_Print(); |
| 633 | } else { |
| 634 | PyErr_Clear(); |
| 635 | } |
| 636 | } |
Gerhard Häring | e7ea745 | 2008-03-29 00:45:29 +0000 | [diff] [blame] | 637 | (void)pysqlite_statement_reset(self->statement); |
| 638 | _pysqlite_seterror(self->connection->db, NULL); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 639 | goto error; |
| 640 | } |
| 641 | } |
| 642 | |
Gerhard Häring | e7ea745 | 2008-03-29 00:45:29 +0000 | [diff] [blame] | 643 | if (pysqlite_build_row_cast_map(self) != 0) { |
| 644 | PyErr_SetString(pysqlite_OperationalError, "Error while building row_cast_map"); |
| 645 | goto error; |
| 646 | } |
| 647 | |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 648 | if (rc == SQLITE_ROW || (rc == SQLITE_DONE && statement_type == STATEMENT_SELECT)) { |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 649 | if (self->description == Py_None) { |
Gerhard Häring | e7ea745 | 2008-03-29 00:45:29 +0000 | [diff] [blame] | 650 | Py_BEGIN_ALLOW_THREADS |
| 651 | numcols = sqlite3_column_count(self->statement->st); |
| 652 | Py_END_ALLOW_THREADS |
| 653 | |
Serhiy Storchaka | 57a01d3 | 2016-04-10 18:05:40 +0300 | [diff] [blame] | 654 | Py_SETREF(self->description, PyTuple_New(numcols)); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 655 | if (!self->description) { |
| 656 | goto error; |
| 657 | } |
| 658 | for (i = 0; i < numcols; i++) { |
| 659 | descriptor = PyTuple_New(7); |
| 660 | if (!descriptor) { |
| 661 | goto error; |
| 662 | } |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 663 | PyTuple_SetItem(descriptor, 0, _pysqlite_build_column_name(sqlite3_column_name(self->statement->st, i))); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 664 | Py_INCREF(Py_None); PyTuple_SetItem(descriptor, 1, Py_None); |
| 665 | Py_INCREF(Py_None); PyTuple_SetItem(descriptor, 2, Py_None); |
| 666 | Py_INCREF(Py_None); PyTuple_SetItem(descriptor, 3, Py_None); |
| 667 | Py_INCREF(Py_None); PyTuple_SetItem(descriptor, 4, Py_None); |
| 668 | Py_INCREF(Py_None); PyTuple_SetItem(descriptor, 5, Py_None); |
| 669 | Py_INCREF(Py_None); PyTuple_SetItem(descriptor, 6, Py_None); |
| 670 | PyTuple_SetItem(self->description, i, descriptor); |
| 671 | } |
| 672 | } |
| 673 | } |
| 674 | |
| 675 | if (rc == SQLITE_ROW) { |
| 676 | if (multiple) { |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 677 | PyErr_SetString(pysqlite_ProgrammingError, "executemany() can only execute DML statements."); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 678 | goto error; |
| 679 | } |
| 680 | |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 681 | self->next_row = _pysqlite_fetch_one_row(self); |
Victor Stinner | 297d104 | 2014-06-26 23:32:00 +0200 | [diff] [blame] | 682 | if (self->next_row == NULL) |
| 683 | goto error; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 684 | } else if (rc == SQLITE_DONE && !multiple) { |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 685 | pysqlite_statement_reset(self->statement); |
Alexandre Vassalotti | 1839bac | 2008-07-13 21:57:48 +0000 | [diff] [blame] | 686 | Py_CLEAR(self->statement); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 687 | } |
| 688 | |
| 689 | switch (statement_type) { |
| 690 | case STATEMENT_UPDATE: |
| 691 | case STATEMENT_DELETE: |
| 692 | case STATEMENT_INSERT: |
| 693 | case STATEMENT_REPLACE: |
Georg Brandl | f78e02b | 2008-06-10 17:40:04 +0000 | [diff] [blame] | 694 | if (self->rowcount == -1L) { |
| 695 | self->rowcount = 0L; |
| 696 | } |
| 697 | self->rowcount += (long)sqlite3_changes(self->connection->db); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 698 | } |
| 699 | |
| 700 | Py_DECREF(self->lastrowid); |
Gerhard Häring | e7ea745 | 2008-03-29 00:45:29 +0000 | [diff] [blame] | 701 | if (!multiple && statement_type == STATEMENT_INSERT) { |
Serhiy Storchaka | d160b12 | 2013-04-28 14:10:27 +0300 | [diff] [blame] | 702 | sqlite_int64 lastrowid; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 703 | Py_BEGIN_ALLOW_THREADS |
| 704 | lastrowid = sqlite3_last_insert_rowid(self->connection->db); |
| 705 | Py_END_ALLOW_THREADS |
Serhiy Storchaka | 3cf96ac | 2013-02-07 17:01:47 +0200 | [diff] [blame] | 706 | self->lastrowid = _pysqlite_long_from_int64(lastrowid); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 707 | } else { |
| 708 | Py_INCREF(Py_None); |
| 709 | self->lastrowid = Py_None; |
| 710 | } |
| 711 | |
| 712 | if (multiple) { |
Brett Cannon | b94767f | 2011-02-22 20:15:44 +0000 | [diff] [blame] | 713 | pysqlite_statement_reset(self->statement); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 714 | } |
| 715 | Py_XDECREF(parameters); |
| 716 | } |
| 717 | |
| 718 | error: |
Gerhard Häring | e7ea745 | 2008-03-29 00:45:29 +0000 | [diff] [blame] | 719 | /* just to be sure (implicit ROLLBACKs with ON CONFLICT ROLLBACK/OR |
| 720 | * ROLLBACK could have happened */ |
| 721 | #ifdef SQLITE_VERSION_NUMBER |
| 722 | #if SQLITE_VERSION_NUMBER >= 3002002 |
Gerhard Haering | 936d518 | 2011-05-09 12:24:09 +0200 | [diff] [blame] | 723 | if (self->connection && self->connection->db) |
| 724 | self->connection->inTransaction = !sqlite3_get_autocommit(self->connection->db); |
Gerhard Häring | e7ea745 | 2008-03-29 00:45:29 +0000 | [diff] [blame] | 725 | #endif |
| 726 | #endif |
| 727 | |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 728 | Py_XDECREF(parameters); |
| 729 | Py_XDECREF(parameters_iter); |
| 730 | Py_XDECREF(parameters_list); |
| 731 | |
Gerhard Haering | 936d518 | 2011-05-09 12:24:09 +0200 | [diff] [blame] | 732 | self->locked = 0; |
| 733 | |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 734 | if (PyErr_Occurred()) { |
Georg Brandl | f78e02b | 2008-06-10 17:40:04 +0000 | [diff] [blame] | 735 | self->rowcount = -1L; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 736 | return NULL; |
| 737 | } else { |
| 738 | Py_INCREF(self); |
| 739 | return (PyObject*)self; |
| 740 | } |
| 741 | } |
| 742 | |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 743 | PyObject* pysqlite_cursor_execute(pysqlite_Cursor* self, PyObject* args) |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 744 | { |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 745 | return _pysqlite_query_execute(self, 0, args); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 746 | } |
| 747 | |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 748 | PyObject* pysqlite_cursor_executemany(pysqlite_Cursor* self, PyObject* args) |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 749 | { |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 750 | return _pysqlite_query_execute(self, 1, args); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 751 | } |
| 752 | |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 753 | PyObject* pysqlite_cursor_executescript(pysqlite_Cursor* self, PyObject* args) |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 754 | { |
| 755 | PyObject* script_obj; |
| 756 | PyObject* script_str = NULL; |
| 757 | const char* script_cstr; |
| 758 | sqlite3_stmt* statement; |
| 759 | int rc; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 760 | PyObject* result; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 761 | |
| 762 | if (!PyArg_ParseTuple(args, "O", &script_obj)) { |
Gerhard Häring | e7ea745 | 2008-03-29 00:45:29 +0000 | [diff] [blame] | 763 | return NULL; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 764 | } |
| 765 | |
Gerhard Häring | f9cee22 | 2010-03-05 15:20:03 +0000 | [diff] [blame] | 766 | if (!check_cursor(self)) { |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 767 | return NULL; |
| 768 | } |
| 769 | |
Gerhard Häring | f9cee22 | 2010-03-05 15:20:03 +0000 | [diff] [blame] | 770 | self->reset = 0; |
| 771 | |
Gerhard Häring | 6d21456 | 2007-08-10 18:15:11 +0000 | [diff] [blame] | 772 | if (PyUnicode_Check(script_obj)) { |
Marc-André Lemburg | 4cc0f24 | 2008-08-07 18:54:33 +0000 | [diff] [blame] | 773 | script_cstr = _PyUnicode_AsString(script_obj); |
Gerhard Häring | 6d21456 | 2007-08-10 18:15:11 +0000 | [diff] [blame] | 774 | if (!script_cstr) { |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 775 | return NULL; |
| 776 | } |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 777 | } else { |
Gerhard Häring | 6d21456 | 2007-08-10 18:15:11 +0000 | [diff] [blame] | 778 | PyErr_SetString(PyExc_ValueError, "script argument must be unicode."); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 779 | return NULL; |
| 780 | } |
| 781 | |
| 782 | /* commit first */ |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 783 | result = pysqlite_connection_commit(self->connection, NULL); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 784 | if (!result) { |
| 785 | goto error; |
| 786 | } |
| 787 | Py_DECREF(result); |
| 788 | |
| 789 | while (1) { |
Benjamin Peterson | d7b0328 | 2008-09-13 15:58:53 +0000 | [diff] [blame] | 790 | Py_BEGIN_ALLOW_THREADS |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 791 | rc = sqlite3_prepare(self->connection->db, |
| 792 | script_cstr, |
| 793 | -1, |
| 794 | &statement, |
| 795 | &script_cstr); |
Benjamin Peterson | d7b0328 | 2008-09-13 15:58:53 +0000 | [diff] [blame] | 796 | Py_END_ALLOW_THREADS |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 797 | if (rc != SQLITE_OK) { |
Gerhard Häring | e7ea745 | 2008-03-29 00:45:29 +0000 | [diff] [blame] | 798 | _pysqlite_seterror(self->connection->db, NULL); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 799 | goto error; |
| 800 | } |
| 801 | |
| 802 | /* execute statement, and ignore results of SELECT statements */ |
| 803 | rc = SQLITE_ROW; |
| 804 | while (rc == SQLITE_ROW) { |
Benjamin Peterson | d7b0328 | 2008-09-13 15:58:53 +0000 | [diff] [blame] | 805 | rc = pysqlite_step(statement, self->connection); |
Victor Stinner | 297d104 | 2014-06-26 23:32:00 +0200 | [diff] [blame] | 806 | if (PyErr_Occurred()) { |
| 807 | (void)sqlite3_finalize(statement); |
| 808 | goto error; |
| 809 | } |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 810 | } |
| 811 | |
| 812 | if (rc != SQLITE_DONE) { |
| 813 | (void)sqlite3_finalize(statement); |
Gerhard Häring | e7ea745 | 2008-03-29 00:45:29 +0000 | [diff] [blame] | 814 | _pysqlite_seterror(self->connection->db, NULL); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 815 | goto error; |
| 816 | } |
| 817 | |
| 818 | rc = sqlite3_finalize(statement); |
| 819 | if (rc != SQLITE_OK) { |
Gerhard Häring | e7ea745 | 2008-03-29 00:45:29 +0000 | [diff] [blame] | 820 | _pysqlite_seterror(self->connection->db, NULL); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 821 | goto error; |
| 822 | } |
Gerhard Häring | f9cee22 | 2010-03-05 15:20:03 +0000 | [diff] [blame] | 823 | |
| 824 | if (*script_cstr == (char)0) { |
| 825 | break; |
| 826 | } |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 827 | } |
| 828 | |
| 829 | error: |
| 830 | Py_XDECREF(script_str); |
| 831 | |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 832 | if (PyErr_Occurred()) { |
| 833 | return NULL; |
| 834 | } else { |
| 835 | Py_INCREF(self); |
| 836 | return (PyObject*)self; |
| 837 | } |
| 838 | } |
| 839 | |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 840 | PyObject* pysqlite_cursor_getiter(pysqlite_Cursor *self) |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 841 | { |
| 842 | Py_INCREF(self); |
| 843 | return (PyObject*)self; |
| 844 | } |
| 845 | |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 846 | PyObject* pysqlite_cursor_iternext(pysqlite_Cursor *self) |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 847 | { |
| 848 | PyObject* next_row_tuple; |
| 849 | PyObject* next_row; |
| 850 | int rc; |
| 851 | |
Gerhard Häring | f9cee22 | 2010-03-05 15:20:03 +0000 | [diff] [blame] | 852 | if (!check_cursor(self)) { |
| 853 | return NULL; |
| 854 | } |
| 855 | |
| 856 | if (self->reset) { |
| 857 | PyErr_SetString(pysqlite_InterfaceError, errmsg_fetch_across_rollback); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 858 | return NULL; |
| 859 | } |
| 860 | |
| 861 | if (!self->next_row) { |
| 862 | if (self->statement) { |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 863 | (void)pysqlite_statement_reset(self->statement); |
Serhiy Storchaka | 505ff75 | 2014-02-09 13:33:53 +0200 | [diff] [blame] | 864 | Py_CLEAR(self->statement); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 865 | } |
| 866 | return NULL; |
| 867 | } |
| 868 | |
| 869 | next_row_tuple = self->next_row; |
Victor Stinner | 85a12a8 | 2013-11-05 14:50:30 +0100 | [diff] [blame] | 870 | assert(next_row_tuple != NULL); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 871 | self->next_row = NULL; |
| 872 | |
| 873 | if (self->row_factory != Py_None) { |
| 874 | next_row = PyObject_CallFunction(self->row_factory, "OO", self, next_row_tuple); |
Victor Stinner | 85a12a8 | 2013-11-05 14:50:30 +0100 | [diff] [blame] | 875 | if (next_row == NULL) { |
| 876 | self->next_row = next_row_tuple; |
| 877 | return NULL; |
| 878 | } |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 879 | Py_DECREF(next_row_tuple); |
| 880 | } else { |
| 881 | next_row = next_row_tuple; |
| 882 | } |
| 883 | |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 884 | if (self->statement) { |
Benjamin Peterson | d7b0328 | 2008-09-13 15:58:53 +0000 | [diff] [blame] | 885 | rc = pysqlite_step(self->statement->st, self->connection); |
Victor Stinner | 297d104 | 2014-06-26 23:32:00 +0200 | [diff] [blame] | 886 | if (PyErr_Occurred()) { |
| 887 | (void)pysqlite_statement_reset(self->statement); |
| 888 | Py_DECREF(next_row); |
| 889 | return NULL; |
| 890 | } |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 891 | if (rc != SQLITE_DONE && rc != SQLITE_ROW) { |
Gerhard Häring | e7ea745 | 2008-03-29 00:45:29 +0000 | [diff] [blame] | 892 | (void)pysqlite_statement_reset(self->statement); |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 893 | Py_DECREF(next_row); |
Gerhard Häring | e7ea745 | 2008-03-29 00:45:29 +0000 | [diff] [blame] | 894 | _pysqlite_seterror(self->connection->db, NULL); |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 895 | return NULL; |
| 896 | } |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 897 | |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 898 | if (rc == SQLITE_ROW) { |
| 899 | self->next_row = _pysqlite_fetch_one_row(self); |
Victor Stinner | dd4b299 | 2013-11-05 14:30:11 +0100 | [diff] [blame] | 900 | if (self->next_row == NULL) { |
| 901 | (void)pysqlite_statement_reset(self->statement); |
Victor Stinner | dd4b299 | 2013-11-05 14:30:11 +0100 | [diff] [blame] | 902 | return NULL; |
| 903 | } |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 904 | } |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 905 | } |
| 906 | |
| 907 | return next_row; |
| 908 | } |
| 909 | |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 910 | PyObject* pysqlite_cursor_fetchone(pysqlite_Cursor* self, PyObject* args) |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 911 | { |
| 912 | PyObject* row; |
| 913 | |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 914 | row = pysqlite_cursor_iternext(self); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 915 | if (!row && !PyErr_Occurred()) { |
Berker Peksag | fe21de9 | 2016-04-09 07:34:39 +0300 | [diff] [blame] | 916 | Py_RETURN_NONE; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 917 | } |
| 918 | |
| 919 | return row; |
| 920 | } |
| 921 | |
Gerhard Häring | e7ea745 | 2008-03-29 00:45:29 +0000 | [diff] [blame] | 922 | PyObject* pysqlite_cursor_fetchmany(pysqlite_Cursor* self, PyObject* args, PyObject* kwargs) |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 923 | { |
Gerhard Häring | e7ea745 | 2008-03-29 00:45:29 +0000 | [diff] [blame] | 924 | static char *kwlist[] = {"size", NULL, NULL}; |
| 925 | |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 926 | PyObject* row; |
| 927 | PyObject* list; |
| 928 | int maxrows = self->arraysize; |
| 929 | int counter = 0; |
| 930 | |
Gerhard Häring | e7ea745 | 2008-03-29 00:45:29 +0000 | [diff] [blame] | 931 | if (!PyArg_ParseTupleAndKeywords(args, kwargs, "|i:fetchmany", kwlist, &maxrows)) { |
| 932 | return NULL; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 933 | } |
| 934 | |
| 935 | list = PyList_New(0); |
| 936 | if (!list) { |
| 937 | return NULL; |
| 938 | } |
| 939 | |
| 940 | /* just make sure we enter the loop */ |
| 941 | row = Py_None; |
| 942 | |
| 943 | while (row) { |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 944 | row = pysqlite_cursor_iternext(self); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 945 | if (row) { |
| 946 | PyList_Append(list, row); |
| 947 | Py_DECREF(row); |
| 948 | } else { |
| 949 | break; |
| 950 | } |
| 951 | |
| 952 | if (++counter == maxrows) { |
| 953 | break; |
| 954 | } |
| 955 | } |
| 956 | |
| 957 | if (PyErr_Occurred()) { |
| 958 | Py_DECREF(list); |
| 959 | return NULL; |
| 960 | } else { |
| 961 | return list; |
| 962 | } |
| 963 | } |
| 964 | |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 965 | PyObject* pysqlite_cursor_fetchall(pysqlite_Cursor* self, PyObject* args) |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 966 | { |
| 967 | PyObject* row; |
| 968 | PyObject* list; |
| 969 | |
| 970 | list = PyList_New(0); |
| 971 | if (!list) { |
| 972 | return NULL; |
| 973 | } |
| 974 | |
| 975 | /* just make sure we enter the loop */ |
| 976 | row = (PyObject*)Py_None; |
| 977 | |
| 978 | while (row) { |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 979 | row = pysqlite_cursor_iternext(self); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 980 | if (row) { |
| 981 | PyList_Append(list, row); |
| 982 | Py_DECREF(row); |
| 983 | } |
| 984 | } |
| 985 | |
| 986 | if (PyErr_Occurred()) { |
| 987 | Py_DECREF(list); |
| 988 | return NULL; |
| 989 | } else { |
| 990 | return list; |
| 991 | } |
| 992 | } |
| 993 | |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 994 | PyObject* pysqlite_noop(pysqlite_Connection* self, PyObject* args) |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 995 | { |
| 996 | /* don't care, return None */ |
Berker Peksag | fe21de9 | 2016-04-09 07:34:39 +0300 | [diff] [blame] | 997 | Py_RETURN_NONE; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 998 | } |
| 999 | |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 1000 | PyObject* pysqlite_cursor_close(pysqlite_Cursor* self, PyObject* args) |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 1001 | { |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 1002 | if (!pysqlite_check_thread(self->connection) || !pysqlite_check_connection(self->connection)) { |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 1003 | return NULL; |
| 1004 | } |
| 1005 | |
| 1006 | if (self->statement) { |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 1007 | (void)pysqlite_statement_reset(self->statement); |
Alexandre Vassalotti | 1839bac | 2008-07-13 21:57:48 +0000 | [diff] [blame] | 1008 | Py_CLEAR(self->statement); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 1009 | } |
| 1010 | |
Gerhard Häring | f9cee22 | 2010-03-05 15:20:03 +0000 | [diff] [blame] | 1011 | self->closed = 1; |
| 1012 | |
Berker Peksag | fe21de9 | 2016-04-09 07:34:39 +0300 | [diff] [blame] | 1013 | Py_RETURN_NONE; |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 1014 | } |
| 1015 | |
| 1016 | static PyMethodDef cursor_methods[] = { |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 1017 | {"execute", (PyCFunction)pysqlite_cursor_execute, METH_VARARGS, |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 1018 | PyDoc_STR("Executes a SQL statement.")}, |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 1019 | {"executemany", (PyCFunction)pysqlite_cursor_executemany, METH_VARARGS, |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 1020 | PyDoc_STR("Repeatedly executes a SQL statement.")}, |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 1021 | {"executescript", (PyCFunction)pysqlite_cursor_executescript, METH_VARARGS, |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 1022 | PyDoc_STR("Executes a multiple SQL statements at once. Non-standard.")}, |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 1023 | {"fetchone", (PyCFunction)pysqlite_cursor_fetchone, METH_NOARGS, |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 1024 | PyDoc_STR("Fetches one row from the resultset.")}, |
Gerhard Häring | e7ea745 | 2008-03-29 00:45:29 +0000 | [diff] [blame] | 1025 | {"fetchmany", (PyCFunction)pysqlite_cursor_fetchmany, METH_VARARGS|METH_KEYWORDS, |
Christian Heimes | fdab48e | 2008-01-20 09:06:41 +0000 | [diff] [blame] | 1026 | PyDoc_STR("Fetches several rows from the resultset.")}, |
| 1027 | {"fetchall", (PyCFunction)pysqlite_cursor_fetchall, METH_NOARGS, |
| 1028 | PyDoc_STR("Fetches all rows from the resultset.")}, |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 1029 | {"close", (PyCFunction)pysqlite_cursor_close, METH_NOARGS, |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 1030 | PyDoc_STR("Closes the cursor.")}, |
| 1031 | {"setinputsizes", (PyCFunction)pysqlite_noop, METH_VARARGS, |
| 1032 | PyDoc_STR("Required by DB-API. Does nothing in pysqlite.")}, |
| 1033 | {"setoutputsize", (PyCFunction)pysqlite_noop, METH_VARARGS, |
| 1034 | PyDoc_STR("Required by DB-API. Does nothing in pysqlite.")}, |
| 1035 | {NULL, NULL} |
| 1036 | }; |
| 1037 | |
| 1038 | static struct PyMemberDef cursor_members[] = |
| 1039 | { |
Guido van Rossum | 10f07c4 | 2007-08-11 15:32:55 +0000 | [diff] [blame] | 1040 | {"connection", T_OBJECT, offsetof(pysqlite_Cursor, connection), READONLY}, |
| 1041 | {"description", T_OBJECT, offsetof(pysqlite_Cursor, description), READONLY}, |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 1042 | {"arraysize", T_INT, offsetof(pysqlite_Cursor, arraysize), 0}, |
Guido van Rossum | 10f07c4 | 2007-08-11 15:32:55 +0000 | [diff] [blame] | 1043 | {"lastrowid", T_OBJECT, offsetof(pysqlite_Cursor, lastrowid), READONLY}, |
Georg Brandl | f78e02b | 2008-06-10 17:40:04 +0000 | [diff] [blame] | 1044 | {"rowcount", T_LONG, offsetof(pysqlite_Cursor, rowcount), READONLY}, |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 1045 | {"row_factory", T_OBJECT, offsetof(pysqlite_Cursor, row_factory), 0}, |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 1046 | {NULL} |
| 1047 | }; |
| 1048 | |
Serhiy Storchaka | 2d06e84 | 2015-12-25 19:53:18 +0200 | [diff] [blame] | 1049 | static const char cursor_doc[] = |
Thomas Wouters | 477c8d5 | 2006-05-27 19:21:47 +0000 | [diff] [blame] | 1050 | PyDoc_STR("SQLite database cursor class."); |
| 1051 | |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 1052 | PyTypeObject pysqlite_CursorType = { |
Martin v. Löwis | 9f2e346 | 2007-07-21 17:22:18 +0000 | [diff] [blame] | 1053 | PyVarObject_HEAD_INIT(NULL, 0) |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 1054 | MODULE_NAME ".Cursor", /* tp_name */ |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 1055 | sizeof(pysqlite_Cursor), /* tp_basicsize */ |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 1056 | 0, /* tp_itemsize */ |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 1057 | (destructor)pysqlite_cursor_dealloc, /* tp_dealloc */ |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 1058 | 0, /* tp_print */ |
| 1059 | 0, /* tp_getattr */ |
| 1060 | 0, /* tp_setattr */ |
Mark Dickinson | e94c679 | 2009-02-02 20:36:42 +0000 | [diff] [blame] | 1061 | 0, /* tp_reserved */ |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 1062 | 0, /* tp_repr */ |
| 1063 | 0, /* tp_as_number */ |
| 1064 | 0, /* tp_as_sequence */ |
| 1065 | 0, /* tp_as_mapping */ |
| 1066 | 0, /* tp_hash */ |
| 1067 | 0, /* tp_call */ |
| 1068 | 0, /* tp_str */ |
| 1069 | 0, /* tp_getattro */ |
| 1070 | 0, /* tp_setattro */ |
| 1071 | 0, /* tp_as_buffer */ |
Gerhard Häring | f9cee22 | 2010-03-05 15:20:03 +0000 | [diff] [blame] | 1072 | Py_TPFLAGS_DEFAULT|Py_TPFLAGS_BASETYPE, /* tp_flags */ |
Thomas Wouters | 477c8d5 | 2006-05-27 19:21:47 +0000 | [diff] [blame] | 1073 | cursor_doc, /* tp_doc */ |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 1074 | 0, /* tp_traverse */ |
| 1075 | 0, /* tp_clear */ |
| 1076 | 0, /* tp_richcompare */ |
Gerhard Häring | f9cee22 | 2010-03-05 15:20:03 +0000 | [diff] [blame] | 1077 | offsetof(pysqlite_Cursor, in_weakreflist), /* tp_weaklistoffset */ |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 1078 | (getiterfunc)pysqlite_cursor_getiter, /* tp_iter */ |
| 1079 | (iternextfunc)pysqlite_cursor_iternext, /* tp_iternext */ |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 1080 | cursor_methods, /* tp_methods */ |
| 1081 | cursor_members, /* tp_members */ |
| 1082 | 0, /* tp_getset */ |
| 1083 | 0, /* tp_base */ |
| 1084 | 0, /* tp_dict */ |
| 1085 | 0, /* tp_descr_get */ |
| 1086 | 0, /* tp_descr_set */ |
| 1087 | 0, /* tp_dictoffset */ |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 1088 | (initproc)pysqlite_cursor_init, /* tp_init */ |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 1089 | 0, /* tp_alloc */ |
| 1090 | 0, /* tp_new */ |
| 1091 | 0 /* tp_free */ |
| 1092 | }; |
| 1093 | |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 1094 | extern int pysqlite_cursor_setup_types(void) |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 1095 | { |
Thomas Wouters | fc7bb8c | 2007-01-15 15:49:28 +0000 | [diff] [blame] | 1096 | pysqlite_CursorType.tp_new = PyType_GenericNew; |
| 1097 | return PyType_Ready(&pysqlite_CursorType); |
Thomas Wouters | 49fd7fa | 2006-04-21 10:40:58 +0000 | [diff] [blame] | 1098 | } |