Call a procedure in python
Definition¶A procedure allows us to group a block of code under a name, known as a procedure name. We can call the block of code from anywhere in the program to execute the instructions it contains. We can also pass values to the procedure to change how it works. Show
Note Wherever possible you should try to use procedures or functions as they tend to make your code more readable. Easy example¶def showMenu(): print('Main Menu') print('1. Play game') print('2. View high scores') print('3. Quit') showMenu() Main Menu 1. Play game 2. View high scores 3. Quit Note
Note A procedure needs to be defined earlier in the program than when it is called. Syntax¶#define a procedure def procedureName(arg1, arg2, ...): print('put instructions here') #call the procedure procedureName() Examples¶Example 2 - Use an argument¶def storyStart(name): print('Once upon a time, ' + name + ' was imprisoned in a castle.') print('They were desperate to escape, but couldn\'t.') userName = input('What is your name? ') storyStart(userName) What is your name? Joe Once upon a time, Joe was imprisoned in a castle. They were desperate to escape, but couldn't. Example 3 - Use two arguments¶The following program first creates a procedure which takes a name and gender and then correctly creates the start of a story using the correct pronouns, he or she. This procedure is used later when it is called using the information which the user inputs. def storyStart(name, gender): pronoun = '' if gender == 'm': pronoun = 'He' elif gender == 'f': pronoun = 'She' print('Once upon a time, ' + name + ' was imprisoned in a castle.') print(pronoun + ' was desperate to escape, but couldn\'t.') userName = input('What is your name? ') gender = input('Are you male or female (type m or f)? ') storyStart(userName, gender) What is your name? Joe Are you male or female (type m or f)? m Once upon a time, Joe was imprisoned in a castle. He was desperate to escape, but couldn't. Example 4 - Using a list as an argument¶def displayListAndNumber(theList): for i in range(len(theList)): itemNumber = i + 1 #This adds one to the current loop number as Python lists start at zero, but we want the shopping list to start at one. print(str(itemNumber) + '. ' + theList[i]) print('---------------------') shoppingList = ['eggs', 'milk', 'ham', 'fish', 'bread'] shoppingListHardware = ['saw', 'drill', 'wood'] displayListAndNumber(shoppingList) displayListAndNumber(shoppingListHardware) 1. eggs 2. milk 3. ham 4. fish 5. bread --------------------- 1. saw 2. drill 3. wood --------------------- Example 5 - Using global variables¶pi = 3.14 def showAreaOfCircle(radius): area = pi * radius * radius print('Area: ' + str(area)) def updatePi(newPi): global pi pi = newPi showAreaOfCircle(10) updatePi(3.141) showAreaOfCircle(10) Note We need to use the keyword Key points¶Hint When you decompose a program into smaller parts, these will usually end up getting programmed in functions or procedures. Hint Procedures and functions are ways of abstracting your program. If you can think of parts of the program that are similar, then it is best to abstract them into their own procedure or function. Note Procedures and functions are both types of subroutines in programming. Both use the How do I call a SQL procedure in Python?Steps to execute MySQL Stored Procedure in Python. Connect to MySQL from Python. ... . Get Cursor Object from Connection. ... . Execute the stored procedure. ... . Fetch results. ... . Close the cursor object and database connection object.. How do you call a procedure?To call a Function procedure within an expression. Use the Function procedure name the same way you would use a variable. ... . Follow the procedure name with parentheses to enclose the argument list. ... . Place the arguments in the argument list within the parentheses, separated by commas.. How do you call a procedure in MySQL using Python?Follow the steps given below in order to call the stored procedures in the Python program.. Create a database connection using a mysql connector and proper credentials.. Create a cursor object.. Call the call_proc() method to call the procedure.. Iterate through the obj. ... . Print the result.. Close the cursor and DB connection.. What is meant by calling a procedure?3.2 Procedure Calls
A procedure call is a simple statement made by stating the procedure name, listing actual parameter names or values within parentheses, and adding a final semi-colon. General Form.
|