SQLAlchemy column name with space

by

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)

More Related Contents:

  1. Writing a connection string when password contains special characters
  2. Does SQLAlchemy have an equivalent of Django’s get_or_create?
  3. How to write DataFrame to postgres table
  4. Speeding up pandas.DataFrame.to_sql with fast_executemany of pyODBC
  5. CS50: LIKE operator, variable substitution with % expansion
  6. Group by & count function in sqlalchemy
  7. Debugging (displaying) SQL command sent to the db by SQLAlchemy
  8. Flask-SQLalchemy update a row’s information
  9. Efficiently updating database using SQLAlchemy ORM
  10. SQLAlchemy ORDER BY DESCENDING?
  11. SQLAlchemy ON DUPLICATE KEY UPDATE
  12. stored procedures with sqlAlchemy
  13. SqlAlchemy – Filtering by Relationship Attribute
  14. How to upsert pandas DataFrame to PostgreSQL table?
  15. How can I profile a SQLAlchemy powered application?
  16. sqlalchemy: create relations but without foreign key constraint in db?
  17. sqlalchemy.exc.NoSuchModuleError: Can’t load plugin: sqlalchemy.dialects:postgres
  18. Strange SQLAlchemy error message: TypeError: ‘dict’ object does not support indexing
  19. Getting first row from sqlalchemy
  20. ImportError: No module named sqlalchemy
  21. flask-sqlalchemy or sqlalchemy
  22. python pandas to_sql with sqlalchemy : how to speed up exporting to MS SQL?
  23. SQLAlchemy Obtain Primary Key With Autoincrement Before Commit
  24. SQLAlchemy: get Model from table name. This may imply appending some function to a metaclass constructor as far as I can see
  25. SQLAlchemy – can you add custom methods to the query object?
  26. pandas to_sql all columns as nvarchar
  27. Reverse engineer SQLAlchemy declarative class definition from existing MySQL database?
  28. How to make mysql connection that requires CA-CERT with sqlalchemy or SQLObject
  29. Which SQLAlchemy column type should be used for binary data?
  30. add column to SQLAlchemy Table

Leave a Comment