Writing tests for Pyramid and SQLAlchemy

After the last project I worked on where we tested against SQLite and dropped and created our tables on every test I have been searching for a better and more efficient way to run my tests.

I feel like I found a good way to do this but would love your guys opinion.