def get_result_proxy(self):
"""
Get results from a SQL Query
:returns: the result from the query
"""
if self._callproc_result and self._out_parameters:
if SA_Version < [0, 8]:
result = base.ResultProxy(self)
else:
result = _result.ResultProxy(self)
result.out_parameters = {}
for bindparam in self.compiled.binds.values():
if bindparam.isoutparam:
name = self.compiled.bind_names[bindparam]
result.out_parameters[name] = self._callproc_result[
self.compiled.positiontup.index(name)]
return result
else:
if SA_Version < [0, 8]:
result = base.ResultProxy(self)
else:
result = _result.ResultProxy(self)
return result
def get_result_proxy(self):
if hasattr(self.compiled, 'returning_parameters'):
rrs = None
try:
try:
rrs = self.statement.__statement__.getReturnResultSet()
next(rrs)
except SQLException as sqle:
msg = '%s [SQLCode: %d]' % (sqle.getMessage(),
sqle.getErrorCode())
if sqle.getSQLState() is not None:
msg += ' [SQLState: %s]' % sqle.getSQLState()
raise zxJDBC.Error(msg)
else:
row = tuple(
self.cursor.datahandler.getPyObject(
rrs, index, dbtype) for index, dbtype in
self.compiled.returning_parameters)
return ReturningResultProxy(self, row)
finally:
if rrs is not None:
try:
rrs.close()
except SQLException:
pass
self.statement.close()
return _result.ResultProxy(self)
def get_result_proxy(self):
self._log_notices(self.cursor)
if self._is_server_side:
return _result.BufferedRowResultProxy(self)
else:
return _result.ResultProxy(self)
def get_result_proxy(self):
if self._callproc_result and self._out_parameters:
if SA_Version < [0, 8]:
result = base.ResultProxy(self)
else:
result = _result.ResultProxy(self)
result.out_parameters = {}
for bindparam in list(self.compiled.binds.values()):
if bindparam.isoutparam:
name = self.compiled.bind_names[bindparam]
result.out_parameters[name] = self._callproc_result[
self.compiled.positiontup.index(name)
]
return result
else:
if SA_Version < [0, 8]:
result = base.ResultProxy(self)
else:
result = _result.ResultProxy(self)
return result
raise zxJDBC.Error(msg)
else:
row = tuple(
self.cursor.datahandler.getPyObject(
rrs, index, dbtype) for index, dbtype in
self.compiled.returning_parameters)
return ReturningResultProxy(self, row)
finally:
if rrs is not None:
try:
rrs.close()
except SQLException:
pass
self.statement.close()
return _result.ResultProxy(self)
def create_cursor(self):
cursor = self._dbapi_connection.cursor()
cursor.datahandler = self.dialect.DataHandler(cursor.datahandler)
return cursor
class ReturningResultProxy(_result.FullyBufferedResultProxy):
"""ResultProxy backed by the RETURNING ResultSet results."""
def __init__(self, context, returning_row):
self._returning_row = returning_row
super(ReturningResultProxy, self).__init__(context)
def _cursor_description(self):
ret = []
def get_result_proxy(self):
if self._is_server_side:
return _result.BufferedRowResultProxy(self)
else:
return _result.ResultProxy(self)
