/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 votes366 views1 answer
Malloc is undefined
C
1 vote393 views2 answers
Arduino wifi ip address to string
C
0 vote309 views1 answer
Fina students name by using html backend database
C
29 votes526 views6 answers
Online c compiler for graphics
C
1 vote393 views1 answer
Print float number completely in C language
C
0 vote340 views10 answers
Convert python code to c online
C
3 votes399 views2 answers
MongoDb Create
C
0 vote392 views2 answers
Memcpy c
C
0 vote376 views1 answer
Futter Square Button full
C
0 vote384 views1 answer
C copy 2 strings\
C