#!/usr/bin/python3.6
# -*- coding: utf-8 -*-
#
# Copyright (C) 2022 #
# @Time    : 2022/4/1 11:27
# @Author  : ming
# @Email   : zhangdongming@asj6.wecom.work
# @File    : CronDelDataController.py
# @Software: PyCharm
from django.db import connection

from Object.ResponseObject import ResponseObject
from Object.utils import LocalDateTimeUtil


def deleteExpireAccessLog(request):
    response = ResponseObject()
    try:
        print(request)
        cursor = connection.cursor()
        # 删除一个月前的数据
        last_month = LocalDateTimeUtil.get_last_month()
        sql = 'DELETE FROM access_log WHERE time < %s limit %s'
        cursor.execute(sql, [last_month, 10000])
        # 关闭游标
        cursor.close()
        connection.close()
        return response.json(0)
    except Exception as e:
        return response.json(500, repr(e))