JavaScript 如何调用 Python 后端服务

野性酷女 2023-10-15 12:42 83阅读 0赞

![00d6877cfa5f4a7f8503b5218bb464f1.png][]

本篇文章旨在通过一段JavaScript来演示如何调用python后端服务的，这是我开发的一个构建测试数据的工具。

**第一部分：html 代码部分**

![5eea2410ef0f4da89668f7a346c37d0a.png][]

**第二部分：JavaScript代码部分**

![5fcb027955f844a6ba2a0a8c81e99e10.png][]

**第三部分：Python后端代码**

@app.route('/insertInvertory',methods=['GET'])
    def insertInvertory():
        env=request.args.get('env')
        code=request.args.get('code')
        datenow = time.strftime("%Y-%m-%d")
    
        db=DBUtils(env)
        selectsql="SELECT a.id propertyId,c.id roomTypeId,c.code RoomType FROM info.property AS a,info.room_class AS b,info.room_type AS c WHERE a.code ='"+code+"' AND b.property_id =a.id AND c.room_class_id =b.id"
        result=db.dbSelect(selectsql)
    
        for i in range(len(result)):
            property_id=str(result[i]['propertyId'])
            delsql = "DELETE  FROM inv.`property_inventory_detail` WHERE property_id ='"+property_id+"' AND effective_date >='" + str(datenow) + "'"
            dbs = DBUtils(env)
            resutls = dbs.dbExcute(delsql)
            print("the resutls is:",resutls)
            print(delsql)
    
        for i in range(len(result)):
            property_id=str(result[i]['propertyId'])
            relation_id=str(result[i]['roomTypeId'])
            insertsql="INSERT INTO inv.`property_inventory_detail`(property_id,relation_type,relation_id,effective_date,original,consume,STATUS,create_time,update_time,deducted,out_order,non_deducted) \
            VALUES \
            ("+property_id+",4,"+relation_id+",DATE_ADD('"+str(datenow)+"',INTERVAL 0 DAY),100,0,1,NOW(),NOW(),0,0,0),\
            ("+property_id+",4,"+relation_id+",DATE_ADD('"+str(datenow)+"',INTERVAL 1 DAY),100,0,1,NOW(),NOW(),0,0,0),\
            ("+property_id+",4,"+relation_id+",DATE_ADD('"+str(datenow)+"',INTERVAL 90 DAY),100,0,1,NOW(),NOW(),0,0,0);"
            dbs = DBUtils(env)
            resutls=dbs.dbExcute(insertsql)
            print(resutls)
            print(insertsql)
        return jsonify("<p color='green'>{status:200,msg:it's success!!!}</p>")

**第四步：执行成功后返回结果**

![96ddd83f1a804ac39cac7f50f8c3e2bf.png][]

**总结：测试工程师要进步就得不断的学习充电，掌握的技能（不仅是测试技能）越多你对测试的认识也就越深入，与君共勉。**

**最后：**下方这份完整的软件测试视频教程已经整理上传完成，需要的朋友们可以自行领取**【保100%免费】**

![8b0171187dce405e878f274a8cdd9ec0.png][]

#### **软件测试面试文档** ####

我们学习必然是为了找到高薪的工作，下面这些面试题是来自阿里、腾讯、字节等一线互联网大厂最新的面试资料，并且有字节大佬给出了权威的解答，刷完这一套面试资料相信大家都能找到满意的工作。

![a3e4226c935c4242804cbdf26b571bc6.png][]

![58df6cd288094ad8874e814f2477620b.gif][]

[00d6877cfa5f4a7f8503b5218bb464f1.png]: https://img-blog.csdnimg.cn/00d6877cfa5f4a7f8503b5218bb464f1.png
[5eea2410ef0f4da89668f7a346c37d0a.png]: https://img-blog.csdnimg.cn/5eea2410ef0f4da89668f7a346c37d0a.png
[5fcb027955f844a6ba2a0a8c81e99e10.png]: https://img-blog.csdnimg.cn/5fcb027955f844a6ba2a0a8c81e99e10.png
[96ddd83f1a804ac39cac7f50f8c3e2bf.png]: https://img-blog.csdnimg.cn/96ddd83f1a804ac39cac7f50f8c3e2bf.png
[8b0171187dce405e878f274a8cdd9ec0.png]: https://img-blog.csdnimg.cn/8b0171187dce405e878f274a8cdd9ec0.png
[a3e4226c935c4242804cbdf26b571bc6.png]: https://img-blog.csdnimg.cn/a3e4226c935c4242804cbdf26b571bc6.png
[58df6cd288094ad8874e814f2477620b.gif]: https://img-blog.csdnimg.cn/58df6cd288094ad8874e814f2477620b.gif