Hi,
trying to use Inspector.get_table_names with order_by='foreign_key'
causes the following exception:
Traceback (most recent call last):
File "db_inspector.py", line 20, in <module>
for table in insp.get_table_names(schema=schema,
order_by='foreign_key'):
File "lib/python2.6/site-packages/sqlalchemy/engine/reflection.py",
line 173, in get_table_names
ordered_tnames.index(ref_pos, tname)
TypeError: slice indices must be integers or None or have an __index__
method
which can be remdied by the following patch:
(gulpenv)$ diff -crB lib/python2.6/site-packages/sqlalchemy/engine/
reflection.py lib/python2.6/site-packages/sqlalchemy/engine/
reflection.py.orig*** lib/python2.6/site-packages/sqlalchemy/engine/
reflection.py 2011-12-01 08:15:01.600838080 +0100
--- lib/python2.6/site-packages/sqlalchemy/engine/reflection.py.orig
2011-12-01 08:14:40.980828074 +0100
***************
*** 169,175 ****
if table_pos > ref_pos:
ordered_tnames.pop(table_pos) # rtable
moves up 1
# insert just below rtable
! ordered_tnames.insert(ref_pos, tname)
tnames = ordered_tnames
return tnames
--- 169,175 ----
if table_pos > ref_pos:
ordered_tnames.pop(table_pos) # rtable
moves up 1
# insert just below rtable
! ordered_tnames.index(ref_pos, tname)
tnames = ordered_tnames
return tnames
best regards
robert
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
