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.
