# -*- coding: utf-8 -*-

import pymysql

import time

import datetime

import requests

shijian=int(time.time())

print(shijian)

date_stamp = datetime.datetime.fromtimestamp(shijian)

date_str = datetime.datetime.strftime(date_stamp, "%Y-%m-%d %H:%M:%S")

print(date_str)

conn_wangzhan = pymysql.connect(

            host='42.236.8.195',

            user='yng',

            password='sLG4a74RXLbGkxB',

            database='yng',

            charset='utf8mb4')

cursor_wangzhan = conn_wangzhan.cursor(cursor=pymysql.cursors.DictCursor)

# 插入文章主表数据

sql = f"INSERT INTO dede_archives (typeid, title,flag,pubdate,senddate,weight,sortrank) VALUES (8192, '今日猪价（2024.03.28）','c',{shijian},{shijian},{shijian},{shijian})"

cursor_wangzhan.execute(sql)

insert_id=conn_wangzhan.insert_id()

print(insert_id)

conn_wangzhan.commit()

# 插入文章附加表数据

sql = f'''INSERT INTO dede_addonarticle (`aid`, `typeid`, `body`) VALUES ({insert_id}, 8192, '大田县生猪养殖协会成立于2014年8月1日，2022年7月第三届换届以来，现有会员66人（包括大田县昌华槐猪合作社社员37人），其中理事单位15家会员单位，选出会长单位1家，副会长单位7家，秘书长1人，监事单位9家，选出监事长单位1家，副监事长单位3家。')'''

cursor_wangzhan.execute(sql)

conn_wangzhan.commit()

# 更新文章索引表数据

sql = f'''INSERT INTO dede_arctiny (`id`, `typeid`,   `senddate`,sortrank) VALUES ('{insert_id}', 8192, {shijian}, {shijian} )'''

cursor_wangzhan.execute(sql)

conn_wangzhan.commit()

cursor_wangzhan.close()

conn_wangzhan.close()

#更新缓存

session = requests.Session()

# # 登录dedecms后台

url = 'https://www.678.cn/admin_ncyzf/login.php'

params={

    'gotopage': '/admin_ncyzf/index.php'

}

session.get(url,params=params)

login_url ='https://www.678.cn/admin_ncyzf/login.php'

login_data = {

    'userid': 'capainzhao',

    'pwd': 'xiaoqia1',

    'gotopage': '',

    'dopost': 'login'

}

login_response = session.post(login_url, data=login_data)

session.get(f'''https://www.678.cn/admin_nccyzf/task_do.php?typeid=8192&aid={insert_id}&dopost=makeprenext&nextdo=makeindex,makeparenttype''')

session.get(f'''https://www.678.cn/admin_nccyzf/task_do.php?f=0&typeid=8192&aid={insert_id}&dopost=makeindex&nextdo=makeparenttype''')

session.get(f'''https://www.678.cn/admin_nccyzf/task_do.php?f=0&typeid=8192&aid={insert_id}&dopost=makeparenttype''')

#并不知道为何此处需要重新访问生成页面，但是这样确实解决了问题

session.get(f'''https://www.678.cn/admin_nccyzf/task_do.php?typeid=8192&aid={insert_id+1}&dopost=makeprenext&nextdo=makeindex,makeparenttype''')

session.get(f'''https://www.678.cn/admin_nccyzf/task_do.php?f=0&typeid=8192&aid={insert_id+1}&dopost=makeindex&nextdo=makeparenttype''')

session.get(f'''https://www.678.cn/admin_nccyzf/task_do.php?f=0&typeid=8192&aid={insert_id+1}&dopost=makeparenttype''')