/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 vote180 views1 answer
Try and catch in rust
C
5 votes264 views2 answers
Malloc int array c
C
0 vote211 views1 answer
C/c drop mime
C
3 votes405 views1 answer
Initialize array in c with 0
C
0 vote198 views1 answer
#![feature]` may not be used on the // stable release channel
C
2 votes190 views1 answer
Printf signed char
C
0 vote183 views1 answer
C Program to Check Whether Character is Lowercase or Not using islower function
C
0 vote169 views1 answer
Insert image material ui
C
0 vote166 views1 answer
Buble sort in c that ask user input
C
0 vote192 views3 answers
Chevront de vlavier
C