Use more use of db in acceptance tests

Moving more of the tests to use the db methods. Should be able to then remove the test seed.sql file.