add the autocommit=True flag to your text() construct, or use an
explcit begin()/commit() call with the connection.
On Feb 19, 2009, at 3:28 PM, jack2318 wrote:
>
> Hi,
> I am running following test:
>
> conn = engine.connect()
> conn.execute(text("CALL SP_SA_TEST(4)"))
> conn.close()
>
> engine echo:
>
> 2009-02-19 12:17:29,069 INFO sqlalchemy.engine.base.Engine.0x...8310
> CALL SP_SA_TEST(4)
> 2009-02-19 12:17:29,069 INFO sqlalchemy.engine.base.Engine.0x...8310
> []
>
>
> inside SP_SA_TEST I have:
>
> INSERT INTO DEBUG (`FROM`, `COMMENT`, `VALUE`) VALUES ('SP_SA_TEST',
> 'FIRST', A);
>
>
> and this insert is always ROLLBACKED and never COMMITED - I check
> primary key in DEBUG table - the primary key is increased but then the
> record is gone.
>
> When I execute this same procedure from mysql directly everything
> works fine.
>
> I'm doing something wrong?
>
> regards
> -- jacek
>
>
>
>
>
>
>
> >
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
