Added test methods for using MySQL adapter