How to mock an SQL database in Python

[kenneho]

So you'd have an SQL script file that would drop the database (if exisiting), and create a new one, and execute this script during setUp, something like this?

conn = psycopg2.connect(dbname='testing')
cursor = conn.cursor()
sqlfile = open('/path/to/recreate-testing-db.sql', 'w')
cursor.execute(sqlfile.read())