using mysql-connector-python package
from db_works import db_connect
# view also need to be locked
def call_procedure():
cursor.execute("CALL `procedure_schema.procedure_name`();")
if __name__ == "__main__":
# connect to db
cursor, cnxn = db_connect()
call_procedure()