SQL alchemy column name with space

2019-03-06 03:53发布

问题:

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.

回答1:

@Hans, 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( 'table)name', metadata, Column('SQL Column',Integer, key='sql_column'))

  2. Define the ORM class as

    class Employee(Base): emp_name = Column("employee name", String)