/Modules/_sqlite/util.c

http://unladen-swallow.googlecode.com/ · C · 106 lines · 67 code · 10 blank · 29 comment · 6 complexity · 5a42f606f940b42ce83952e123a176ff MD5 · raw file

  1. /* util.c - various utility functions
  2. *
  3. * Copyright (C) 2005-2007 Gerhard Häring <gh@ghaering.de>
  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. #include "module.h"
  24. #include "connection.h"
  25. int pysqlite_step(sqlite3_stmt* statement, pysqlite_Connection* connection)
  26. {
  27. int rc;
  28. if (statement == NULL) {
  29. /* this is a workaround for SQLite 3.5 and later. it now apparently
  30. * returns NULL for "no-operation" statements */
  31. rc = SQLITE_OK;
  32. } else {
  33. Py_BEGIN_ALLOW_THREADS
  34. rc = sqlite3_step(statement);
  35. Py_END_ALLOW_THREADS
  36. }
  37. return rc;
  38. }
  39. /**
  40. * Checks the SQLite error code and sets the appropriate DB-API exception.
  41. * Returns the error code (0 means no error occurred).
  42. */
  43. int _pysqlite_seterror(sqlite3* db, sqlite3_stmt* st)
  44. {
  45. int errorcode;
  46. /* SQLite often doesn't report anything useful, unless you reset the statement first */
  47. if (st != NULL) {
  48. (void)sqlite3_reset(st);
  49. }
  50. errorcode = sqlite3_errcode(db);
  51. switch (errorcode)
  52. {
  53. case SQLITE_OK:
  54. PyErr_Clear();
  55. break;
  56. case SQLITE_INTERNAL:
  57. case SQLITE_NOTFOUND:
  58. PyErr_SetString(pysqlite_InternalError, sqlite3_errmsg(db));
  59. break;
  60. case SQLITE_NOMEM:
  61. (void)PyErr_NoMemory();
  62. break;
  63. case SQLITE_ERROR:
  64. case SQLITE_PERM:
  65. case SQLITE_ABORT:
  66. case SQLITE_BUSY:
  67. case SQLITE_LOCKED:
  68. case SQLITE_READONLY:
  69. case SQLITE_INTERRUPT:
  70. case SQLITE_IOERR:
  71. case SQLITE_FULL:
  72. case SQLITE_CANTOPEN:
  73. case SQLITE_PROTOCOL:
  74. case SQLITE_EMPTY:
  75. case SQLITE_SCHEMA:
  76. PyErr_SetString(pysqlite_OperationalError, sqlite3_errmsg(db));
  77. break;
  78. case SQLITE_CORRUPT:
  79. PyErr_SetString(pysqlite_DatabaseError, sqlite3_errmsg(db));
  80. break;
  81. case SQLITE_TOOBIG:
  82. PyErr_SetString(pysqlite_DataError, sqlite3_errmsg(db));
  83. break;
  84. case SQLITE_CONSTRAINT:
  85. case SQLITE_MISMATCH:
  86. PyErr_SetString(pysqlite_IntegrityError, sqlite3_errmsg(db));
  87. break;
  88. case SQLITE_MISUSE:
  89. PyErr_SetString(pysqlite_ProgrammingError, sqlite3_errmsg(db));
  90. break;
  91. default:
  92. PyErr_SetString(pysqlite_DatabaseError, sqlite3_errmsg(db));
  93. break;
  94. }
  95. return errorcode;
  96. }