Filter records by logged in user about safrs HOT 3 CLOSED

db.session.query(TceContacts).join(TceCampaign).join(User).filter_by(client_id = token_user).all()

db.session.query(TceContacts).join(TceCampaign).join(User).filter_by(client_id = token_user).all()

class Base(SAFRSBase, db.Model):
    __abstract__ = True
    id = db.Column(Integer, nullable=False, primary_key=True)
    created_at = db.Column(db.DateTime, default=db.func.current_timestamp())
    modified_at = db.Column(db.DateTime,
                            default=db.func.current_timestamp(),
                            onupdate=db.func.current_timestamp())
    active = db.Column(db.Boolean(), default=True)


class User(Base):
    __tablename__ = 'user'

    client_id = Column(String(100))
    client_secret = Column(String(100))
    firstName = Column(String(145))
    lastName = Column(String(145))
    address = Column(String(45))

    tceCampaign = relationship("TceCampaign", back_populates="user")

class TceCampaign(Base):
    __tablename__ = 'tceCampaign'

    userId = Column(Integer, ForeignKey('user.id'))
    name = Column(String(100))
    dailyStartTime = Column(Time)
    dailyEndTime = Column(Time)
    startDays = Column(Integer)

    user = relationship("User", back_populates="tceCampaign")
    tceContacts = relationship("TceContacts", back_populates="tceCampaign", cascade="all,delete")

class TceContacts(Base):

    __tablename__ = 'tceContacts'

    http_methods = ["get", 'POST']
    exclude_rels = ["tceCampRun"]
    custom_decorators = [jwt_required, test_dec]

    campId = Column(ForeignKey(u'tceCamp.id', ondelete=u'CASCADE'), index=True)
    firstName = Column(String(145))
    lastName = Column(String(145))

    tceCampaign = relationship(u'TceCampaign', back_populates="tceContacts")

class TceContactsHst(Base):
    __tablename__ = 'tceContactsHst'

    http_methods = ["get"]
    custom_decorators = [jwt_required, test_dec]

    contactsId = Column(ForeignKey(u'tceContacts.id'), index=True)
    runStatus = Column(String(45))
    processId = Column(Integer)
    process = Column(String(45))
    rate = Column(Numeric(6, 4))

    tceContacts = relationship(u'TceContacts')

class User(SAFRSBase, db.Model):

    id = db.Column(String, primary_key=True)
    username = db.Column(db.String(32))

    @classmethod
    def filter(cls, *args, **kwargs):
        print(args, kwargs) # args[0] should contain the filter= url query parameter value
        return cls.query.filter_by(username = args[0])