/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

-1 vote163 views1 answer
Passing the length of an int array c
C
0 vote161 views1 answer
Binary sorting
C
0 vote192 views1 answer
Apt-mark remove hold
C
0 vote152 views1 answer
Fread condition
C
14 votes192 views3 answers
Quadratic formula
C
0 vote157 views1 answer
Yt-project annotate_scale
C
2 votes110 views2 answers
Swap variables in c
C
0 vote203 views1 answer
Check dns server in linux
C
0 vote236 views1 answer
Pre and post increment in c
C
0 vote194 views1 answer
Lazer codechef
C