data = [self.transform(row) for row in data]

                  # and then convert back to lists

                  data = [[row[f] for f in fields] for row in data]

          else:

              data = _multiRow(query, self.values, (self.aliases or self.columns))

              if self.transform is not None:

              aliases=['other'],

              tables=['awesome'],

              joins=['morestuff'],

              opts={

                  'order': 'other',

                  'offset': 10,

                  'limit': 3,

                  'group': 'awesome.aha'

              },

              enable_group=True

          )

                     " ORDER BY something OFFSET 10 LIMIT 3"

          self.assertEqual(actual, expected)

      @mock.patch('kojihub.context')

      def test_simple_with_execution(self, context):

          cursor = mock.MagicMock()

          context.cnx.cursor.return_value = cursor

          proc = kojihub.QueryProcessor(**self.simple_arguments)

          proc.execute()

      @mock.patch('kojihub.context')

      def test_simple_count_with_execution(self, context):

          args['opts'] = {'countOnly': True}

          proc = kojihub.QueryProcessor(**args)

          results = proc.execute()

          self.assertEqual(results, 'some count')

          cursor.reset_mock()

              '  FROM awesome\n\n\n GROUP BY id\n \n\n \n) numrows', {})

          self.assertEqual(results, 'some count')

      @mock.patch('kojihub.context')

      def test_simple_execution_with_iterate(self, context):

          cursor = mock.MagicMock()

          result = next(generator)

          self.assertEqual(result, {'something': 'value number 3'})