v1.0.4
 |
py-postgresql
connect to PostgreSQL with Python 3
|
 |
py-postgresql provides a driver, cluster management tools, and client development tools.
|
sample features
|
   |
Connect
PG-API:
>>> import postgresql >>> db = postgresql.open(user = 'usename', database = 'datname', port = 5432)Or, if DB-API 2.0 is the target:
>>> import postgresql.driver.dbapi20 as dbapi >>> db = dbapi.connect(user = 'usename', database = 'datname', port = 5432, password = 'secret')The Driver documentation has more information on acceptable keyword arguments.
COPY
COPY "FROM STDIN" and "TO STDOUT" is directly supported using the chunking
interfaces. This is allows for connection-to-connection copies:
>>> send = src.prepare("COPY a_table TO STDOUT")
>>> recv = dst.prepare("COPY a_table FROM STDIN")
>>> recv.load_chunks(send.chunks())
Syntax Errors
py-postgresql's driver provides additional "element tracebacks" along with
the printed exception. This gives significant contextual information that
may help reduce debugging time:
>>> prepare('select 1\nfrom 1d')
Traceback (most recent call last):
File "<console>", line 1, in <module>
File "postgresql/driver/pq3.py", line 1718, in prepare
ps._fini()
File "postgresql/driver/pq3.py", line 857, in _fini
self.database._pq_complete()
File "postgresql/driver/pq3.py", line 1973, in _pq_complete
self._raise_pq_error(x)
File "postgresql/driver/pq3.py", line 1999, in _raise_pq_error
raise err
postgresql.exceptions.SyntaxError: syntax error at or near "1"
CODE: 42601
LOCATION: File 'scan.l', line 807, in base_yyerror from SERVER
POSITION: 15
STATEMENT: [parsing]
LINE:
from 1d
^ [line 2, character 6]
statement_id: py:0x10fbc08
string:
select 1
from 1d
CONNECTION: [idle]
client_address: ::1
client_port: 52915
version:
PostgreSQL 8.3.6 on i386-apple-darwin, compiled by GCC i686-apple-darwin8-gcc-4.0.1 (GCC) 4.0.1 (Apple Computer, Inc. build 5370)
CONNECTOR: [Host] pq://jwp:***@localhost:5432
category: None
DRIVER: postgresql.driver.pq3.Driver
Composites
Composites are supported:
>>> db.execute('CREATE TYPE ctyp AS (i int, t text, ts timestamp);')
>>> r = db.prepare("select (901, 'string', now())::ctyp").first()
>>> str(r)
"(901, 'string', datetime.datetime(2009, 5, 12, 20, 23, 30, 351411))"
>>> r[0]
901
>>> r['i']
901
>>> r['ts']
datetime.datetime(2009, 5, 12, 20, 23, 30, 351411)
Credits
Copy of the latest authors file:
Contributors: James William Pye [faults are mostly mine] <[email protected]> Elvis Pranskevichus William Grzybowski [subjective paramstyle] Barry Grussling [inet/cidr support] Matthew Grant [inet/cidr support] Support by Donation: AppCove Network Further Credits =============== When licenses match, people win. Code is occasionally imported from other projects to enhance py-postgresql and to allow users to enjoy dependency free installation. DB-API 2.0 Test Case -------------------- postgresql/test/test_dbapi20.py: Stuart Bishop <[email protected]> fcrypt ------ postgresql/resolved/crypt.py: Carey Evans <[email protected]>