dabo Commit
Revision 4162
Date: 2008-06-19 08:40:14 -0700 (Thu, 19 Jun 2008)
Author: Johnf
Trac: http://svn.dabodev.com/trac/dabo/changeset/4162
Changed:
U trunk/dabo/db/dbPostgreSQL.py
Log:
removed some debug info
apparently I changed a SQL statement some time ago in some prior commit. Don't
recall why that was done.
Diff:
Modified: trunk/dabo/db/dbPostgreSQL.py
===================================================================
--- trunk/dabo/db/dbPostgreSQL.py 2008-06-19 06:40:08 UTC (rev 4161)
+++ trunk/dabo/db/dbPostgreSQL.py 2008-06-19 15:40:14 UTC (rev 4162)
@@ -62,29 +62,19 @@
if includeSystemTables:
sqltablestr = (("SELECT schemaname || '.' || tablename
AS tablename FROM pg_tables WHERE has_table_privilege('%s', schemaname || '.'
|| tablename, 'SELECT')") % self.conn_user)
else:
- sqltablestr = (("SELECT schemaname || '.' || tablename
AS tablename FROM pg_tables WHERE (schemaname not like 'pg_%s' and schemaname
not like 'information%s') and has_table_privilege('%s', schemaname || '.' ||
tablename, 'SELECT')") % ('%','%',self.conn_user))
-
+ #sqltablestr = (("SELECT schemaname || '.' || tablename
AS tablename FROM pg_tables WHERE (schemaname not like 'pg_%s' and schemaname
not like 'information%s') and has_table_privilege('%s', schemaname || '.' ||
tablename, 'SELECT')") % ('%','%',self.conn_user))
+ # jfcs 06/19/08
sqltablestr = (("""SELECT schemaname || '.' ||
tablename AS tablename
FROM pg_tables
WHERE (schemaname not like 'pg_%s'
and schemaname not like
'information%s')
and has_table_privilege('%s',
schemaname || '.' || tablename, 'SELECT')
""") % ('%','%',self.conn_user))
-# if includeSystemTables:
-# sqltablestr = ("select relname from pg_class where
relkind= 'r' ")
-# else:
-# sqltablestr = ("select relname from pg_class where
relkind= 'r' and relname not like 'pg_%' and relname not like 'sql_%' ")
-
- print
- print "sqltablestr = ", sqltablestr
- print "conn_user = ", self.conn_user
- print
cursor.execute(sqltablestr)
rs = cursor.getDataSet()
tables = []
for record in rs:
tables.append(record["tablename"])
-# tables.append(record["relname"])
return tuple(tables)
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/[EMAIL PROTECTED]
