/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 vote381 views2 answers
Stdio.h
C
1 vote378 views1 answer
Stdio
C
0 vote393 views1 answer
Android studio sdkmanager always accept
C
1 vote377 views1 answer
Matplotlib plot circle marker
C
0 vote404 views1 answer
How to input till end of line in c
C
6 votes387 views2 answers
C substring
C
0 vote420 views1 answer
Ouverture du fichier c
C
-5 votes419 views5 answers
Happy New Year!
C
1 vote380 views1 answer
Open a file in from terminal
C
3 votes366 views3 answers
Int to float c
C