Example #1
0
 def fetchall(self):
     try:
         self.rs = self.proxy.crsr_fetchall(self.id)
         if not self.rs:
             return []
         return api.SQLrows(self.rs, len(self.rs), self)
     except Exception as e:
         self._raiseCursorError(api.DatabaseError, e)
Example #2
0
 def fetchmany(self, size=None):
     try:
         self.rs = self.proxy.crsr_fetchmany(self.id, size)
         if not self.rs:
             return []
         r = api.SQLrows(self.rs, len(self.rs), self)
         return r
     except Exception as e:
         self._raiseCursorError(api.DatabaseError, e)
Example #3
0
 def fetchone(self):
     try:
         f1 = self.proxy.crsr_fetchone(self.id)
     except _BaseException as e:
         self._raiseCursorError(api.DatabaseError, e)
     else:
         if f1 is None:
             return None
         self.rs = [f1]
         return api.SQLrows(self.rs, 1, self)[0] # new object to hold the results of the fetch
Example #4
0
        if verbose > 2:
            print('%s callproc "%s" with params=%s' %
                  (version, procname, repr(parameters)))
        return self.proxy.crsr_callproc(self.id, procname, fp)

    def fetchone(self):
        try:
            f1 = self.proxy.crsr_fetchone(self.id)
        except _BaseException, e:
            self._raiseCursorError(api.DatabaseError, e)
        else:
            if f1 is None:
                return None
            self.rs = [f1]
            return api.SQLrows(
                self.rs, 1,
                self)[0]  # new object to hold the results of the fetch

    def fetchmany(self, size=None):
        try:
            self.rs = self.proxy.crsr_fetchmany(self.id, size)
            if not self.rs:
                return []
            r = api.SQLrows(self.rs, len(self.rs), self)
            return r
        except Exception, e:
            self._raiseCursorError(api.DatabaseError, e)

    def fetchall(self):
        try:
            self.rs = self.proxy.crsr_fetchall(self.id)