And, for that matter, the trouble I was having should have warned me about
my data structure - I need to use an association table, not bury data in a
JSONB column. Thanks again.
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example
It helps a great deal, thank you Simon. Thanks for taking the time to
explain it for me.
--
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
On Wed, Jun 28, 2017 at 1:35 AM, Andrew M wrote:
> I can also replicate it with JSON, with a table defined as follows:
>
> class Test(Base):
> __tablename__ = 'test'
> id = Column(INT, primary_key=True, index=True)
> json = Column(JSON, default={})
>
> And
I can also replicate it with JSON, with a table defined as follows:
class Test(Base):
__tablename__ = 'test'
id = Column(INT, primary_key=True, index=True)
json = Column(JSON, default={})
And running the following code:
p0 = Test()
p1 = Test()
session.add(p0)
session.add(p1)