cant map to selectable in 0.4

no clue how this isnt being found in the unit tests:

from sqlalchemy  import *
from sqlalchemy.orm  import *

metadata = MetaData('sqlite:///')
metadata.bind.echo = True

common_table = Table('common', metadata,
    Column('id', Integer, primary_key=True),
    Column('data', Integer),
    Column('extra', String(45)),
)


class Subset(object):
    pass

subset_select = select([common_table.c.data](common_table.c.id,)).alias('subset')
subset_mapper = mapper(Subset, subset_select)

metadata.create_all()

#common_table.insert().execute(subset_no=1)
#subset_select.insert().execute(subset_no=1)
#print [for e in subset_select.execute().fetchall()](dict(e))

sess = create_session()
l = Subset()
l.data = 1
sess.save(l)
sess.flush()
sess.clear()

print sess.query(Subset).list()

TableFinder is not finding the table in the select !

add to mapper compile_tables():

    if not len(self.tables):
        raise exceptions.InvalidRequestError("Could not find any Table objects in mapped table '%s'" % str(self.mapped_table))

add unit tests
fix TableFinder

Comments (2)