Dynamic Class Creation in SQLAlchemy

by

You can dynamically create MyObject using the 3-argument call to type:

type(name, bases, dict)

    Return a new type object. This is essentially a dynamic form of the 
    class statement...

For example:

mydict={'__tablename__':stored['tablename'],
        '__table_args__':{'autoload':True},}

MyObj=type(stored['objectname'],(Base,),mydict)
print(MyObj)
# <class '__main__.MyObject'>
print(MyObj.__base__)
# <class '__main__.Base'>
print(MyObj.__tablename__)
# my_internal_table_name
print(MyObj.__table_args__)
# {'autoload': True}

More Related Contents:

  1. Creating a singleton in Python
  2. Sqlite / SQLAlchemy: how to enforce Foreign Keys?
  3. SQLAlchemy IN clause
  4. Python dictionary from an object’s fields
  5. Flask SQLAlchemy query, specify column names
  6. Executing multiple statements with Postgresql via SQLAlchemy does not persist changes
  7. How can I bind a list to a parameter in a custom query in SQLAlchemy?
  8. When should I subclass EnumMeta instead of Enum?
  9. How to disable SQLAlchemy caching?
  10. sqlalchemy unique across multiple columns
  11. How to create a new database using SQLAlchemy?
  12. Resolving metaclass conflicts
  13. Multi-threaded use of SQLAlchemy
  14. How to get column names from SQLAlchemy result (declarative syntax)
  15. How to discover table properties from SQLAlchemy mapped object
  16. sqlalchemy.exc.NoSuchModuleError: Can’t load plugin: sqlalchemy.dialects:postgres
  17. SQLAlchemy equivalent to SQL “LIKE” statement
  18. How do I connect to SQL Server via sqlalchemy using Windows Authentication?
  19. How to get rows which match a list of 3-tuples conditions with SQLAlchemy
  20. Best way to do enum in Sqlalchemy?
  21. Getting first row from sqlalchemy
  22. How do I INSERT INTO t1 (SELECT * FROM t2) in SQLAlchemy?
  23. Creating partial unique index with sqlalchemy on Postgres
  24. SQLAlchemy Joinedload filter column
  25. SQLAlchemy func.count on boolean column
  26. How to auto register a class when it’s defined
  27. SQLAlchemy: get Model from table name. This may imply appending some function to a metaclass constructor as far as I can see
  28. pandas to_sql all columns as nvarchar
  29. How to make mysql connection that requires CA-CERT with sqlalchemy or SQLObject
  30. add column to SQLAlchemy Table

Leave a Comment