SQLAlchemy: get Model from table name. This may imply appending some function to a metaclass constructor as far as I can see

by

Inspired by Eevee‘s comment:

def get_class_by_tablename(tablename):
  """Return class reference mapped to table.

  :param tablename: String with name of table.
  :return: Class reference or None.
  """
  for c in Base._decl_class_registry.values():
    if hasattr(c, '__tablename__') and c.__tablename__ == tablename:
      return c

More Related Contents:

  1. Sqlite / SQLAlchemy: how to enforce Foreign Keys?
  2. SqlAlchemy – Filtering by Relationship Attribute
  3. sqlalchemy: create relations but without foreign key constraint in db?
  4. What is related_name used for?
  5. SQLAlchemy IN clause
  6. Flask SQLAlchemy query, specify column names
  7. How can I bind a list to a parameter in a custom query in SQLAlchemy?
  8. How to disable SQLAlchemy caching?
  9. AttributeError: can’t set attribute when connecting to sqlite database with flask-sqlalchemy
  10. Case Insensitive Flask-SQLAlchemy Query
  11. sqlalchemy unique across multiple columns
  12. How to build a flask application around an already existing database?
  13. How to create a new database using SQLAlchemy?
  14. Bulk Insert A Pandas DataFrame Using SQLAlchemy
  15. Why is SQLAlchemy insert with sqlite 25 times slower than using sqlite3 directly?
  16. Python, SQLAlchemy pass parameters in connection.execute
  17. Multi-threaded use of SQLAlchemy
  18. How to get column names from SQLAlchemy result (declarative syntax)
  19. How to discover table properties from SQLAlchemy mapped object
  20. IntegrityError when inserting data in an association table using SQLAlchemy
  21. AttributeError: ‘int’ object has no attribute ‘_sa_instance_state’
  22. How do I connect to SQL Server via sqlalchemy using Windows Authentication?
  23. Best way to do enum in Sqlalchemy?
  24. SQLAlchemy Joinedload filter column
  25. creating a database outside the application context
  26. Using SQLAlchemy models in and out of Flask
  27. SQLAlchemy column name with space
  28. Connecting to SQL Server 2012 using sqlalchemy and pyodbc
  29. using sqlalchemy to load csv file into a database
  30. pyodbc.connect() works, but not sqlalchemy.create_engine().connect()

Leave a Comment