book

Python® Create-Modify-Reuse

Name: Python® Create-Modify-Reuse
Author: Jim Knowlton
ISBN: 9780470259320

by Jim Knowlton

July 2008

Intermediate to advanced

287 pages

4h 55m

English

Wrox

Read now

Unlock full access

Copyright
About the Author
Credits
Acknowledgments
Introduction
0.1. Who This Book Is For0.2. What This Book Covers0.3. How This Book Is Structured0.4. What You Need to Use This Book0.5. Source Code0.6. Errata0.7. p2p.wrox.com
1. A Python Primer
1.1. Getting Started1.1.1. Obtaining Python and Installing It1.1.2. The Python Interpreter1.1.3. Your Editing/Execution Environment1.2. Lexical Structure1.2.1. Keywords1.2.2. Lines and Indentation1.2.3. Data Types and Identifiers1.2.3.1. Data Types1.2.3.2. Identifiers1.3. Operators1.4. Expressions and Statements1.4.1. Expressions1.4.1.1. Operator Precedence in Expressions1.4.2. Statements1.4.2.1. Multi-line Statements1.5. Iteration and Decision-Making1.5.1. Iteration1.5.1.1. For Loops1.5.1.2. While Loops1.5.1.3. Break and Continue1.5.2. Decision-Making1.5.2.1. The if Statement1.6. Functions1.6.1.1.6.1.1. Defining a Function1.6.1.2. Calling a Function1.7. Modules1.7.1. Importing Modules1.7.1.1. Import1.7.1.2. Reload1.7.2. How Python Finds Modules to Load1.7.2.1. The Module Search Path1.7.2.2. Exploring sys.path1.8. Classes1.9. Summary
I. The Projects
2. Directory/File Snapshot Program
2.1. Using the Program2.1.1. Creating a Snapshot2.1.2. Listing Snapshot Files2.1.3. Comparing Snapshots2.1.4. Viewing Help2.1.5. Exiting the Program2.1.6. Putting It All Together2.1.6.1. Other Applications of the Program2.2. Design2.2.1. How It All Fits Together2.2.2. Main Program2.2.3. Modules2.2.3.1. snapshot Module2.2.3.2. snapshothelper Module2.3. Code and Code Explanation2.3.1. Snapshot.py2.3.1.1. Program Header2.3.1.2. Import Statements2.3.1.3. The Main Program2.3.1.4. The menu() Function2.3.2. snapshothelper.py2.3.2.1. createSnapshot(directory, filename)2.3.2.2. listSnapshot(extension)2.3.2.3. compareSnapshots(snapfile1, snapfile2)2.3.2.4. showHelp()2.3.2.5. invalidChoice()2.3.2.6. printList()2.4. Testing2.5. Modifying the Program2.6. Summary
3. DVD Inventory System
3.1. Using the Program3.1.1. Installing MySQL3.1.2. Adding a DVD to the Database3.1.2.1. When Problems Occur3.1.3. Searching the DVD Inventory3.1.3.1. Lookup by Movie Title3.1.3.2. Lookup by Star3.1.3.3. Lookup by Costar3.1.3.4. Lookup by Year Released3.1.3.5. Lookup by genre3.1.3.6. When Problems Occur3.1.4. Modifying a DVD Record3.1.4.1. Modify Title3.1.4.2. Modify Star3.1.4.3. Modify Costar3.1.4.4. Modify Year3.1.4.5. Modify Genre3.1.4.6. When Problems Occur3.1.5. Deleting a DVD Record3.1.5.1. When Problems Occur3.1.6. Exporting the List of DVDs to a CSV File3.2. Design3.2.1. How It All Fits Together3.2.2. Modules3.2.2.1. dvd.py3.2.2.2. add_dvd.py3.2.2.3. lookup_dvds.py3.2.2.4. modify_dvd.py3.2.2.5. delete_dvd.py3.2.2.6. csvreport_dvd.py3.3. Code and Code Explanation3.3.1. dvd.py3.3.1.1. The main() Function3.3.1.2. Menu()3.3.2. add_dvd.py3.3.2.1. AddDVD()3.3.2.2. SQLAddDVD(Title, Star, Costar, Year, Genre)3.3.3. lookup_dvds.py3.3.3.1. LookupDVD()3.3.3.2. SQLLookupDVD(searchby, searchtext)3.3.4. modify_dvd.py3.3.4.1. ModifyDVD()3.3.5. delete_dvd.py3.3.5.1. DeleteDVD()3.3.5.2. SQLDeleteDVD(dvdToDelete)3.3.6. csvreport_dvd.py3.3.6.1. WriteCSV()3.4. Testing3.5. Modifying the Program3.6. Summary
4. Web Performance Tester
4.1. Using the Program4.1.1. Running the Python Web Server4.1.1.1. When Problems Occur4.1.2. Running the Performance Profiler Client4.1.2.1. Testing Connection Performance to External Websites4.1.2.2. Testing Internal Web Server Performance4.1.2.3. Displaying the Log File4.1.2.4. When Problems Occur4.2. Design4.2.1. How It All Fits Together4.2.2. Modules4.2.2.1. webserver.py4.2.2.2. webperf.py4.2.2.3. webclient.py4.3. Code and Code Explanation4.3.1. webserver.py4.3.1.1. Main()4.3.1.2. RunServer()4.3.2. webperf.py4.3.2.1. Main()4.3.2.2. Menu()4.3.3. webclient.py4.3.3.1. CheckExternalSites(sites)4.3.3.2. CheckInternalWebServers(serverlist, port)4.3.3.3. Other Support Files4.4. Testing4.5. Modifying the Program4.6. Summary

