/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 vote125 views1 answer
Printf("%d", 10 ? 0 ? 5:1:1:12) what will print
C
0 vote177 views1 answer
#define f_cpu
C
0 vote79 views1 answer
What is stdin fd number
C
0 vote111 views1 answer
Include ‘<stdlib.h>’ or provide a declaration of ‘exit’
C
0 vote103 views2 answers
Memcpy in c
C
0 vote109 views1 answer
Block a website on mac
C
3 votes116 views1 answer
C printing char pointer
C
0 vote112 views1 answer
Data breach
C
1 vote114 views2 answers
How to delete pointer
C
-1 vote117 views1 answer
Passing the length of an int array c
C