Changeset 692 for trunk/docs


Ignore:
Timestamp:
Jan 3, 2016, 9:11:21 AM (4 years ago)
Author:
cito
Message:

Implement the callproc() cursor method

The implementation has been a bit simplified in that output and
input/output parameters are not changed in the return value, i.e.
they can only be retrieved using the fetch methods. To implement
this, it would be necessary to determine (through a query to the
database catalog) which parameters are output parameters and
fetch the return values for these, which would be very costly.

Location:
trunk/docs
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • trunk/docs/changelog.rst

    r683 r692  
    55-----------
    66- This version runs on both Python 2 and Python 3.
    7 - The supported versions are Python 2.6, 2.7, 3.3, 3.4 and 3.5.
    8 - The supported PostgreSQL versions are 9.0, 9.1, 9.2, 9.3 and 9.4.
     7- The supported versions are Python 2.6 to 2.7, and 3.3 to 3.5.
     8- PostgreSQL is supported in all versions from 9.0 to 9.4.
    99- The DB-API 2 module now always returns result rows as named tuples
    1010  instead of simply lists as before. The documentation explains how
     
    1515  Since the API provides objects of these types only by the use of
    1616  constructor functions, this should not cause any incompatibilities.
     17- The DB-API 2 module now supports the callproc() cursor method. Note
     18  that output parameters are currently not replaced in the return value.
     19- The 7-tuples returned by the description attribute of a pgdb cursor
     20  are now named tuples, i.e. their elements can be also accessed by name.
    1721- The tty parameter and attribute of database connections has been
    1822  removed since it is not supported any more since PostgreSQL 7.4.
    19 - The 7-tuples returned by the description attribute of a pgdb cursor
    20   are now named tuples, i.e. their elements can be also accessed by name.
    2123
    2224Version 4.2
    2325-----------
    2426- Set a better default for the user option "escaping-funcs".
     27- The supported Python versions are 2.4 to 2.7.
     28- PostgreSQL is supported in all versions from 8.3 to 9.4.
    2529- Force build to compile with no errors.
    2630- Fix decimal point handling.
  • trunk/docs/pgdb.rst

    r684 r692  
    326326e.g. ``" ... WHERE name=%(name)s"``.
    327327
     328callproc -- Call a stored procedure
     329-----------------------------------
     330
     331.. method:: Cursor.callproc(self, procname, [parameters]):
     332
     333    Call a stored database procedure with the given name
     334
     335    :param str procname: the name of the database function
     336    :param parameters: a sequence of parameters (can be empty or omitted)
     337
     338This method calls a stored procedure (function) in the PostgreSQL database.
     339
     340The sequence of parameters must contain one entry for each input argument
     341that the function expects. The result of the call is the same as this input
     342sequence; replacement of output and input/output parameters in the return
     343value is currently not supported.
     344
     345The function may also provide a result set as output. These can be requested
     346through the standard fetch methods of the cursor.
     347
    328348fetchone -- fetch next row of the query result
    329349----------------------------------------------
Note: See TracChangeset for help on using the changeset viewer.