/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 vote411 views1 answer
Two way communication between child and parent processes in C using pipes
C
0 vote351 views1 answer
Write a program in c to count total number of alphabets, digits and special characters in a string
C
0 vote374 views1 answer
How to switch database in mongodb
C
0 vote404 views1 answer
C read a whole string from a file
C
8 votes373 views6 answers
Error: src refspec main does not match any error: failed to push some refs to
C
0 vote437 views1 answer
Hello world in c programming languages
C
1 vote406 views1 answer
Rename c
C
1 vote430 views2 answers
Bash md5sum string
C
10 votes384 views4 answers
Install redis
C
0 vote414 views1 answer
Pandoc set margins pdf
C