python自学 第五周

pymysql

import pymysql

conn = pymysql.connect(host='192.168.1.7', port = 3306, user='root', passwd='000000', db='yj')

cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)  # 执行完毕返回的结果默认元组形式显示，这里改为字典

# sql = "create table test(id int, name varchar (20))"

#cursor.execute(sql)
# ret = cursor.execute("insert into test values(1,'alex'),(2,'alvin')")

#返回一个影响行数
RET = cursor.execute("select * from test")
# print(RET)

#取出结果，显示结果，这个东西的游标会动
print(cursor.fetchone())    #取第一条

# 游标移动
# cursor.scroll(1,mode='relative') # 相对移动
# cursor.scroll(4,mode='absolute')  # 绝对移动
print(cursor.fetchone())
# print(cursor.fetchmany(2))  #取多条
# print(cursor.fetchall())    #取所有

conn.commit()
cursor.close()
conn.close()

生成器函数

# coding=utf-8
import time
'''
生成器的yield相当于程序运行在哪里就会停下，下一次接着继续，占内存教小
'''
def test():
    print("开始！")
    yield 1
    time.sleep(2)
    yield 2
    time.sleep(2)
    yield 3

res = test()
print(res)
print(res.__next__())
print(res.__next__())

消费者模型

# coding=utf-8
import time
# def producer():
#     ret = []
#     for i in range(100):
#         time.sleep(0.1)
#         ret.append('包子{}'.format(i))
#     return ret
#
# def consumer(res):
#     for index,baozi in enumerate(res):
#         time.sleep(0.1)
#         print('第{0}个人，吃了{1}'.format(index,baozi))
#
# res = producer()
# consumer(res)

def consumer(name):
    print('我是{}，我要开始吃包子了！'.format(name))
    while True:
        time.sleep(0.5)
        baozi = yield
        print('{}高兴的吃了{}的包子！'.format(name,baozi))

def producer():
    for i in range(10):
        c1 = consumer('wangwu')
        c1.__next__()
        c1.send('肉馅{}'.format(i))

producer()