Hi Jerry Looks to me like you will need to swap your .flush for a .commit .commit will flush for you, then actually commit the changes to the DB. :-)
Cheers Warwick > Hi, > > I have been pulling my hair the whole day today: I have a web > application that runs fine, however, during unittest I noticed that > the test (PostgreSQL) database is not updated even after I issue the > flush() and see the SQL statement, which inserts fine by itself in > psql -- > > """ > (Pdb) list > 73 user = model.User(user_name=user_name, email=email, > password=password) > 74 > 75 dbsession = DBSession() > 76 -> dbsession.add(user) > 77 try: > 78 dbsession.flush() > 79 except: > 80 raise > (Pdb) user > <myapp.models.User object at 0xa9b8c4c> > (Pdb) user.user_name, user.email, user.user_id > (u'test', u'[email protected]', u'f24a24217248480d90c1c370c103e07f') > (Pdb) n >> myapp/views/signup.py(77)signup_view() > -> try: > (Pdb) n >> myapp/views/signup.py(78)signup_view() > -> dbsession.flush() > (Pdb) n > ...INFO sqlalchemy.engine.base.Engine.0x...24ac INSERT INTO users > (user_id, user_name, email) VALUES (%(user_id)s, %(user_name)s, % > (email)s) > ...INFO sqlalchemy.engine.base.Engine.0x...24ac {'user_id': > u'f24a24217248480d90c1c370c103e07f', 'user_name': u'test', 'email': > u'[email protected]'} > """ > > I have dropped all the databases in my computer leaving only the test > db just to make absolute sure that I'm not connecting to one database > while looking into another. > > What could have gone wrong? > > Many thanks in advance! > > Jerry > > -- > 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. > -- 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.
