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)