|
Johnny Morano
johnny.morano at vlaanderen.be
Fri Apr 19 10:39:03 EST 2002
hey all,
I'm trying to make a python script for database connection, but it doesn't
seem to work in mod_python, although it runs fine on the command line.
Can anyone see my big mistake?
--begin-code---
from mod_python import apache
import pgdb
def s(req):
nHost='localhost'
nDbname='netdoc'
readUser='nd_read'
con = pgdb.connect(dsn=nHost+':'+nDbname, user=readUser)
curs = con.cursor()
curs.execute(""" SELECT relname as tablename
, pg_get_userbyid(relowner) AS tableowner
, relhasindex as hasindexes
, relhasrules as hasrules
, reltriggers as hastriggers
, pg_class.oid
, description as table_description
, relacl
FROM pg_class
LEFT OUTER JOIN pg_description on ( pg_class.oid =
pg_description.objoid
AND
pg_description.objsubid = 0)
WHERE ( relkind = 'r'::"char"
OR relkind = 's'::"char"
)
AND relname NOT LIKE 'pg_%' """)
rows = curs.fetchall()
x = "the table names: \n"
for row in rows:
x += "\t" + row[0] + "\n"
return x
---end-code---
thanx !
--
Johnny Morano - Linux Consultant
___________________________________________________
Ministerie Vlaamse Gemeenschap |
Koning Albert II-laan, 7 (610) 1210 Brussel |
tel: 02/5531319 mail: johnny.morano at vlaanderen.be |
|