tests: create fixtures once per TestCase class

Make use of DB transactional capabilities to protect individual tests
from each other.