we've put tickets on their tracker to this effect, that they should be more liberal about considering when "the transaction" begins.
http://code.google.com/p/pysqlite/issues/detail?id=21 pysqlite is tricky since I dont know if the Python.org tracker or the code.google.com tracker is more appropriate. In any case it doesn't seem like a lot is being done. On Feb 18, 2011, at 10:31 AM, Daniel Holth wrote: > Thanks Mike. I will have to edit the pysqlite C source code if I want to > prevent it from committing when the query does not contain any of the strings > "select", "insert", "update", "delete", or "replace". > > if (!strcmp(buf, "select")) { > return STATEMENT_SELECT; > } else if (!strcmp(buf, "insert")) { > return STATEMENT_INSERT; > } else if (!strcmp(buf, "update")) { > return STATEMENT_UPDATE; > } else if (!strcmp(buf, "delete")) { > return STATEMENT_DELETE; > } else if (!strcmp(buf, "replace")) { > return STATEMENT_REPLACE; > } else { > return STATEMENT_OTHER; > } > > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalchemy@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.