dsfs-python脚本

 

 

import pymysql
import datetime
import os
import time
def conn_mysql():
    conn = pymysql.connect(host='127.0.0.1',
                           port=3306,
                           user='root',
                           password='root',
                           db='automl459',
                           charset='utf8')
    cur = conn.cursor()
#    date_time = datetime.date.today().strftime("%Y-%m-%d %H:%M:%S")
    qianyitian = (datetime.date.today() + datetime.timedelta(days=-1)).strftime("%Y-%m-%d")
    print(qianyitian)
    sql_list = [["delete from engine_data_table where create_time<'{} 00:00:00'".format(qianyitian),
                 "select count(*) from engine_data_table where create_time<'{} 00:00:00'".format(qianyitian),
                 "engine_data_table"],
                ["delete from engine_data_job where create_time<'{} 00:00:00'".format(qianyitian),
                 "select count(*) from engine_data_job where create_time<'{} 00:00:00'".format(qianyitian),
                 "engine_data_job"]]
    r = ''
    for i, v, q in sql_list:
        try:
            cur.execute(i)
            conn.commit()
            time.sleep(2)
            cur.execute(v)
            conn.commit()
            a = str(cur.fetchall())[2:-4]
            print(a)
            r= r + q + "=" + a + " "

        except Exception as e:
            print(e)
    print(r)
    os.system('/root/ysw/script/message2wechat -u "ooSyK50IPCHlbUZUWB14WNj4ldjI"  -s "Phoenix_||空间，每周五mysql清理" -n 运营平台 -t `date +%F_%T` -d "{}"'.format(r))
    cur.close()
    conn.close()

if __name__ == '__main__':
    conn_mysql()



30 9 * * 5  /usr/bin/python3  /root/ysw/script/clear_mysql_talble.py &>/dev/null

 

import pymysql
import datetime
import os
import time
def conn_mysql():
    conn = pymysql.connect(host='127.0.0.1',
                           port=3306,
                           user='root',
                           password='root',
                           db='automl459',
                           charset='utf8')
    cur = conn.cursor()
#    date_time = datetime.date.today().strftime("%Y-%m-%d %H:%M:%S")
    qianyitian = (datetime.date.today() + datetime.timedelta(days=-1)).strftime("%Y-%m-%d")
    print(qianyitian)
    sql_list = [["delete from engine_data_table where create_time<'{} 00:00:00'".format(qianyitian),
                 "select count(*) from engine_data_table where create_time<'{} 00:00:00'".format(qianyitian),
                 "engine_data_table"],
                ["delete from engine_data_job where create_time<'{} 00:00:00'".format(qianyitian),
                 "select count(*) from engine_data_job where create_time<'{} 00:00:00'".format(qianyitian),
                 "engine_data_job"]]
    r = ''
    for i, v, q in sql_list:
        try:
            cur.execute(i)
            conn.commit()
            time.sleep(2)
            cur.execute(v)
            conn.commit()
            a = str(cur.fetchall())[2:-4]
            print(a)
            r= r + q + "=" + a + " "

        except Exception as e:
            print(e)
    print(r)
    os.system('/root/ysw/script/message2wechat -u "ooSyK50IPCHlbUZUWB14WNj4ldjI"  -s "Phoenix_||空间，每周五mysql清理" -n 运营平台 -t `date +%F_%T` -d "{}"'.format(r))
    cur.close()
    conn.close()

if __name__ == '__main__':
    conn_mysql()

每周五早上9:30执行
30 9 * * 5  /usr/bin/python3  /root/ysw/script/clear_mysql_talble.py &>/dev/null




try:
    from clear_mysql_talble import conn_mysql
    conn_mysql()
except:
    import os
    info = "Phoenix_||空间，每周五mysql清理脚本执行异常"
    try:
        os.system('/root/ysw/script/message2wechat -u "ooSyK50IPCHlbUZUWB14WNj4ldjI"  -s "Phoenix_||空间，mysql清理" -n 运营平台 -t `date +%F_%T` -d "{}"'.format(info))
    except:
        os.system('/root/ysw/script/message2wechat -u "ooSyK50IPCHlbUZUWB14WNj4ldjI"  -s "Phoenix_||空间，mysql清理" -n 运营平台 -t `date +%F_%T` -d "{}"'.format(info))