[sqlalchemy] Redefine class on runtime

2019-03-03 Thread Tolstov Sergey
Hi, for unit tests i need to create class with *Base.metadata.create_all*, and delete table defintion (for tests) On second definition i have a error (already defined) With use *Base.metadata.clear *i get *warning* SAWarning: Reassigning polymorphic association for identity 'testparentclass'

[sqlalchemy] MySQL Connector

2019-03-03 Thread Warwick Prince
Hi Community We’ve been using sqlalchemy with great success for many years. We’ve been using the mysqlconnector to connect to my MySQL databases with no issues to speak of. My issue is that I recently upgraded to the latest version of the connector from Oracle which has changed from Python

[sqlalchemy] Re: Organizing a project

2019-03-03 Thread Jonathan Vanasco
I generally write the SqlAlchemy models as a separate package, then import that into my MVC/etc patterned app. In terms of the SqlAlchemy logic, some of that I keep in the models package, others are in the core app. This allows other apps and utilities to be built off the SqlAlchemy models

[sqlalchemy] Organizing a project

2019-03-03 Thread Rich Shepard
Starting my first SA project (have one more planned after this one's working) and appreciate advice on organizing project files. I understand the MVC pattern and am trying to apply it with subdirectories of model/, view/, and controller/ yet I'm unsure where to place SQLAlchemy. This is the