Update of /usr/cvs/Public/pygresql/docs
In directory druid.net:/tmp/cvs-serv18725
Modified Files:
future.txt pg.txt pgdb.txt readme.txt
Log Message:
Updated docs. "insert/update ... returning" is already supported and only
needed documentation.
To see the diffs for this commit:
http://www.druid.net/pygresql/viewcvs.cgi/cvs/pygresql/docs/future.txt.diff?r1=1.20&r2=1.21
Index: future.txt
===================================================================
RCS file: /usr/cvs/Public/pygresql/docs/future.txt,v
retrieving revision 1.20
retrieving revision 1.21
diff -u -r1.20 -r1.21
--- future.txt 21 Nov 2008 23:46:31 -0000 1.20
+++ future.txt 23 Nov 2008 11:29:48 -0000 1.21
@@ -32,19 +32,16 @@
Wish List
---------
-- Support for the new insert/update ... returning ... feature
- (see http://jakub.fedyczak.net/post/10/).
- Make SQLSTATE error codes available.
- Make use of PQexecParams() and PQprepare(). This could speed up
executemany() and allow retrieving binary data directly by setting
the resultFormat parameter to one.
+- Support .errorhandler extension.
- Connection as context manager (see http://tinyurl.com/6j9cef).
- Users should be able to register their own types with _pg.
-- I would like a new method that returns a dictionary
- of dictionaries from a SELECT.
-- Add support for persistent and pooled connections
- that can be used in multi-threaded environments
- or just add link to http://www.webwareforpython.org/DBUtils.
+- New methods in the classic module, similar to getresult() and
+ dictresult(), but returning dictionaries of rows instead of lists
+ of rows (with primary key or oids as keys).
- Make PyGreSQL thread-safe on the connection level.
- The API documentation could be created with Epydoc.
- Write a tutorial for beginners and advanced use.
http://www.druid.net/pygresql/viewcvs.cgi/cvs/pygresql/docs/pg.txt.diff?r1=1.15&r2=1.16
Index: pg.txt
===================================================================
RCS file: /usr/cvs/Public/pygresql/docs/pg.txt,v
retrieving revision 1.15
retrieving revision 1.16
diff -u -r1.15 -r1.16
--- pg.txt 21 Nov 2008 23:24:38 -0000 1.15
+++ pg.txt 23 Nov 2008 11:29:48 -0000 1.16
@@ -443,9 +443,10 @@
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`.
+ string. If it is a statement that returns rows as a result (usually a select
+ statement, but maybe also an "insert/update ... returning" statement), 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
http://www.druid.net/pygresql/viewcvs.cgi/cvs/pygresql/docs/pgdb.txt.diff?r1=1.1&r2=1.2
Index: pgdb.txt
===================================================================
RCS file: /usr/cvs/Public/pygresql/docs/pgdb.txt,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- pgdb.txt 8 Sep 2005 20:09:51 -0000 1.1
+++ pgdb.txt 23 Nov 2008 11:29:48 -0000 1.2
@@ -22,7 +22,7 @@
`DB-API 2.0 compliant interface <pgdb.html>`_
provided by the `pgdb` module.
-`DB-API 2.0 <http://www.python.org/peps/pep-0249.html>`_
+`DB-API 2.0 <http://www.python.org/dev/peps/pep-0249/>`_
(Python Database API Specification v2.0)
is a specification for connecting to databases (not only PostGreSQL)
from Python that has been developed by the Python DB-SIG in 1999.
@@ -30,9 +30,9 @@
The following documentation covers only the newer `pgdb` API.
The authoritative programming information for the DB-API is availabe at
- http://www.python.org/peps/pep-0249.html
+ http://www.python.org/dev/peps/pep-0249/
-A tutorial like introduction to the DB-API can be found at
+A tutorial-like introduction to the DB-API can be found at
http://www2.linuxjournal.com/lj-issues/issue49/2605.html
http://www.druid.net/pygresql/viewcvs.cgi/cvs/pygresql/docs/readme.txt.diff?r1=1.13&r2=1.14
Index: readme.txt
===================================================================
RCS file: /usr/cvs/Public/pygresql/docs/readme.txt,v
retrieving revision 1.13
retrieving revision 1.14
diff -u -r1.13 -r1.14
--- readme.txt 19 Nov 2008 18:41:25 -0000 1.13
+++ readme.txt 23 Nov 2008 11:29:48 -0000 1.14
@@ -184,7 +184,7 @@
provided by the `pg` module or else the newer DB-API 2.0
compliant interface provided by the `pgdb` module.
-`DB-API 2.0 <http://www.python.org/peps/pep-0249.html>`_
+`DB-API 2.0 <http://www.python.org/dev/peps/pep-0249/>`_
(Python Database API Specification v2.0)
is a specification for connecting to databases (not only PostGreSQL)
from Python that has been developed by the Python DB-SIG in 1999.
@@ -192,6 +192,10 @@
The programming information is available in the files
`pg.txt <pg.html>`_ and `pgdb.txt <pgdb.html>`_.
+Note that PyGreSQL is not thread-safe on the connection level. Therefore
+we recommend using `DBUtils <http://www.webwareforpython.org/DBUtils>`
+for multi-threaded environments, which supports both PyGreSQL interfaces.
+
ChangeLog and Future
====================
_______________________________________________
PyGreSQL mailing list
[email protected]
http://mailman.vex.net/mailman/listinfo/pygresql
