/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

0 vote196 views1 answer
Bootsrap textbox
C
0 vote178 views1 answer
Convert string to int error checking c
C
1 vote185 views1 answer
Dvlprroshan
C
0 vote205 views1 answer
Hello world in c programming languages
C
0 vote193 views1 answer
Binary sorting
C
0 vote186 views1 answer
Calculate max of three numbers using ternary operator in c
C
-1 vote195 views1 answer
Save numpy array to text file
C
0 vote210 views1 answer
C program to check whether character is lowercase or not using ASCII values
C
0 vote211 views1 answer
Cast from float to long c
C
1 vote181 views3 answers
Function pointer in c
C