/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

4 votes202 views2 answers
ImportError: No module named 'skimage'
C
0 vote299 views4 answers
Error
C
0 vote225 views1 answer
Reading string with spaces in c
C
0 vote190 views1 answer
Ecs Invalid 'cpu' setting for task
C
1 vote194 views1 answer
What is covert channel
C
0 vote226 views1 answer
4 byte alignment c code
C
0 vote193 views1 answer
Macos prevent disk mounting
C
0 vote201 views1 answer
Writing tests for API requests
C
0 vote214 views2 answers
C convert float to string
C
0 vote234 views1 answer
Code: 'EADDRINUSE', [0] errno: 'EADDRINUSE', [0] syscall: 'listen', [0] address: '::', [0] port: 5000
C