Re: [sqlalchemy] Using `INSERT...ON CONFLICT` with ORM

Michael, Thanks for the quick response. In this example, `bar` is *not* the primary key, so I guess using the ORM here would be out of the question. What's your recommendation for refreshing the `foo` object after executing the `session.execute(do_update_stmt)` statement? Should I do an

Re: [sqlalchemy] ORM: Implementing abstract base class that generates auxiliary tables for each child class

On Fri, Feb 17, 2017 at 10:03 AM, wrote: > I want to achieve something like this: > > Base = declarative_base() > > # the abstract base, no table generated for it > class TreeNode(Base): > __abstract__ = True > parent = Column(ForeignKey('child_class_table.id'),

[sqlalchemy] ORM: Implementing abstract base class that generates auxiliary tables for each child class

I want to achieve something like this: Base = declarative_base() # the abstract base, no table generated for it class TreeNode(Base): __abstract__ = True parent = Column(ForeignKey('child_class_table.id'), nullable=False) def is_root(self): pass def get_parent(self): pass # more methods #