获取mysql8.0自定义函数与存储过程生成文件

#!/usr/bin/python
# -*- coding=utf-8 -*-
import pymysql

def fn_get_mysql_v5():
    pass
def fn_get_mysql_v8():
    pass




def fn_proc_ddl2sql(db,is_dbMultiFiles):
    mydb = pymysql.connect("127.0.0.1","root","Root123.","anhua",port=3306,charset='utf8' )
    #mydb.set_character_set('utf8')
    mycursor = mydb.cursor()
    mycursor.execute('SET CHARACTER SET utf8;')
    mycursor.execute('SET NAMES utf8;')
    mycursor.execute('SET character_set_connection=utf8;')
    mycursor.execute("select version()" )
    mysqlVer = mycursor.fetchall()[0][0]
    print mysqlVer
    if mysqlVer>='8.0':
        sqlV58 = '''
                SELECT CONCAT('show create ' ,ROUTINE_TYPE  , '`', ROUTINE_SCHEMA  ,'`.`', p.`SPECIFIC_NAME`,'`;') showSql ,