Changeset 3782:a748aa7f68e7 in livinglogic.python.xist

Show
Ignore:
Timestamp:
05/13/09 21:28:42 (10 years ago)
Author:
Walter Doerwald <walter@…>
Branch:
default
Message:

Sort objects.

Files:
1 modified

Legend:

Unmodified
Added
Removed
  • src/ll/orasql/__init__.py

    r3770 r3782  
    10881088        cursor = connection.cursor() 
    10891089        if schema=="all": 
    1090             cursor.execute("select decode(owner, user, null, owner) as owner, object_name from all_objects where lower(object_type) = :type", type=cls.type) 
    1091         else: 
    1092             cursor.execute("select null as owner, object_name from user_objects where lower(object_type) = :type", type=cls.type) 
     1090            cursor.execute("select decode(owner, user, null, owner) as owner, object_name from all_objects where lower(object_type) = :type order by owner, object_name", type=cls.type) 
     1091        else: 
     1092            cursor.execute("select null as owner, object_name from user_objects where lower(object_type) = :type order by object_name", type=cls.type) 
    10931093        return ((row.object_name, row.owner) for row in cursor) 
    10941094 
     
    13101310        cursor = connection.cursor() 
    13111311        if schema == "all": 
    1312             cursor.execute("select decode(owner, user, null, owner) as owner, table_name from all_tables") 
    1313         else: 
    1314             cursor.execute("select null as owner, table_name from user_tables") 
     1312            cursor.execute("select decode(owner, user, null, owner) as owner, table_name from all_tables order by owner, table_name") 
     1313        else: 
     1314            cursor.execute("select null as owner, table_name from user_tables order by table_name") 
    13151315        return ((row.table_name, row.owner) for row in cursor) 
    13161316