python/python_stored_procedure/python_sp.py at master · joker2904/python

19 lines (18 loc) · 570 Bytes

import pymysql

from werkzeug import generate_password_hash, check_password_hash

try:

conn = pymysql.connect(host='localhost', database='roytuts', user='root', password='')

cur = conn.cursor()

_hashed_password = generate_password_hash('secret')

cur.callproc('sp_createUser',('Soumitra Roy','contact@roytuts.com',_hashed_password))

data = cur.fetchall()

if len(data) is 0:

conn.commit()

print('User information saved successfully !')

else:

print('error: ', str(data[0]))

except Exception as e:

print(e)

finally:

cur.close()

conn.close()

Provide feedback