[sqlalchemy] Savepoints not generated with MySQL?

[Jacob Gabrielson]

Hi,

I'm testing out the below script with MySQL 5.0.51a and SA 0.4.6.
Based on the documentation I expected to see a SAVEPOINT be created
(at some point) and rolled-back to but instead I get the following:

>>> satest.doit()
2008-05-14 12:42:37,813 INFO sqlalchemy.engine.threadlocal.TLEngine.
0x..cc BEGIN
2008-05-14 12:42:37,814 INFO sqlalchemy.engine.threadlocal.TLEngine.
0x..cc INSERT INTO test_table (name) VALUES (%s)
2008-05-14 12:42:37,814 INFO sqlalchemy.engine.threadlocal.TLEngine.
0x..cc ['outer']
2008-05-14 12:42:37,815 INFO sqlalchemy.engine.threadlocal.TLEngine.
0x..cc INSERT INTO test_table (name) VALUES (%s)
2008-05-14 12:42:37,815 INFO sqlalchemy.engine.threadlocal.TLEngine.
0x..cc ['inner']
2008-05-14 12:42:37,816 INFO sqlalchemy.engine.threadlocal.TLEngine.
0x..cc COMMIT

Am I doing something wrong?  I looked thru this mailing-list, bug
reports and documentation but couldn't see anything obvious.

Thanks!

-- Jacob

The script is:

from sqlalchemy import *
from sqlalchemy.orm import *

engine = create_engine('mysql://[EMAIL PROTECTED]/test', echo=True,
strategy='threadlocal')
meta = MetaData()
meta.bind = engine

test_table = Table('test_table', meta,
                   Column('test_id', Integer, primary_key=True),
                   Column('name', String(40)),
                   mysql_engine='InnoDB')

meta.create_all()

class MyTest(object):
    def __init__(self, test_name):
        self.name = test_name


mapper(MyTest, test_table)

Session = sessionmaker(transactional=False, autoflush=True,
bind=engine)

def doit():
    sess = Session(transactional=False)
    sess.begin()

    t = MyTest("outer")
    sess.save(t)
    sess.flush()

    def inner():
        sess.begin_nested()
        t2 = MyTest("inner")
        sess.save(t2)
        sess.rollback()

    inner()

    sess.commit()

if __name__ == '__main__':
    doit()

--~--~---------~--~----~------------~-------~--~----~
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 [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---