/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

4 votes86 views1 answer
Pika network ip
C
0 vote138 views1 answer
What is i686 vs x86_64
C
4 votes132 views2 answers
C get time
C
0 vote125 views1 answer
How can i learn c game development
C
0 vote149 views1 answer
Int main() { int sum =0; FILE * ptr; ptr = fopen("d:\\students. "," "); if (ptr ==NULL){ ("file does not exist!!"); exit(0); }
C
12 votes179 views2 answers
Owasp
C
0 vote177 views1 answer
Multiplicationin c
C
18 votes138 views9 answers
While loop
C
4 votes85 views1 answer
Rxjs npm
C
1 vote137 views1 answer
C iterate string
C