title: Database testing in python, postgresql
body: <p>How do you unit test your python DAL that is using postgresql. </p>
  
  <p>In sqlite you could create in-memory database for every test but this cannot be done for postgresql. </p>
  
  <p>I want a library that could be used to setup a database and clean it once the test is done. </p>
  
  <p>I am using Sqlalchemy as my ORM. </p>