You may want to turn on logging to see exactly what SQL is being issued:
try adding
import logging
logging.getLogger('sqlalchemy.engine').setLevel(logging.INFO)
to the top of your test script
On 1/5/07, Paul Johnston <[EMAIL PROTECTED]> wrote:
Hi,
The following program outputs 1; I thought it should output 0. Any
comments?
from sqlalchemy import *
db = create_engine("sqlite:///:memory:")
metadata = BoundMetaData(db)
users = Table('users', metadata,
Column('user_id', Integer, primary_key=True),
Column('user_name', String))
users.create()
c1 = db.connect()
t1 = c1.begin()
c1.execute(users.insert(), user_id=1, user_name='user1')
c2 = db.connect()
t2 = c2.begin()
print len(c2.execute("select * from users").fetchall())
Regards,
Paul
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
