Hi,

I'm having a problem where the result of 2 programs with the same code
is different.

Program A :
--------------------

from sqlalchemy import *

db = create_engine('sqlite:///test18.db')

db.echo = False

metadata = BoundMetaData(db)

users = Table('users', metadata,
    Column('user_id', Integer, primary_key=True),
    Column('name', String(40)),
    Column('age', Integer),
    Column('password', String),
)
users.create()

users = Table('users', metadata, autoload=True)

class User(object):
    pass

usermapper = mapper(User, users)

session = create_session()

user1 = User()
user1.name = 'TOTO'
user1.age = 19

session.save(user1)
session.flush

result = users.select().execute()
row = result.fetchall()
print row

==> result [(1, u'TOTO', 19)]

Program B :
------------------

Same code with 'sqlite:///test19.db'.
==> result []

Do you have any suggestions ?

Anddi


--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to