python - SQLAlchemy: 'Table' object has no attribute 'id'

Question

I'm a new learner on Python and SQLAlchemy, and I met a curious problem as below.

user = Table('users', meta, autoload=True, autoload_with=engine)

then I

print(user.columns)

it works fine, the output are user.ID, user.Name, etc. But then:

Session = sessionmaker(bind=engine)
session = Session()

session.query(user).order_by(user.id)

shows error:

AttributeError: 'Table' object has no attribute 'id'

I change the "id" to "Name", it's the same error. I also tried the filter_by method, the same error.

Why this happened?

Answer 1

You could use:

session.query(user).order_by(user.c.id)