/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

2 votes204 views10 answers
Javascript
C
0 vote203 views1 answer
C ausgabe von variablen
C
0 vote209 views1 answer
D3 box shadow
C
0 vote205 views1 answer
C copy 2 strings\
C
1 vote220 views1 answer
Error: dereferencing pointer to incomplete type
C
0 vote208 views2 answers
Variables in c
C
1 vote192 views1 answer
Imprimir valor no octave
C
2 votes176 views1 answer
Terminal count files in directory
C
0 vote177 views1 answer
C fscanf ignore commas
C
0 vote211 views1 answer
Solidity signature r s v
C