from pymysql import connect
import multiprocessing
import threading
import gevent
from gevent import monkey
monkey.patch_all()
import time
class Sql_class:
def __init__(self):
self.db = connect(host = "192.168.113.146",database = "python3",port = 3306,user = "root",password = "yuan121423",charset = "utf8")
self.cur = self.db.cursor()
def __del__(self):
self.cur.close()
self.db.close()
def update(self):
sql = """insert into goods_cates(name) values('小学生')"""
# sql = """delete from goods_cates WHERE name = '小学生'"""
# sql = """update goods_cates set name = 'hahaha' WHERE name = '小学生'"""
try:
data = self.cur.execute(sql)
# sleep(1)
except Exception as e:
print("更新失败")
self.db.rollback()
else:
self.db.commit()
print("更新成功")
def select(self):
# sql = """select g.name as a,c.name as e,b.name as t,abc.max_price from goods as g
# inner join goods_cates as c on g.cate_id=c.id inner join goods_brands as b on
# g.brand_id=b.id inner join ( select cc.name as ss,max(gg.price) as max_price from goods as gg
# inner join goods_cates as cc on gg.cate_id = cc.id group by cc.name) as abc on abc.ss = c.name and abc.max_price = g.price;"""
sql = """select * from students"""
data = self.cur.execute(sql)
for i in range(data):
name = self.cur.fetchone()
print(name[0],name[1])
# self.cur.close()
# self.db.close()
def main():
#port=3306,database='python3',user='root',password='yuan121423',charset='utf8'
# db = connect(host = "192.168.113.146",database = "python3",port = 3306,user = "root",password = "yuan121423",charset = "utf8")
# cur =db.cursor()
start = time.time()
dx = Sql_class()
# g1 = gevent.spawn(dx.update())
# g2 = gevent.spawn(dx.select())
# gevent.joinall([g1,g2])
# thd1 = threading.Thread(target=dx.select())
# thd2 = threading.Thread(target=dx.update())
# thd1.start()
# thd2.start()
# pro1 = multiprocessing.Process(target=dx.update())
# pro2 = multiprocessing.Process(target=dx.select())
# pro2.start()
# pro1.start()
# update(cur,db)
# select(cur,db)
dx.select()
dx.update()
stop = time.time()
print(stop-start)
if __name__ == '__main__':
main()