IT 117: Intermediate Scripting

IT 117: Intermediate to Scripting
Class 16 Exercise

Script for this exercise

Open a text editor
You can use the editor built into IDLE or use a program like Sublime.
Copy the text below into the file

Save the file as ex16.py
Copy the file umb.db from /home/ghoffman/course_files/it117_files
Use FileZilla to do this.
Run this script in IDLE
Open the script file in IDLE. Under the Run menu, select Run Module.

You should see something like

('09329034', 'Jane', 'Adams', 'Jane.Adams001@umb.edu', 'jadams', 'CSM')
('03687480', 'Alexander', 'Smith', 'Alexander.Smith001@umb.edu', 'bigboy', 'CM')
('05431692', 'Christopher', 'Cannon', 'Christopher.Cannon001@umb.edu', 'ccannon', 'CSM')
('07511379', 'Joseph', 'Malloney', 'Joseph.Malloney001@umb.edu', 'jmal', 'CSM')
('07518979', 'Fatih', 'Jones', 'Fatih.Jones001@umb.edu', 'fjones', 'CM')
('04175276', 'James', 'Reynolds', 'James.Reynolds001@umb.edu', 'jr', 'CSM')
('04686471', 'Joe', 'Riley', 'Joe.Reily003@umb.edu', 'reily', 'CM')
(1, 'it116', 1, 's17', '05431692')
(2, 'it116', 1, 's17', '09329034')
(3, 'it116', 1, 's17', '07518979')
(4, 'it244', 1, 's17', '07511379')
(5, 'it244', 1, 's17', '09329034')
(6, 'it244', 1, 's17', '04175276')
(7, 'it116', 1, 'sum17', '03687480')
(8, 'it116', 1, 'sum17', '07511379')
(9, 'it116', 1, 'sum17', '07518979')
(10, 'it117', 1, 'f17', '07518979')
(11, 'it117', 1, 'f17', '05431692')
(12, 'it117', 1, 'f17', '09329034')
(13, 'it244', 1, 'f17', '04686471')

Unix setup

Log in to users3.cs.umb.edu
You will be in your home directory.
Go to your it117 directory
```
cd it117
```
Go to your ex directory
```
cd ex
```
Create a directory for this exercise
```
mkdir  ex16
```
Check that the directory was created
```
ls
```

Copy the file to Unix

Open FileZilla and connect to users3.cs.umb.edu
You will have to connect using your Unix username and password.
Copy the file to the to it117/ex/ex16

Testing the script on Unix

Connect to users3.cs.umb.edu
Use an ssh client.
Go to the directory for this exercise
```
cd  it117/ex/ex16
```
Make this script executable
```
chmod  755 ex16.py
```
Copy the file umb.db from /home/ghoffman/course_files/it117_files
```
cp  /home/ghoffman/course_files/it117_files/umb.db   .
```
Run this script
```
./ex16.py
```

You should see something like

('09329034', 'Jane', 'Adams', 'Jane.Adams001@umb.edu', 'jadams', 'CSM')
('03687480', 'Alexander', 'Smith', 'Alexander.Smith001@umb.edu', 'bigboy', 'CM')
('05431692', 'Christopher', 'Cannon', 'Christopher.Cannon001@umb.edu', 'ccannon', 'CSM')
('07511379', 'Joseph', 'Malloney', 'Joseph.Malloney001@umb.edu', 'jmal', 'CSM')
('07518979', 'Fatih', 'Jones', 'Fatih.Jones001@umb.edu', 'fjones', 'CM')
('04175276', 'James', 'Reynolds', 'James.Reynolds001@umb.edu', 'jr', 'CSM')
('04686471', 'Joe', 'Riley', 'Joe.Reily003@umb.edu', 'reily', 'CM')
(1, 'it116', 1, 's17', '05431692')
(2, 'it116', 1, 's17', '09329034')
(3, 'it116', 1, 's17', '07518979')
(4, 'it244', 1, 's17', '07511379')
(5, 'it244', 1, 's17', '09329034')
(6, 'it244', 1, 's17', '04175276')
(7, 'it116', 1, 'sum17', '03687480')
(8, 'it116', 1, 'sum17', '07511379')
(9, 'it116', 1, 'sum17', '07518979')
(10, 'it117', 1, 'f17', '07518979')
(11, 'it117', 1, 'f17', '05431692')
(12, 'it117', 1, 'f17', '09329034')
(13, 'it244', 1, 'f17', '04686471')

Running my test script on your script

If you want to run my text script on your Class Exercise script do the following
Run ex16.sh on your script
```
~ghoffman/it117_test/ex16.sh
```
The script will prompt you for your Unix username.