qc-dgp/dgp/tests/demo/test.py

#!/usr/bin/env python
# -*- coding: utf-8 -*-

"""
__title__ = '测试类'

@Time    : 2020/9/24 19:44
@Author  : Kenny-PC
@Software: PyCharm

# code is far away from bugs with the god animal protecting
    I love animals. They taste delicious.
              ┏┓      ┏┓
            ┏┛┻━━━┛┻┓
            ┃      ☃      ┃
            ┃  ┳┛  ┗┳  ┃
            ┃      ┻      ┃
            ┗━┓      ┏━┛
                ┃      ┗━━━┓
                ┃  神兽保佑    ┣┓
                ┃　永无BUG！   ┏┛
                ┗┓┓┏━┳┓┏┛
                  ┃┫┫  ┃┫┫
                  ┗┻┛  ┗┻┛
"""

import time

from LoggerService import LoggerService
# import account_list as al
from MySQLConnection import MySQLConnection
from util import date_util


def start_order_job(log):
    log.info('start_order_job')


start_order_time = '2020-09-21 16:05:00'
start_cost_time = '2020-09-21 16:35:00'
a = 10817

if __name__ == '__main__':
    log = LoggerService.logger_file('../test.log', 'abcd')

    print(int(time.time()))
    print(date_util.getCurrentSecondTime())

    # print(date_util.getYesterdayStartTime(), platform_util.get_zhangzhongyun_format_time(date_util.getYesterdayStartTime()))

    request_time_stamp = time.time()
    st_unix = int((request_time_stamp + 8 * 3600) // 86400 * 86400 - 8 * 3600 - 86400)  # 昨天开始时间
    et_unix = int((request_time_stamp + 8 * 3600) // 86400 * 86400 - 8 * 3600)  # 昨天结束时间==(今天开始时间-1)
    st_dt = time.strftime("%Y-%m-%dT%H:%M:%S", time.localtime(st_unix)) + '+08:00'
    et_dt = time.strftime("%Y-%m-%dT%H:%M:%S", time.localtime(et_unix)) + '+08:00'
    print(st_unix, st_dt)
    print(et_unix, et_dt)

    et_unix = et_unix - 1
    print('========')
    print((et_unix - st_unix))
    timespace = 90 * 3600 * 24
    print(timespace)
    print((et_unix - st_unix) // timespace + 1)
    for x in range((et_unix - st_unix) // timespace + 1):  # 分时段
        print('x=', x)

    print((et_unix - st_unix) / 86400 + 1)
    for i in range(int((et_unix - st_unix) / 86400 + 1)):
        print('i=', i)
    for y in range(1):  # 分时段
        print('y=', y)

# print('时间转换')
# print(date_util.getYesterdayStartTime(), date_util.getSecondsToDatetime(date_util.getYesterdayStartTime()))
# print(date_util.getYesterdayEndTime(), date_util.getSecondsToDatetime(date_util.getYesterdayEndTime()))
# print(date_util.getTodayStartTime(), date_util.getSecondsToDatetime(date_util.getTodayStartTime()))
#
# print(time.strftime("%Y-%m-%d %H:%M:%S", time.localtime(date_util.getYesterdayStartTime())))
# print(date_util.getCurrentSecondTime())
# print(date_util.getSecondsToDatetime())
# print(date_util.getSecondsToDatetime(date_util.getYesterdayStartTime()))
# print(date_util.getSecondsToDatetime(date_util.getYesterdayStartTime(), "%Y-%m-%d %H:%M:%S"))

    sql = "select * from quchen_text.order where date=1601136000 and platform = '悠书阁'"
    connect = MySQLConnection()
    try:
        page = 1
        size = 50
        pagination = connect.listByPage(sql, page, size)
        print(pagination)
    except Exception as e:
        log.exception(e)
    finally:
        # 关闭数据库连接
        connect.close()

    # scheduler = BlockingScheduler()
    #
    # #每天凌晨执行
    # #start_job_time = '2020-09-26 03:05:00'
    # # scheduler.add_job(start_all_job, 'interval', days=1, start_date=start_job_time)
    #
    # #每天凌晨3点到4点的30分钟都执行一次
    # scheduler.add_job(start_all_job, 'cron', hour='3-4', minute='35')
    #
    # # 每10秒执行一次
    # #scheduler.add_job(start_all_job, 'interval', seconds=2)
    #
    # scheduler.start()