/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

1 vote156 views3 answers
String array in c
C
-2 votes155 views1 answer
Copy array of integers in c
C
0 vote155 views1 answer
Cannot get / react router dom
C
0 vote173 views1 answer
How to change background color in c programming
C
2 votes156 views3 answers
Bitwise operators
C
0 vote160 views1 answer
Algorithm that flips sentences and numbers
C
0 vote162 views1 answer
How to run c program from visual studio terminal
C
6 votes141 views1 answer
What is strikethrough in markdown
C
0 vote144 views1 answer
Postgres login mac
C
1 vote159 views1 answer
How to print the address of a pointer in c
C