/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 vote195 views1 answer
CL/cl.h: No such file or directory
C
0 vote211 views1 answer
What happens if i acess a freed variable in c
C
0 vote194 views1 answer
Powershell some fonts like #include are dissapearing
C
0 vote208 views1 answer
How to open form in vb.net
C
0 vote254 views1 answer
C how to check a palindrome string
C
0 vote205 views1 answer
Atomic variable c
C
2 votes349 views7 answers
Linked list
C
2 votes211 views1 answer
Array value from user c
C
0 vote213 views1 answer
C for schleife
C
0 vote234 views1 answer
Bubble sort string c
C