/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 vote172 views1 answer
Zizag c
C
0 vote139 views1 answer
How much larger integer i can input in c language?
C
0 vote234 views2 answers
Vowel and consonant C
C
0 vote184 views1 answer
Complete the function in the editor. It has one parameter: an array, . It must iterate through the array performing one of the following actions on each element:
C
1 vote221 views2 answers
C programming language
C
0 vote190 views1 answer
Absolute value of intel intrinsic
C
0 vote185 views1 answer
Manasa loves maths solution IN C
C
2 votes184 views1 answer
%.*s in c
C
0 vote187 views1 answer
Youbook
C
0 vote172 views1 answer
Battlefield4u.com
C