Update of /usr/cvs/Public/pygresql/docs
In directory druid.net:/tmp/cvs-serv22969/docs
Modified Files:
changelog.txt future.txt pg.txt
Log Message:
The pg module no provides a way to find the number of affected rows for DML
statements.
To see the diffs for this commit:
http://www.druid.net/pygresql/viewcvs.cgi/cvs/pygresql/docs/changelog.txt.diff?r1=1.26&r2=1.27
Index: changelog.txt
===================================================================
RCS file: /usr/cvs/Public/pygresql/docs/changelog.txt,v
retrieving revision 1.26
retrieving revision 1.27
diff -u -r1.26 -r1.27
--- changelog.txt 21 Nov 2008 21:30:58 -0000 1.26
+++ changelog.txt 21 Nov 2008 23:24:38 -0000 1.27
@@ -23,6 +23,12 @@
- Support for PQescapeStringConn() and PQescapeByteaConn();
these are now also used by the internal _quote() functions.
- Added 'int8' to INTEGER types. New SMALLINT type.
+- Added a way to find the number of rows affected by a query()
+ with the classic pg module by returning it as a string.
+ For single inserts, query() still returns the oid as an integer.
+ The pgdb module already provides the "rownum" cursor attribute
+ for the same purpose.
+
Version 3.8.1 (2006-06-05)
--------------------------
http://www.druid.net/pygresql/viewcvs.cgi/cvs/pygresql/docs/future.txt.diff?r1=1.18&r2=1.19
Index: future.txt
===================================================================
RCS file: /usr/cvs/Public/pygresql/docs/future.txt,v
retrieving revision 1.18
retrieving revision 1.19
diff -u -r1.18 -r1.19
--- future.txt 21 Nov 2008 21:30:58 -0000 1.18
+++ future.txt 21 Nov 2008 23:24:38 -0000 1.19
@@ -13,7 +13,6 @@
(see http://mailman.vex.net/pipermail/pygresql/2006-May/001688.html).
- Documentation for the pgdb module (everything specific to PyGreSQL).
- The large object and direct access functions need much more attention.
-- An update query should return the number of rows affected.
- The C module needs to be cleaned up and redundant code merged,
and should get its own unit test module.
- The fetch method should use real cursors.
http://www.druid.net/pygresql/viewcvs.cgi/cvs/pygresql/docs/pg.txt.diff?r1=1.14&r2=1.15
Index: pg.txt
===================================================================
RCS file: /usr/cvs/Public/pygresql/docs/pg.txt,v
retrieving revision 1.14
retrieving revision 1.15
diff -u -r1.14 -r1.15
--- pg.txt 21 Nov 2008 19:25:27 -0000 1.14
+++ pg.txt 21 Nov 2008 23:24:38 -0000 1.15
@@ -438,12 +438,15 @@
:pg.InternalError': error during query processing
Description:
- This method simply sends a SQL query to the database. If the query is
- an insert statement, the return value is the OID of the newly
- inserted row. If it is otherwise a query that does not return a result
- (i.e., is not a some kind of SELECT statement), it returns `None`.
- Otherwise, it returns a `pgqueryobject` that can be accessed via the
- `getresult()` or `dictresult()` method or simply printed.
+ This method simply sends a SQL query to the database. If the query is an
+ insert statement that inserted exactly one row into a table that has OIDs,
the
+ return value is the OID of the newly inserted row. If the query is an update
+ or delete statement, or an insert statement that did not insert exactly one
+ row in a table with OIDs, then the numer of rows affected is returned as a
+ string. If it is a select statement that returns a result, this method
returns
+ a `pgqueryobject` that can be accessed via the `getresult()` or
`dictresult()`
+ method or simply printed. Otherwise, it returns `None`.
+
reset - resets the connection
-----------------------------
_______________________________________________
PyGreSQL mailing list
[email protected]
http://mailman.vex.net/mailman/listinfo/pygresql
