Tests for mysql adapter

Fixed the tests for the mysql adapter. Redis also passes, but for `update` and `delete`, which are yet to be implemented.