gistfile1.txt

INFO:sqlalchemy.engine.base.Engine:SELECT micros.v_r_guest_checks.check_number AS "micros.v_r_guest_checks__1" 
FROM micros.v_r_guest_checks 
WHERE micros.v_r_guest_checks.check_number = ?
INFO:sqlalchemy.engine.base.Engine:(7095,)

    def _fetchall_impl(self):
        try:
            return self.cursor.fetchall()
        except AttributeError:
            self._non_result()

------------- self.cursor = None

Hence:

Error
Traceback (most recent call last):
  File "/Volumes/Storage/apps/payr/pcs_client/pcs_client/pos_clients/micros3700/tests/odbc_tests.py", line 54, in test_fetching_one_ticket
    ticket = session.query(Ticket).get(7095)
  File "/Volumes/Storage/apps/payr/pcs_client/env_pcs_client/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 816, in get
    return loading.load_on_ident(self, key)
  File "/Volumes/Storage/apps/payr/pcs_client/env_pcs_client/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 226, in load_on_ident
    return q.one()
  File "/Volumes/Storage/apps/payr/pcs_client/env_pcs_client/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2306, in one
    ret = list(self)
  File "/Volumes/Storage/apps/payr/pcs_client/env_pcs_client/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 65, in instances
    fetch = cursor.fetchall()
  File "/Volumes/Storage/apps/payr/pcs_client/env_pcs_client/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 752, in fetchall
    self.cursor, self.context)
  File "/Volumes/Storage/apps/payr/pcs_client/env_pcs_client/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1027, in _handle_dbapi_exception
    util.reraise(*exc_info)
  File "/Volumes/Storage/apps/payr/pcs_client/env_pcs_client/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 746, in fetchall
    l = self.process_rows(self._fetchall_impl())
  File "/Volumes/Storage/apps/payr/pcs_client/env_pcs_client/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 715, in _fetchall_impl
    self._non_result()
  File "/Volumes/Storage/apps/payr/pcs_client/env_pcs_client/lib/python2.7/site-packages/sqlalchemy/engine/result.py", line 720, in _non_result
    "This result object does not return rows. "