The Python Oracle

sqlalchemy orm skip already-existing tables on create

--------------------------------------------------
Hire the world's top talent on demand or became one of them at Toptal: https://topt.al/25cXVn
--------------------------------------------------

Music by Eric Matyas
https://www.soundimage.org
Track title: Quiet Intelligence

--

Chapters
00:00 Sqlalchemy Orm Skip Already-Existing Tables On Create
00:30 Accepted Answer Score 4
00:46 Thank you

--

Full question
https://stackoverflow.com/questions/4485...

--

Content licensed under CC BY-SA
https://meta.stackexchange.com/help/lice...

--

Tags
#python #sqlalchemy

#avk47


ACCEPTED ANSWER

Score 4


I needed to add {'useexisting': True} (in SQLAlchemy 1.4+, use {'extend_existing': True}).

class Col1(Base):
    __tablename__ = 'col1'
    __table_args__ = {'useexisting': True}
    id = Column(Integer(), primary_key=True)
    name = Column(String())