# HG changeset patch
# User Catherine Devlin <catherine.devlin@gmail.com>
# Date 1288201848 14400
# Node ID fc0a6c58b7a79fc7540fc7b7513b51bd601dbe12
# Parent  128aa57c4b8d05bac0876bafeafad82f0d3e870d
all_object_qry works in mysql

diff -r 128aa57c4b8d -r fc0a6c58b7a7 sqlpython/connections.py
--- 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)