>>> from sqlalchemy import *
>>> engine = create_engine('sqlite://')
>>> metadata = MetaData()
>>> sequences = Table(
... 'sequences',metadata,
... Column('name',String(20),primary_key=True),
... Column('current',Integer(),default=0),
... )
>>> sequences.create()
>>> repr(engine.scalar(select([sequences.c.current],
sequences.c.name=='foo')))
'None'
>>> repr(engine.execute(select([sequences.c.current],
sequences.c.name=='foo')).scalar())
'None'
Why do I get None instead of an exception raised?
Also odd:
>>> engine.execute(select([sequences.c.current],
sequences.c.name=='foo')).rowcount
-1
Why is that not zero?
Chris
PS: yeah, I wish I was using a database with real sequences too ;-)
--
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.
