python pymysql 调用存储过程

import pymysql,time,datetime
from pymysql import connections
from pymysql.cursors import DictCursor


# 获取昨天的日期 
def get_yesterday_day(self):
    today = datetime.date.today()
    yesterday = today - datetime.timedelta(days=1)
    yesterday2 = str(yesterday)
    return yesterday2

video_date = time.strftime("%Y-%m-%d")
yesterdate = get_yesterday_day()

settings=get_project_settings() #获取settings配置，设置需要的信息
       try:
            # 连接到数据库
            conn = pymysql.connect(host=settings['MYSQL_HOST'], port=settings['MYSQL_PORT'], user=settings['MYSQL_USER'],passwd=settings['MYSQL_PASSWD'],db =settings['MYSQL_DBNAME'],use_unicode=True, charset="utf8mb4",cursorclass=DictCursor)
            # 创建游标对象
            cursor = conn.cursor()
        
            # 调用存储过程 方式1
            # cursor.execute("CALL pro_tj_tiktokdata('"+str(yesterdate)+"','"+str(video_date)+"');")
            # 调用存储过程 方式2
            cursor.callproc('pro_tj_tiktokdata', [yesterdate ,video_date])

            conn.commit()
            # 关闭游标和数据库连接
            cursor.close()
            conn.close()
        except Exception as e:
            print("出错：",e)