Book Image

Python GUI Programming Cookbook

By : Burkhard Meier
Book Image

Python GUI Programming Cookbook

By: Burkhard Meier

Overview of this book

Related Content you might be interested in

Current Title:

Small book image
Python GUI Programming Cookbook
Burkhard Meier
Dec, 2015 | 350 pages
No titles found
Table of Contents (18 chapters)
Python GUI Programming Cookbook
Python GUI Programming Cookbook
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Creating the GUI Form and Adding Widgets
Creating the GUI Form and Adding Widgets
Introduction
Creating our first Python GUI
Preventing the GUI from being resized
Adding a label to the GUI form
Creating buttons and changing their text property
Text box widgets
Setting the focus to a widget and disabling widgets
Combo box widgets
Creating a check button with different initial states
Using radio button widgets
Using scrolled text widgets
Adding several widgets in a loop
2
Layout Management
Layout Management
Introduction
Arranging several labels within a label frame widget
Using padding to add space around widgets
How widgets dynamically expand the GUI
Aligning the GUI widgets by embedding frames within frames
Creating menu bars
Creating tabbed widgets
Using the grid layout manager
3
Look and Feel Customization
Look and Feel Customization
Introduction
Creating message boxes – information, warning, and error
How to create independent message boxes
How to create the title of a tkinter window form
Changing the icon of the main root window
Using a spin box control
Relief, sunken, and raised appearance of widgets
Creating tooltips using Python
How to use the canvas widget
4
Data and Classes
Data and Classes
Introduction
How to use StringVar()
How to get data from a widget
Using module-level global variables
How coding in classes can improve the GUI
Writing callback functions
Creating reusable GUI components
5
Matplotlib Charts
Matplotlib Charts
Introduction
Creating beautiful charts using Matplotlib
Matplotlib – downloading modules using pip
Matplotlib – downloading modules with whl extensions
Creating our first chart
Placing labels on charts
How to give the chart a legend
Scaling charts
Adjusting the scale of charts dynamically
6
Threads and Networking
Threads and Networking
Introduction
How to create multiple threads
Starting a thread
Stopping a thread
How to use queues
Passing queues among different modules
Using dialog widgets to copy files to your network
Using TCP/IP to communicate via networks
Using URLOpen to read data from websites
7
Storing Data in Our MySQL Database via Our GUI
Storing Data in Our MySQL Database via Our GUI
Introduction
Connecting to a MySQL database from Python
Configuring the MySQL connection
Designing the Python GUI database
Using the SQL INSERT command
Using the SQL UPDATE command
Using the SQL DELETE command
Storing and retrieving data from our MySQL database
8
Internationalization and Testing
Internationalization and Testing
Introduction
Displaying widget text in different languages
Changing the entire GUI language all at once
Localizing the GUI
Preparing the GUI for internationalization
How to design a GUI in an agile fashion
Do we need to test the GUI code?
Setting debug watches
Configuring different debug output levels
Creating self-testing code using Python's __main__ section
Creating robust GUIs using unit tests
How to write unit tests using the Eclipse PyDev IDE
9
Extending Our GUI with the wxPython Library
Extending Our GUI with the wxPython Library
Introduction
How to install the wxPython library
How to create our GUI in wxPython
Quickly adding controls using wxPython
Trying to embed a main wxPython app in a main tkinter app
Trying to embed our tkinter GUI code into wxPython
How to use Python to control two different GUI frameworks
How to communicate between the two connected GUIs
10
Creating Amazing 3D GUIs with PyOpenGL and PyGLet
Creating Amazing 3D GUIs with PyOpenGL and PyGLet
Introduction
PyOpenGL transforms our GUI
Our GUI in 3D!
Using bitmaps to make our GUI pretty
PyGLet transforms our GUI more easily than PyOpenGL
Our GUI in amazing colors
Creating a slideshow using tkinter
11
Best Practices
Best Practices
Introduction
Avoiding spaghetti code
Using __init__ to connect modules
Mixing fall-down and OOP coding
Using a code naming convention
When not to use OOP
How to use design patterns successfully
Avoiding complexity
Index
Index

Connecting to a MySQL database from Python

Before we can connect to a MySQL database, we have to connect to the MySQL server.

In order to do this, we need to know the IP address of the MySQL server as well as the port it is listening on.

We also have to be a registered user with a password in order to get authenticated by the MySQL server.

Getting ready

You will need to have access to a running MySQL server instance and you also need to have administrator privileges in order to create databases and tables.

There is a free MySQL Community Edition available from the official MySQL website. You can download and install it on your local PC from: http://dev.mysql.com/downloads/

Note

In this chapter, we are using MySQL Community Server (GPL) Release: 5.6.26.

How to do it…

In order to connect to MySQL, we first need to install a special Python connector driver. This driver will enable us to talk to the MySQL server from Python.

The driver is freely available on the MySQL website and comes with a very nice...

Previous Section
End of Section 3
Next Section