/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 votes124 views1 answer
Size string C
C
2 votes126 views1 answer
Run a command in cmd with c
C
1 vote138 views1 answer
Material-ui Roboto font
C
0 vote125 views2 answers
Set all pins as input for loop
C
0 vote129 views1 answer
Character stuffing program in c leadcode
C
7 votes128 views3 answers
Int to double c
C
0 vote143 views1 answer
Ubuntu ocaml install
C
4 votes67 views1 answer
Pika network ip
C
2 votes193 views1 answer
Mirzapur 2
C
0 vote131 views1 answer
UTC offset upper limit
C