don't fall over for dialects that have discrepancies in table cols vs. index cols reported

this is happening on oracle but we can just guard against this more fundamentally:

from sqlalchemy import create_engine, Table, MetaData, Integer
import mock

e = create_engine("sqlite://")
e.execute("""create table x (a integer, b integer)""")
e.execute("""create index x_i on x(a, b)""")

def mock_get_columns(self, connection, table_name, **kw):
    return [
        {"name": "b", "type": Integer, "primary_key": False}
    ]

with mock.patch.object(e.dialect, "get_columns", mock_get_columns):
    m = MetaData()
    t = Table('x', m, autoload_with=e)

Comments (5)