/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 vote109 views1 answer
How much larger integer i can input in c language?
C
0 vote161 views1 answer
Unable to locate package dos2unix
C
0 vote195 views1 answer
Bootstrap textarea from
C
2 votes168 views2 answers
Increment and decrement operator
C
1 vote142 views1 answer
Stdio
C
0 vote171 views1 answer
Mettre int dans string c %
C
1 vote156 views1 answer
C get file size
C
0 vote163 views1 answer
How to allocate memory for pointer in c
C
3 votes160 views3 answers
Get the latest field in mongodb collection
C
0 vote149 views10 answers
Convert python code to c online
C