/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

-1 vote371 views1 answer
Formula to find the area of a trapezium in c
C
4 votes378 views6 answers
Javascript string
C
0 vote395 views1 answer
How to take comma separated integer input in c
C
0 vote394 views2 answers
When to add & in snacf c
C
6 votes410 views2 answers
Atoi
C
1 vote428 views1 answer
Passing a matrix in a function C
C
0 vote388 views1 answer
Addition in c
C
0 vote389 views1 answer
Algorithm that flips sentences and numbers
C
0 vote390 views1 answer
C language float user input
C
0 vote446 views1 answer
How to add a number before every line in c language
C