flysql 里两种传参的方式

 

传参的方式，两个标清楚：

        for lists_bx_goods in out_list:
            sql = XDO().get_update_sql('init_goods_test', {
                "一级类目id": lists_bx_goods['first_id'],
                "一级类目名称": lists_bx_goods['first_name'],
                "二级类目id": lists_bx_goods['second_id'],
                "二级类目名称": lists_bx_goods['second_name'],
                "三级类目id": lists_bx_goods['third_id'],
                "三级类目名称": lists_bx_goods['third_name']
            }, 'tag_id_1 = "{}" AND tag_id_2 ="{}"'.format(lists_bx_goods['id_2'],
                                                           lists_bx_goods['id_1']))

 

按照flsql 的语音去写：

　　　　

        for obj_dict in obj_list:
            sql = XDO().get_update_sql('szq.org_sales_daily', {
                field_name: obj_dict[field_name],
            }, 'org_id = "' + str(obj_dict['org_id']) + '" AND sales_date = "' + self.sales_date + '"')
            db.session.execute(sql)

 

转载于:https://www.cnblogs.com/sakura3/p/11393937.html