5. Customer Follow-Up System
5.1. Using the Program5.1.1. Preliminaries5.1.1.1. Installing Apache5.1.1.2. Installing mod_python5.1.1.3. Configuring Apache for mod_python5.1.1.4. Copying Program Files into Their Proper Directories5.1.2. Running the Program5.1.2.1. Entering Comments at the Website5.1.2.2. When Problems Occur5.1.2.3. Viewing and Sorting the Log File5.2. Design5.2.1. How It All Fits Together5.2.2. Modules5.2.2.1. form.py5.3. Code and Code Explanation5.3.1. form.html5.3.2. form.py5.3.2.1. The email(req, name, phone, email, comment)5.3.2.2. writeCSVLog(name, phone, email, comment)5.4. Testing5.5. Modifying the Program5.6. Summary
6. Test Management/Reporting System
6.1. Using the Program6.1.1. Running Tests6.1.1.1. How Test Results Are Stored6.1.1.2. What If Some Tests Fail?6.1.2. Listing Test Runs6.1.3. Showing Test Results6.1.3.1. When Problems Occur6.1.4. Generating an HTML Test Report6.1.5. Examining the HTML File6.1.5.1. When Problems Occur6.1.6. Displaying Product Help6.2. Design6.2.1. Modules6.2.1.1. test_manager.py6.2.1.2. test_run.py6.2.1.3. test_list.py6.2.1.4. test_results.py6.2.1.5. test_html.py6.3. Code and Code Explanation6.3.1. test_manager.py6.3.1.1. Main Program6.3.1.2. menu()6.3.2. test_run.py6.3.2.1. test_firstname(fname)6.3.2.2. test_lastname(lname)6.3.2.3. test_prime_number()6.3.2.4. run_tests()6.3.2.5. testcount()6.3.3. test_list.py6.3.3.1. list_tests()6.3.4. test_results.py6.3.4.1. show_test_results()6.3.5. test_html.py6.3.5.1. test_html_report ()6.4. Testing6.5. Modifying the Program6.6. Summary6.6.1. More About the Minidom Module
7. Version Management System
7.1. Using the Program7.1.1. Setting Up Remote Computers7.1.2. Running the Program — Command-Line Syntax7.1.2.1. Command-Line Examples7.1.2.2. Viewing the CSV Log File7.1.2.3. Running Against Several Different Machines in Batch Mode7.2. Design7.2.1. Modules7.2.1.1. version_checker.py7.2.1.2. check_versions.py7.2.1.3. csv_report.py7.3. Code and Code Explanation7.3.1. version_checker.py7.3.1.1. Main Program7.3.1.2. check_arguments()7.3.1.3. get_versions()7.3.2. check_versions.py7.3.2.1. check_java()7.3.2.2. check_python()7.3.2.3. check_perl()7.3.3. csv_report.py7.3.3.1. write_csv_log()7.4. Testing7.5. Modifying the Program7.5.1. Security Considerations7.6. Summary
8. Content Management System
8.1. Plone Overview8.1.1. What Is Plone?8.2. Installing and Configuring Plone8.2.1. Downloading Plone8.2.2. Extracting the Plone Install8.2.3. Running the Plone Install8.2.4. Starting Plone8.2.5. Discovering the Admin User Password8.2.6. Logging In as the Admin User8.2.7. Setting Up the E-mail Server8.2.8. Setting Up a User8.2.9. Logging In as the Set-Up User8.3. Design8.4. Navigation8.5. Content Management8.5.1. Creating a Page8.5.2. Creating a Collection8.6. User Permissions8.7. Summary
II. Advanced Topics
9. Interacting with the Operating System
9.1. Generic Operating System Services9.1.1. The os Module — Generic OS Services9.1.1.1. Examples9.1.1.1.1. Example 19.1.1.1.2. Example 29.1.2. The time Module — Format and Manipulate System Time9.1.2.1. Examples9.1.2.1.1. Example 19.1.2.1.2. Example 29.1.3. The optparse Module — Parse Command-Line Options9.1.3.1. Example9.1.4. The platform Module — Get Platform Information9.1.4.1. Example9.1.5. The getpass Module — Generate and Check Passwords9.1.5.1. Example9.1.6. Some Other Things You Can Do9.2. Accessing Windows Services9.2.1. The winreg Module — Manipulate the Windows Registry9.2.1.1. Example9.2.2. The winsound Module9.2.2.1. Example9.2.3. The win32serviceutil Module — Manage Windows Services9.2.3.1. Example9.2.4. The win32net Module — Access Windows Networking Features9.2.4.1. Example9.2.5. Some Other Things You Can Do9.3. Accessing Unix/Linux Services9.3.1. The termios Module — Access Unix-Style TTY Interface9.3.1.1. Example9.3.2. The resource Module — Manage Unix System Resources9.3.2.1. Example9.3.3. The syslog Module — Access the Unix syslog9.3.3.1. Example9.3.4. The commands Module — Run Commands and Get Output9.3.4.1. Example9.3.5. Some Other Things You Can Do9.4. Summary
10. Debugging and Testing
10.1. The Python Debugger10.1.1. Running the Debugger10.1.1.1. Importing the pdb Module Directly10.1.1.2. Accessing the Python Debugger through IDLE10.1.1.3. The Debug Control window10.1.1.4. Example10.2. Python Test Frameworks10.2.1. Why We Test10.2.2. Unit Testing10.2.2.1. Manual Unit Testing with the Python Interactive Interpreter10.2.2.2. unittest — Python's Default Unit Test Framework10.2.2.2.1. Example10.2.2.2.2. Running the Tests10.2.2.3. doctest — a Compelling Alternative10.2.2.3.1. Example 110.2.2.3.2. Example 210.3. Summary10.4. Final Remarks
A. Where to Go From Here — Resources That Can Help
A.1. BooksA.2. Websites and Blogs
B. Installing Supplemental Programs
B.1. Installing MySQLB.1.1. Downloading the MySQL Community ServerB.1.2. Running the InstallB.1.3. Configuring the MySQL ServerB.2. Installing Win32AllB.2.1. Downloading the Win32All PackageB.2.2. Running the Install

