import json
import logging
from config import *
from client import client
import datetime
from MysqlDB import MysqlDB
from tornado.ioloop import IOLoop
from tornado.web import Application, RequestHandler
from apscheduler.schedulers.blocking import BlockingScheduler

# create_time = '2022-04-15'
# create_time = datetime.datetime.now().strftime('%Y-%m-%d')
create_time = (datetime.datetime.now() - datetime.timedelta(days=1)).strftime("%Y-%m-%d")
print(create_time)
db = MysqlDB(mysql_[0], mysql_[1], mysql_[2], mysql_[3])


def logic():
    while 1:
        db.connection()
        data = [i[0] for i in db.getAllData(
            f"SELECT id FROM final_companies_notices WHERE publish_time >= '{create_time}' AND es_status =0 limit 2")]
        db.closeconn()
        if data:
            client_ = client(data)
            if client_:
                k = len(data)
                for i in range(len(data)):
                    db.connection()
                    db.crud(f'update final_companies_notices set es_status = 1 where id = {data[i]}')
                    db.closeconn()
                    k -= 1
                    print(f'剩余：{k}')

                    print('client_')
            else:
                print('erro')
        else:
            break


scheduler = BlockingScheduler()
scheduler.add_job(logic, "cron", hour=0, minute=0)
scheduler.start()