python - 如何在 Python - SQL 中修复“表”对象没有属性

Question

这是我的代码的摘要：

Players = Table('Players',meta,Column('name',String),
            Column('number',Integer),
            Column('Speed(km/h)',Float))
s = select([text(Players.name,Players.number)]).where(text('Players.number<10'))
 conn = engine.connect()

它有一个错误：

----> 9 s = select([text(Players.name,Players.number)]).where(text('Players.number<10'))
AttributeError: 'Table' object has no attribute 'number'

标签： pythonsql

Answer 1

您的选择可能是

s = select([Players.c.name, Players.c.number]).where(Players.c.number < 10)