# -*- coding: UTF-8 -*-
# Author  :  LinYaoHong
# Date    :  2019/8/19 15:36
# Filename:  03-1-pymysql调用存储过程.py
# Tools   :  PyCharm
'''
CREATE PROCEDURE p1()
BEGIN
	SELECT * FROM student;
	INSERT INTO class(caption) VALUES("测试班级");
END;
'''
import pymysql
conn = pymysql.connect(host='localhost',
                       port=3306,
                       user="root",
                       password='111111',
                       db="test",
                       charset='utf8')
cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)  # 游标
cursor.callproc('p1')
conn.commit()
result = cursor.fetchall()
print(result)

cursor.close()
conn.close()