/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 vote119 views1 answer
What keyword covers unhandled possibilities?
C
0 vote115 views1 answer
Include ‘<stdlib.h>’ or provide a declaration of ‘exit’
C
-1 vote119 views3 answers
English to russian translation
C
0 vote111 views1 answer
Fclose C
C
0 vote59 views1 answer
Lxc Failed to load config for
C
1 vote113 views1 answer
Imprimir valor no octave
C
0 vote118 views1 answer
Transform yt video into background overlay
C
-2 votes81 views2 answers
Ascending lexicographic order
C
0 vote123 views1 answer
Finding characters in string
C
0 vote109 views1 answer
How to belu-roll peoples in c
C