In this recipe, we imported the Python module we wrote that contains all of the coding logic to connect to our MySQL database and knows how to insert, update, and delete data.
We have now connected our Python GUI to this SQL logic.
- Credits
- Preface
- 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
- Layout Management
- 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
- Adding a progressbar to the GUI
- How to use the canvas widget
- Data and Classes
- Matplotlib Charts
- Threads and Networking
- Storing Data in our MySQL Database via our GUI
- Introduction
- Installing and connecting to a MySQL server from Python
- Configuring the MySQL database 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
- Using the MySQL workbench
- 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
- Extending Our GUI with the wxPython Library
- Introduction
- Installing the wxPython library
- Creating 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
- Using Python to control two different GUI frameworks
- Communicating between the two connected GUIs
- Creating Amazing 3D GUIs with PyOpenGL and PyGLet
- Best Practices
How it works...
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.