add tests for async methods; use executeUpdate instead of exeucte