python代码怎么写的更简洁？

Question

这个是一个一秒为间隔 将一秒内的io流 存进数据库的脚本 请问有没有简洁点的写法

 #!/usr/bin/python3
import psutil
import time
import pymysql as mysqldb

db=mysqldb.connect(user='root',passwd='123123',db='sanle',host="localhost")
db.autocommit(True)
cur=db.cursor()
def get_recv():
    return psutil.net_io_counters().bytes_recv
def get_sent():
    return psutil.net_io_counters().bytes_sent
while 1:
    old_recv=get_recv()
    old_sent=get_sent()
    time.sleep(1)
    timestamp=int(time.time())
    bytes_recv=get_recv()-old_recv
    bytes_sent=get_sent()-old_sent
    print('timestamp:%s recv:%d sent:%d' %(timestamp,bytes_recv,bytes_sent))
    sql="insert into nic(time,nic_in,nic_out) values('{0}','{1}','{2}')".format(timestamp,bytes_recv,bytes_sent)
    cur.execute(sql)

Answer 1

http://blog.csdn.net/qq_15283475/article/details/70792785