"""
author:张鑫
date:2021/7/30 20:39
"""
import requests
import pymysql
connect = pymysql.Connect(
host='140.210.4.73',
port=3306,
user='twipad_cj',
passwd='bj@#twipad_cj',
db='tw_ipaddb',
charset='utf8mb4'
)
cursor = connect.cursor()
keyword_list = []
for lines in open('接口ID', encoding='utf8'):
lines = lines.strip()
keyword_list.append(lines)
print(f'keyword_list={keyword_list}')
for keyword_list in keyword_list:
url = f'http://twipad.hnxinxiudata.top/api/data/del_data?tablename=hkby_facebookhistory_abroaddataall&id={keyword_list}'
html = requests.get(url)
print(html)
# 增加数据
# sql1 = 'insert into kasaer(name,age,score) values (1,2,3)'
# 删除数据,1是字符串
sql = f'delete from hkby_facebookhistory_abroaddataall where ir_id={keyword_list}'
# 修改数据
# sql='update kasaer set age=18,score=80 where name="路明非" '
# 查询数据
# sql2 = 'select * from kasaer'
data1 = cursor.execute(sql)
print(data1)
connect.commit()
print('修改成功')
connect.close()
