Changeset 368 for trunk/docs


Ignore:
Timestamp:
Nov 21, 2008, 6:24:38 PM (11 years ago)
Author:
cito
Message:

The pg module no provides a way to find the number of affected rows for DML statements.

Location:
trunk/docs
Files:
3 edited

Legend:

Unmodified
Added
Removed
  • trunk/docs/changelog.txt

    r366 r368  
    2424  these are now also used by the internal _quote() functions.
    2525- Added 'int8' to INTEGER types. New SMALLINT type.
     26- Added a way to find the number of rows affected by a query()
     27  with the classic pg module by returning it as a string.
     28  For single inserts, query() still returns the oid as an integer.
     29  The pgdb module already provides the "rownum" cursor attribute
     30  for the same purpose.
     31
    2632
    2733Version 3.8.1 (2006-06-05)
  • trunk/docs/future.txt

    r366 r368  
    1414- Documentation for the pgdb module (everything specific to PyGreSQL).
    1515- The large object and direct access functions need much more attention.
    16 - An update query should return the number of rows affected.
    1716- The C module needs to be cleaned up and redundant code merged,
    1817  and should get its own unit test module.
  • trunk/docs/pg.txt

    r364 r368  
    439439
    440440Description:
    441   This method simply sends a SQL query to the database. If the query is
    442   an insert statement, the return value is the OID of the newly
    443   inserted row. If it is otherwise a query that does not return a result
    444   (i.e., is not a some kind of SELECT statement), it returns `None`.
    445   Otherwise, it returns a `pgqueryobject` that can be accessed via the
    446   `getresult()` or `dictresult()` method or simply printed.
     441  This method simply sends a SQL query to the database. If the query is an
     442  insert statement that inserted exactly one row into a table that has OIDs, the
     443  return value is the OID of the newly inserted row. If the query is an update
     444  or delete statement, or an insert statement that did not insert exactly one
     445  row in a table with OIDs, then the numer of rows affected is returned as a
     446  string. If it is a select statement that returns a result, this method returns
     447  a `pgqueryobject` that can be accessed via the `getresult()` or `dictresult()`
     448  method or simply printed. Otherwise, it returns `None`.
     449
    447450
    448451reset - resets the connection
Note: See TracChangeset for help on using the changeset viewer.