/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 vote183 views1 answer
C read file into string
C
0 vote200 views2 answers
Man strstr
C
0 vote198 views1 answer
Bullseye lxc network problem
C
0 vote190 views1 answer
Get flag status c code
C
33 votes443 views2 answers
Latex font sizes
C
0 vote218 views1 answer
Maatwebsite/excel file import
C
0 vote174 views1 answer
C# special character display
C
-2 votes200 views1 answer
Jupyter notebook collapse cell
C
0 vote197 views1 answer
Logical Operator in C language
C
0 vote200 views1 answer
BuildCheckFunction(locations)
C