/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

3 votes304 views2 answers
Install tweaks ubuntu
C
0 vote311 views1 answer
Addition in c
C
0 vote307 views1 answer
Piramide
C
0 vote315 views1 answer
Best graphic video template for editing free download
C
0 vote307 views1 answer
CL/cl.h: No such file or directory
C
0 vote326 views1 answer
Read a document from console in c
C
0 vote316 views1 answer
C copy 2 strings\
C
0 vote314 views2 answers
Use frama c online
C
266 votes390 views5 answers
Font-awesome - cdnjs.com - The best FOSS CDN for web
C
0 vote319 views1 answer
C programming programiz
C