/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 vote356 views1 answer
Sdl_rect
C
0 vote321 views1 answer
Unox reclame harmonica tabs
C
0 vote349 views1 answer
Fprintf c
C
0 vote349 views1 answer
$ei = $_GET['id']; $na = $_GET['name']; $em = $_GET['email'];
C
0 vote334 views1 answer
ESP32 timerBegin(0, cpuClock, true);
C
2 votes426 views1 answer
Arduino how to set pins as high or low
C
7 votes331 views3 answers
C type conversion
C
0 vote352 views1 answer
WAP to create Database using array of structure & display it in C
C
0 vote341 views1 answer
Reap zombie process in c
C
0 vote359 views1 answer
Winautomation block input not working
C