/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 vote228 views1 answer
Actionbar content color in android
C
1 vote168 views1 answer
Array reference argument
C
32 votes368 views6 answers
Material ui icons
C
0 vote174 views1 answer
4k stogram chave
C
0 vote190 views3 answers
How to input n space separated integers in c
C
1 vote163 views2 answers
How to delete pointer
C
0 vote176 views1 answer
Retoure a la ligne C
C
0 vote165 views2 answers
Int to void* c
C
0 vote176 views1 answer
How to stop scanf from adding a new line in c
C
11 votes190 views5 answers
Swap without using third variable
C