/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 vote206 views1 answer
Jock cranley
C
21 votes198 views3 answers
Random number c
C
0 vote169 views1 answer
How to belu-roll peoples in c
C
0 vote167 views1 answer
C getc
C
11 votes218 views4 answers
Resource controller laravel
C
0 vote170 views1 answer
How to zoom in terminal
C
0 vote184 views1 answer
What's the difference between "call" and "invoke"?
C
-1 vote182 views4 answers
Convert c++ to c online
C
12 votes201 views10 answers
Google
C
0 vote169 views1 answer
Under
C