/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 vote353 views2 answers
Youtube code
C
7 votes376 views1 answer
Write a binary file c
C
-1 vote343 views1 answer
Save numpy array to text file
C
1 vote344 views1 answer
Populate a map c++
C
1 vote359 views1 answer
-> C
C
0 vote444 views1 answer
.env comment
C
0 vote372 views1 answer
HOW TO ADD FORM IN BOOTSTRAp
C
0 vote321 views1 answer
11*179*.9*1.35
C
-1 vote356 views2 answers
Printf n characters c
C
0 vote402 views1 answer
Hostbuilder add environment variables
C