Lesson - 58 : Python Advanced - Python Database Access : Calling MySQL Stored Procedures in Python

Publicado el: 16 enero 2018
en el canal de: Sada Learning Hub

3,686

**************************************************
Python Core PlayList :    • Lesson - 01 : Python3 - What is python
Python Advanced PlayList :    • Lesson - 46 : Python Advanced - Python OOP...
**************************************************

Python Database Access : Calling MySQL Stored Procedures in Python :
To call a stored procedure in Python, you follow the steps below:
Connect to MySQL database by creating a new MySQLConnection object.
Instantiate a new MySQLCursor object from the MySQLConnection object by calling the cursor() method.
Call  callproc() method of the MySQLCursor object. You pass the stored procedure’s name as the first argument of the  callproc() method. If the stored procedure requires parameters, you need to pass a list as the second argument to the  callproc() method. In case the stored procedure returns a result set, you can invoke the  stored_results() method of the MySQLCursor object to get a list iterator and iterate this result set by using the  fetchall() method.
Close the cursor and database connection as always.
Example :
db_config = read_db_config()
conn = MySQLConnection(**db_config)
cursor = conn.cursor()
cursor.callproc('find_all')

Sample Projects : https://github.com/SadaLearningHub1/P...

En esta página del sitio puede ver el video en línea Lesson - 58 : Python Advanced - Python Database Access : Calling MySQL Stored Procedures in Python de Duración hora minuto segunda en buena calidad , que subió el usuario Sada Learning Hub 16 enero 2018, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 3,686 veces y le gustó 17 a los espectadores. Disfruta viendo!

1,090