Book Image

Python 3 Object Oriented Programming

By : Dusty Phillips
Book Image

Python 3 Object Oriented Programming

By: Dusty Phillips

Overview of this book

Object Oriented Programming is a very important aspect of modern programming languages. The basic principles of Object Oriented Programming are relatively easy to learn. Putting them together into working designs can be challenging.This book makes programming more of a pleasure than a chore using powerful Python 3 object-oriented features of Python 3. It clearly demonstrates the core OOP principles and how to correctly implement OOP in Python. Object Oriented Programming ranks high in importance among the many models Python supports. Yet, many programmers never bother learning the powerful features that make this language object oriented.The book teaches when and how OOP should be correctly applied. It emphasizes not only the simple syntax of OOP in Python, but also how to combine these objects into well-designed software.This book will introduce you to the terminology of the object-oriented paradigm, focusing on object-oriented design with step-by-step examples. It will take you from simple inheritance, one of the most useful tools in the object-oriented programmer's toolbox, all the way through to cooperative inheritance, one of the most complicated. You will be able to raise, handle, define, and manipulate exceptions.You will be able to integrate the object-oriented and the not-so-object-oriented aspects of Python. You will also be able to create maintainable applications by studying higher level design patterns. You'll learn the complexities of string and file manipulation, and how Python distinguishes between binary and textual data. Not one, but two very powerful automated testing systems will be introduced to you. You'll understand the joy of unit testing and just how easy they are to create. You'll even study higher level libraries such as database connectors and GUI toolkits and how they apply object-oriented principles.
Table of Contents (18 chapters)
Python 3 Object Oriented Programming
Credits
About the Author
About the Reviewers
Preface
Index

Database access


Talking to databases is a very common task in Python, especially in the web development world. Unfortunately, not many libraries for database access have been ported to Python 3 in a mature state. We'll be looking at a few of the available database solutions.

Python comes with built-in support for SQLite 3. We looked at some examples of it in earlier chapters. SQLite is not suitable for multi-user, multi-threaded access, but it's perfect for storing configuration or local data. It simply stores all the data in a single file and allows us to access that data using SQL syntax. All we need to do to use it is import sqlite3 and read the help file. Here's a short example to get you started:

import sqlite3
connection = sqlite3.connect("mydb.db")
connection.execute(
        "CREATE TABLE IF NOT EXISTS "
        "pet (type, breed, gender, name)")
connection.execute("INSERT INTO pet VALUES("
        "'dog', 'spaniel', 'female', 'Esme')")
connection.execute("INSERT INTO pet VALUES("...