/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

5 votes354 views2 answers
Input array elements in c
C
2 votes367 views1 answer
Ln: failed to create symbolic link 'protoc': File exists
C
2 votes354 views2 answers
Curl authorization header
C
0 vote340 views1 answer
C zero out array
C
0 vote337 views1 answer
Gtk widget change window title
C
0 vote410 views1 answer
Division en java
C
2 votes397 views1 answer
Powershell search files for string
C
1 vote341 views2 answers
Stack Push
C
0 vote344 views1 answer
Conditional compilation in c
C
1 vote343 views1 answer
Whoami bash file
C