python 分析redis

发布时间：2019-08-12 09:51:44编辑：auto阅读（1858）


    #!/usr/bin/env python

    #coding=utf-8

    import MySQLdb

    import redis

    import os

    import socket,fcntl,struct

    #print redis._file_



    def get_ip_address(ifname):

        s = socket.socket(socket.AF_INET, socket.SOCK_DGRAM)

        return socket.inet_ntoa(fcntl.ioctl(

                    s.fileno(),

                    0x8915, # SIOCGIFADDR

                    struct.pack('256s', ifname[:15])

                    )[20:24])


    ip = get_ip_address('eth0')



    r = redis.Redis(host='192.168.100.89',port=6379,db=1)

    info = r.info()

    wr = open("a.txt",'w')


    for key in info:

        wr.write('%s  %s\n'  % (key, info[key]))

    wr.close()


    file_object = open('a.txt')

    try:

        all_the_text = file_object.read()

    finally:

        file_object.close()

    print type(all_the_text)

    print all_the_text


    db = MySQLdb.connect(user='root', db='redisinfo', passwd='llllll', host='localhost')

    cursor = db.cursor()

    sql_content = "insert into info_product(ip,name,jifang,redisinfo) values('%s', '%s', '%s', \"%s\")"%(ip,"tes111t","GZ",all_the_text)

    print sql_content

    cursor.execute(sql_content)

    db.commit()

    db.close()

    cursor.close()



    未完待续


关键字：

上一篇： python day six

下一篇： Python学习之List