IT 117: Intermediate Scripting
Class 16

Today's Topics


New Material

Reading Assignment

In Chapter 10, Classes and Object-Oriented Programming, from our textbook, Starting Out with Python, you should read sections 10.1 and 10.2, Classes and Object-Oriented Programming and Procedural and Object-Oriented Programming, before next Tuesday's class.

Homework 7

I have posted homework 7 here.

It is due this Sunday, at 11:59 PM.

Quiz 4

I have posted the answers to Quiz 4 here.

Scoring the Mid-term

I will score the mid-term this weekend.

You will receive your scores by Monday.

Quiz Next Week

There will be a graded quiz next week.

It will cover material from today's class and Class 13.


Today we will be discussing how to use Python to access SQLite database.

I am doing this to show you how Python can be used with other sources of information.

In order to do this, I need to discuss some basic use of Structured Query Language (SQL).

This is not a database course, so you will not be required to remember this on the Final Exam.


Reusing Functions with Modules

Importing Modules

Dot Notation with Module Functions

New Material

Python as a Tool

Working with Data

Database Products


The SQLite Command Line

Database Structure

Data Checking




Changing Data in a Table

Adding a Record to a Table

Changing the Values in a Record

Deleting Records

Using SQLite in Python

Connecting to a SQLite Database

The SQLite Cursor Object

Running a SQLite Query in Python

Adding a Record Using SQLite

Committing Changes to a Table

Changing a Record Using SQLite

Deleting a Record Using SQLite

Writing Python Code to Work with SQLite

A Python Function to Add an Entry to the enrollment Table

Parameter Binding with sqlite3


Class Quiz