'''

create  2018/7/4

version 1.0

auth    jabbok

info    get the uv_number from nginx log and insert into mysql(monitor.uv)

'''

import pymysql

import subprocess

import time

def insert(mdate,num):

    conn = pymysql.connect("127.0.0.1","user","passeord","database")

    cursor = conn.cursor()

    sql = """

    insert into uv (id,vistors) VALUES (%d,%d)

    """ %(mdate,num)

    try:

        cursor.execute(sql)

        conn.commit()

        return 0

    except:

        conn.rollback()

        return 1

if __name__ == "__main__":

    mdate = int(time.strftime('%Y%m%d',time.localtime(time.time())))

    cmd = "cat /var/log/nginx/access.log-%d | awk '{print $1}' | sort -r | uniq -c | wc -l > /home/scripts/uv.info" %(mdate)

    print(cmd)

    p = subprocess.Popen(cmd, stdout=subprocess.PIPE, shell=True)

    time.sleep(3)

    with open('uv.info') as obj:

        num = int(obj.readlines()[0])

        insert(mdate,num)

[root@iZbp1ezumclop9223l31okZ scripts]# crontab -l

10 10 * * * cd /home/scripts;/usr/bin/python uv_monitor.py 1>a1 2>b1

MariaDB [monitor]> select * from uv;

+----------+---------+

| id       | vistors |

+----------+---------+

| 20180704 |    xx|

| 20180705 |    xx|

+----------+---------+