/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 vote283 views1 answer
C 2d array dimensions
C
1 vote264 views1 answer
Slug urls django
C
8 votes285 views2 answers
Arduino for loop
C
0 vote272 views1 answer
Terraform fargate cpu
C
1 vote277 views1 answer
Access denied creating xampp-control.ini
C
1 vote253 views1 answer
Thread in c
C
4 votes268 views4 answers
Bootstrap 4 forms
C
0 vote266 views1 answer
ESP32 timerBegin(0, cpuClock, true);
C
8 votes269 views1 answer
Arduino millis
C
12 votes278 views5 answers
C char to int
C