github小练习002

来源：互联网发布：半生缘葛优知乎编辑：程序博客网时间：2024/06/15 09:21

网址链接 https://github.com/Yixiaohan/show-me-the-code

每日一个小练习。今天是随机生成一段优惠码，并将其加入到MySQL数据库中，今天正好刚学MySQL的操

作，正好使用了，哈哈。本文使用两种方式来实现该目标(当然大体上是一致的，我只是写到一半想测验

一下哪种方法速度更快点。

一. 先将生成的优惠码放入list列表中，然后再从list列表中一一取出，存入数据库

# -*- coding: utf-8 -*-import MySQLdbimport randomimport stringimport time#第一种def add_db(lists):    conn = MySQLdb.Connect(host='127.0.0.1', user='root', passwd='', port=3306, db='imooc', charset='utf8')    cursor = conn.cursor()    count = 1    for list in lists:        try:            sql = "insert into favourable_code(number) values('%s')" % list            cursor.execute(sql)            print "successed to" + str("%d") % count            count += 1            conn.commit()        except Exception as e:            conn.rollback()            print e    cursor.close()    conn.close()def get_list(key_number, key_len):    lists = []    for i in range(key_number):        a = ''.join([random.choice(string.letters + string.digits) for j in range(key_len)])        lists.append(a)    return listsif __name__ == "__main__":    t1 = time.time()    key_len = 20    key_number = 500    lists = get_list(key_number, key_len)    add_db(lists)    t2 = time.time()    print t2 - t1

二. 生成一个，存入一个。

# -*- coding: utf-8 -*-import MySQLdbimport randomimport stringimport timedef get_list(key_number, key_len):    conn = MySQLdb.Connect(host='127.0.0.1', user='root', passwd='', port=3306, db='imooc', charset='utf8')    cursor = conn.cursor()    #lists = []    for i in range(key_number):        a = ''.join([random.choice(string.letters + string.digits) for j in range(key_len)])        #lists.append(a)        count = 1        try:            sql = "insert into favourable_code(number) values('%s')" % a            cursor.execute(sql)            print "successed to" + str("%d") % count            count += 1            conn.commit()        except Exception as e:            conn.rollback()            print e    cursor.close()    conn.close()if __name__ == "__main__":    t1 = time.time()    key_len = 20    key_number = 500    get_list(key_number, key_len)    t2 = time.time()    print t2 - t1

其实大家想想也知道，一个是先存再取，一个直接用，所以第二种速度更快些。大家可以一起来试试！

0 0