def fileUpload():
if request.method == 'POST':
if 'file' not in request.files:
return redirect(request.url)
file = request.files['file']
mp = MysqlPool()
sql = "insert into tb_comment(content,add_time) values(%s,now())"
params = []
while True:
lines = file.readline() # 整行读取数据
if not lines:
break
params.append(lines)
mp.insertMany(sql, params)
res_json = {"code": "0000"}
return jsonify(res_json)
def insetData(sql,param):
mp = MysqlPool()
mp.insertMany(sql, param)
# This is a sample Python script.
# Press Shift+F10 to execute it or replace it with your code.
# Press Double Shift to search everywhere for classes, files, tool windows, actions, and settings.
from db import MysqlPool
def print_hi(name):
# Use a breakpoint in the code line below to debug your script.
print(f'Hi, {name}') # Press Ctrl+F8 to toggle the breakpoint.
# Press the green button in the gutter to run the script.
if __name__ == '__main__':
print_hi('PyCharm')
with open("keyword_bak.txt", "a") as file:
file.write("aaaa\n")
mp = MysqlPool()
sql = "insert into tb_bac(abc) values(%s)"
param = [[1], [1]]
mp.insertMany(sql, param)
# See PyCharm help at https://www.jetbrains.com/help/pycharm/