I'm trying to write a unit test for a Zope method which uses ZPoPyDB to modify database.
I setup the database using PoPy connection. That is, I do "DELETE * FROM AGENCY" and commit.
Then I call my sctipt (which inserts into this table using ZPoPyDB), and try to see if it worked by doing "SELECT COUNT(*) FROM AGENCY" on my PoPy connection. The problem is that it selects zero even though the same sentence on psql shows that a record was inserted.
What could be wrong? Is there some way to make my PoPy connection sync with the database?
Thanks,
Albertas
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm trying to write a unit test for a Zope method which uses ZPoPyDB to modify database.
I setup the database using PoPy connection. That is, I do "DELETE * FROM AGENCY" and commit.
Then I call my sctipt (which inserts into this table using ZPoPyDB), and try to see if it worked by doing "SELECT COUNT(*) FROM AGENCY" on my PoPy connection. The problem is that it selects zero even though the same sentence on psql shows that a record was inserted.
What could be wrong? Is there some way to make my PoPy connection sync with the database?
Thanks,
Albertas