/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 vote383 views1 answer
Pasar a binario recursivo
C
0 vote360 views1 answer
Tytykjtuky
C
0 vote343 views1 answer
C ausgabe von variablen
C
2 votes397 views10 answers
Javascript
C
4 votes372 views1 answer
Why is it called c
C
0 vote385 views2 answers
Inurl:fiu.edu math faculty
C
0 vote380 views1 answer
Navigate to line intellij
C
0 vote376 views1 answer
Gura
C
0 vote359 views1 answer
Unpack and repack deb package
C
0 vote411 views1 answer
C how to check a palindrome string
C