Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
306 views
in Technique[技术] by (71.8m points)

python - SQLAlchemy column name with space

I'm trying to filter a table on a column that contain spaces.

...
events = database_session.query(table)
events.filter(table.column with space == 'xvalue')   < -- I want to do that
...

There is for sure a simple way of doing that, but I can't seem to find it anywhere.

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

There are two ways to resolve this.

  1. When defining the table you would need to specify an alias with the key parameter
t_table_name = Table(
    'tablename',
    metadata,
    Column('SQL Column', Integer, key='sql_column')
)
  1. Define the ORM class as
class Employee(Base):
    emp_name = Column("employee name", String)

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...