/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 vote268 views1 answer
Objects in oops
C
0 vote258 views1 answer
How to allocate memory for pointer in c
C
0 vote277 views2 answers
How to debug a segmentation fault in c
C
1 vote241 views1 answer
Imprimir valor no octave
C
0 vote253 views1 answer
How to write long int data type in c
C
1 vote269 views1 answer
And in language c
C
0 vote267 views1 answer
Data breach
C
0 vote264 views1 answer
How to turn off zsh
C
0 vote237 views1 answer
Arma 3 get group size
C
24 votes273 views6 answers
MongoDb delete
C