python 前端参数不定的级联查询实现

class AlarmTable(APIMeta):
    def __init__(self, request):
        super(AlarmTable, self).__init__(request)
        self.form_class = forms.AlarmTable

    def handle(self, cleaned_data):
        start_time = time.strftime('%Y-%m-%d %H:%M:%S', time.strptime(cleaned_data['start_time'], '%Y-%m-%d %H:%M:%S'))
        end_time = time.strftime('%Y-%m-%d %H:%M:%S', time.strptime(cleaned_data['end_time'], '%Y-%m-%d %H:%M:%S'))
        operator = ''
        service_name = ''
        area_name = ''
        level = ''
        components = ''
        biz_name = ''
        if cleaned_data['operator'] != '':
            operator = "AND operator='{0}'".format(cleaned_data['operator'])
        if cleaned_data['service_name'] != '':
            service_name = "AND service_name='{0}'".format(cleaned_data['service_name'])
        if cleaned_data['area_name'] != '':
            area_name = "AND area='{0}'".format(cleaned_data['area_name'])
        if cleaned_data['level'] != '':
            level = "AND important_level='{0}'".format(cleaned_data['level'])
        if cleaned_data['component'] != '':
            components = "AND components='{0}'".format(cleaned_data['component'])
        if cleaned_data['biz_name'] != '':
            biz_name = "AND biz_name='{0}'".format(cleaned_data['biz_name'])

        sql = """SELECT dtEventTime,service_name,operator,biz_name,area,important_level,err_content,components
                 FROM test_table
               WHERE dtEventTime>='{0}' AND dtEventTime<='{1}' {2} {3} {4} {5} {6} {7} order by dtEventTime desc limit 5000
        """.format(start_time, end_time, operator, service_name, area_name, level, components, biz_name)
        data_rst = bk_data.send_request(sql)
        return data_rst