On Mon, Mar 4, 2019 at 12:40 AM Tolstov Sergey <whistler...@gmail.com> wrote: > > 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' > from <Mapper at 0x7f910d43c2b0; TempCreatedTestParent> to <Mapper at > 0x7f910d83f860; TestParentClass>: Check for duplicate use of > 'testparentclass' as value for polymorphic_identity. > > Can i clear cached inherit?
metadata.create_all / drop_all aren't related to the state of your mappers, these two methods can be called freely with no need to call metadata.clear(). You likely should not be using metadata.clear(). If OTOH you are actually changing the structure of declarative classes per test such that something is being removed from a mapping, you would need to use clear_mappers() and redefine all classes and mappings from scratch, using a new Base. You can't remove elements from mappings, such as here where you'd want to remove a polymorphic subclass and replace it with a new one. If you are using classical mappings or hybrid delcarative mappings with __table__, there might be some more options here but it's usually best to keep class hierarchies that are local to tests fully within the setup/teardown of those tests. > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at https://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.