/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 vote162 views1 answer
Open a file in from terminal
C
0 vote144 views1 answer
Rainmaker simple project
C
0 vote136 views1 answer
How to merge 2 bytes into an integer
C
0 vote132 views1 answer
Working outside of application context
C
7 votes85 views2 answers
Install c compiler ubuntu
C
0 vote246 views1 answer
How to link flexslider
C
0 vote137 views2 answers
Convert python to c
C
-2 votes234 views2 answers
C float to int
C
7 votes151 views1 answer
Write a program to find reverse of given number
C
10 votes149 views4 answers
Install redis
C