Yes. I tried adding the autocommit execution option and calling execute, as well as turning autocommit off and manually calling commit.
Like I said, the stored procedure is getting run because the primary key is incrementing internally, (that is to say, that if my last id entry was 1, I run this code, and then on the next insert the id entry is 3) and the results are getting rolled back. On Thursday, May 31, 2012 7:01:53 PM UTC-7, Michael Bayer wrote: > > did you call Session.commit() ? otherwise you're still in an open > transaction, assuming default settings. > > Session.execute() is not the same as engine.execute(), where the latter is > autocommitting (assuming you also called execution_options(autocommit=True) > for this particular text() construct). > > > > On May 31, 2012, at 9:23 PM, Will Orr wrote: > > Hello all! > > I'm having this *exact* bug from a few years ago wrt. calling stored > procedures. > https://groups.google.com/forum/?fromgroups#!topic/sqlalchemy/qA_ypVgJ1B0 > > What makes it worse, however, is that adding the autocommit execution > option or explicitly starting and stopping a transaction do nothing. > > session.execute(text('call add_logentry(:username, :hostname, :action, > \'0000-00-00 00:00:00\')'), { > 'username': username, > 'hostname': hostname, > 'action' : action > }) > > There's the code. It should insert some values into some tables, however > those values are never inserted, though the primary key counter is > incremented. > > I'm using SQLAlchemy with ZopeTransactionExtension. > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/sqlalchemy/-/si1vqn5kmjoJ. > 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 view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/5y7_u014dn8J. 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.
