SQLALchemy 万能查询

 name = \
            Subject_history.query.filter(and_(Subject_history.person_name == person_name if person_name else '',
                                      Subject_history.trigger >= start_time if start_time else '',
                                      Subject_history.trigger <= end_time if end_time else '',
                                      Subject_history.person_name == subject_type if subject_type else '')).all()

            print(len(name))
            print(type(name))
            conut = len(name)

            l = []
            for i in range(conut):

                l1=[]
                server_photo = name[i].server_photo
                snap_path = name[i].snap_path
                screen_name = name[i].screen_name
                person_name = name[i].person_name
                person_gender = name[i].person_gender
                person_age = name[i].person_age
                subject_type = name[i].subject_type
                person_tag = name[i].person_tag
                person_vip = name[i].person_vip
                trigger = name[i].trigger
                l1.append(subject_type)
                if person_vip == "1":
                    person_vip = "2"
                    l1.append(person_vip)
                if person_tag == "1":
                    person_tag = "3"
                    l1.append(person_tag)

                data = {}
                data["server_photo"] = server_photo
                data["snap_path"] = snap_path
                data["screen_name"] = screen_name
                data["person_name"] = person_name
                data["person_gender"] = person_gender
                data["person_age"] = person_age
                data["subject_type"] = l1
                # data["person_tag"] = person_tag
                # data["person_vip"] = person_vip
                data["trigger"] = trigger
                l.append(data)
        except:
                 print("messageMsg识别记录查询失败code-1")
                 data = {"messageMsg": "识别记录查询失败", "code": "-1"}
                 return json.dumps(data)
        data = {"messageMsg": "识别记录查询成功","code": "0", "data": l}
        return json.dumps(data)```