cleaned up tests

- added select query fixture
cleaned up static interface