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

Publicado em: 16 Janeiro 2018
no 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...

Nesta página do site você pode assistir ao vídeo on-line Lesson - 58 : Python Advanced - Python Database Access : Calling MySQL Stored Procedures in Python duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Sada Learning Hub 16 Janeiro 2018, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 3,686 vezes e gostou 17 espectadores. Boa visualização!

262