Content preview from Python® Create-Modify-Reuse

Chapter 3. DVD Inventory System

There is a well-known saying that there are two types of programs: those that are toys and those that access databases. Well, the project in this chapter is not a toy, so that should narrow it down for you. This project will enable you to manage your DVD inventory. It takes advantage of MySQL, a powerful open-source relational database management system (RDMS). Along the way, you'll learn how to do the following:

Work with a database
Connect to a database
Query the database
Add records
Modify records
Delete records
Output information in the database to a CSV file

Why All This Is Important

Basically, when you get right down to it, all a computer does is organize and manipulate chunks of data. Displaying a bitmap? Moving data around. Printing a spreadsheet? Sending bits of data from one location to another. Computers are most meaningful when they are able to sort and arrange that data in a way that aids the imperfect carbon-based life forms who operate them — namely, you and me.

This is where database management systems come in. They take the sets of data that you and I deal with all around us (sports statistics, medicine prescriptions, class rosters, military formations, whatever) and they arrange it in a way that makes sense to us.

In other words, understanding how to use databases is one of the most fundamental things you can learn as a developer.

Using the Program

The program is available for download at www.wrox.com. To run it, simply go to a command prompt, ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 9780470259320Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Python® Create-Modify-Reuse

by Jim Knowlton

Chapter 3. DVD Inventory System

Using the Program

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.