/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

8 votes442 views3 answers
Casting in c
C
0 vote334 views1 answer
Meaning of &variable c
C
0 vote349 views1 answer
C input is skipped
C
0 vote328 views1 answer
'Process: 12142 ExecStartPre=/usr/sbin/nginx -t -q -g daemon on; master_process on; (code=exited, status=1/FAILURE)'
C
18 votes357 views2 answers
C concatenate and allocate string
C
0 vote311 views1 answer
C to mips assembly converter
C
0 vote331 views1 answer
Bullseye lxc network problem
C
14 votes352 views3 answers
Quadratic formula
C
0 vote328 views1 answer
::template
C
1 vote351 views2 answers
Strstr
C