add column to SQLAlchemy Table

by

I have the same problem, and a thought of using migration library only for this trivial thing makes me
tremble. Anyway, this is my attempt so far:

def add_column(engine, table_name, column):
    column_name = column.compile(dialect=engine.dialect)
    column_type = column.type.compile(engine.dialect)
    engine.execute('ALTER TABLE %s ADD COLUMN %s %s' % (table_name, column_name, column_type))

column = Column('new_column_name', String(100), primary_key=True)
add_column(engine, table_name, column)

Still, I don’t know how to insert primary_key=True into raw SQL request.

More Related Contents:

  1. How to serialize SqlAlchemy result to JSON?
  2. How do I print colored text to the terminal?
  3. SQLAlchemy: print the actual query
  4. Is there go up line character? (Opposite of \n)
  5. Add pygame module in PyCharm IDE
  6. Execute terminal command from python in new terminal window?
  7. SQLAlchemy create_all() does not create tables
  8. Python Script execute commands in Terminal [duplicate]
  9. SQL Alchemy ORM returning a single column, how to avoid common post processing
  10. How do I execute inserts and updates in an Alembic upgrade script?
  11. SQLAlchemy, get object not bound to a Session
  12. Bulk insert with SQLAlchemy ORM
  13. Flask sqlalchemy many-to-many insert data
  14. How to delete a record by id in Flask-SQLAlchemy
  15. How to do an upsert with SqlAlchemy?
  16. SQLAlchemy printing raw SQL from create()
  17. SQLAlchemy: engine, connection and session difference
  18. SQLAlchemy: how to filter date field?
  19. method of iterating over sqlalchemy model’s defined columns?
  20. flake8 complains on boolean comparison “==” in filter clause
  21. How to execute “left outer join” in SqlAlchemy
  22. SQLAlchemy – Mapping self-referential relationship as one to many (declarative form)
  23. flask-sqlalchemy or sqlalchemy
  24. python pandas to_sql with sqlalchemy : how to speed up exporting to MS SQL?
  25. SQLAlchemy Obtain Primary Key With Autoincrement Before Commit
  26. SQLAlchemy – can you add custom methods to the query object?
  27. pandas to_sql all columns as nvarchar
  28. Reverse engineer SQLAlchemy declarative class definition from existing MySQL database?
  29. Which SQLAlchemy column type should be used for binary data?
  30. Execute a command on Remote Machine in Python

Leave a Comment