/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 vote144 views1 answer
How to change a variable in c using scanf
C
0 vote133 views1 answer
Counting Sort C
C
0 vote144 views1 answer
C question mark
C
0 vote173 views1 answer
Apt-mark remove hold
C
13 votes150 views4 answers
Remove anaconda completely ubuntu
C
1 vote152 views1 answer
Yourkill071
C
0 vote131 views1 answer
Geom boxplot remove outliers
C
2 votes137 views1 answer
How to make a printf in c
C
-1 vote137 views1 answer
Save numpy array to text file
C
2 votes161 views2 answers
C clear buffer
C