mysql 8.0 创建函数_获取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 ,'`.&#