Mercurial > sqlpython

changeset 498:fc0a6c58b7a7

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
all_object_qry works in mysql
author Catherine Devlin <catherine.devlin@gmail.com>
date Wed, 27 Oct 2010 13:50:48 -0400
parents 128aa57c4b8d
children eb7758a8b53a
files sqlpython/connections.py
diffstat 1 files changed, 4 insertions(+), 4 deletions(-) [+]
line wrap: on
line diff
--- a/sqlpython/connections.py	Wed Oct 27 10:04:31 2010 -0400
+++ b/sqlpython/connections.py	Wed Oct 27 13:50:48 2010 -0400
@@ -390,10 +390,10 @@
                                   dsn = self.dsn, mode = self.mode)    
     all_object_qry = """SELECT owner, object_type, object_name 
                         FROM   all_objects 
-                        WHERE  owner %s
-                        AND    object_type %s
-                        AND    object_name %s
-                        ORDER BY owner, object_type, object_name %s"""
+                        WHERE  owner %(owner_op)s %(owner)S
+                        AND    object_type %(type_op)s %(type)S
+                        AND    object_name %(name_op)s %(name)S
+                        ORDER BY owner, object_type, object_name %(sort_direction)s"""
     column_qry = """SELECT atc.owner, ao.object_type, atc.table_name, atc.column_name      
                     FROM   all_tab_columns atc
                     JOIN   all_objects ao ON (atc.table_name = ao.object_name AND atc.owner = ao.owner)