/C/Using PostgreSQL array to store many-to-many relationship using sqlalchemy

Using PostgreSQL array to store many-to-many relationship using sqlalchemy

class A(Base):
    __tablename__ = "table_a"
    id = Column(Integer, primary_key=True)
    name = Column(String)

class B(Base):
    __tablename__ = "table_b"
    id = Column(Integer, primary_key=True)
    name = Column(String)
    array_a = Column(postgresql.ARRAY(Integer))

    a_ids= relationship('A',primaryjoin='A.id == any_(foreign(B.array_a))',uselist=True)

Source: stackoverflow.com

Similar codes

0 vote318 views1 answer
Print command for rust unit-test
C
1 vote325 views1 answer
C bit access union
C
0 vote321 views1 answer
Too many arg
C
33 votes436 views10 answers
Chat
C
1 vote341 views1 answer
Windeployqt example
C
0 vote353 views1 answer
Eeprom read arduinojson object
C
1 vote332 views1 answer
Install gitk mac
C
0 vote341 views1 answer
Two way communication between child and parent processes in C using pipes
C
0 vote328 views1 answer
Addition in c
C
0 vote314 views1 answer
How to declare 3dimensional arrays in wiring
C