/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 vote139 views1 answer
Wpdb add temporary while drop table
C
0 vote149 views3 answers
Plt circle
C
0 vote143 views1 answer
How to do Employing defensive code in the UI to ensure that the current frame is the most top level window
C
20 votes147 views3 answers
Access the docker container files
C
0 vote151 views1 answer
How to sort an int array in c
C
0 vote130 views2 answers
Compil cywin cgi
C
0 vote171 views1 answer
Imprimir matriz
C
0 vote153 views4 answers
Convert preorder to postorder calculator
C
0 vote138 views1 answer
Printing out 2 strings in c
C
6 votes152 views3 answers
MongoDb update
C