/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

2 votes253 views1 answer
“ln: failed to create symbolic link '/etc/alternatives/java': File exists”
C
0 vote240 views1 answer
Relational Operator in C language
C
1 vote232 views1 answer
If statement that tests if a value is in range
C
0 vote243 views1 answer
How i send custom data in model field rest_framework serializer
C
7 votes270 views1 answer
Write a program to find reverse of given number
C
0 vote270 views2 answers
Memory layout in c
C
4 votes269 views3 answers
Multiplication table using c
C
0 vote273 views1 answer
Mc dropout pytorch
C
0 vote234 views1 answer
Asasz
C
2 votes246 views1 answer
Run program without main method using macro
C