Refactor tests to use pytest.

To run tests simply use `py.test`. To run db specfic tests run:
`YOSHIMI_TEST_DB='<dsn>' py.test -m all_databases`.
Flake8 fixes.
Updated setup.py test command.