/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

2 votes229 views1 answer
Arduino digital input pins
C
1 vote218 views1 answer
C null define
C
0 vote245 views1 answer
Toggling setting clearing checking changing a bit in c
C
0 vote249 views1 answer
Futter Square Button
C
0 vote241 views1 answer
C execute shell command
C
0 vote236 views1 answer
Jframe mittig positionieren
C
0 vote239 views1 answer
California
C
0 vote228 views1 answer
C change value of const
C
8 votes217 views6 answers
Error: src refspec main does not match any error: failed to push some refs to
C
15 votes276 views2 answers
Boolean in c
C