Python Backend script for Graphic User Interface (GUI) - SQL Functions
!!! - CREDITS: One of the Best Python Course on Udemy by Ardit Sulce: https://click.linksynergy.com/link?id... - Highly recommended!
This video is continue from my last Python video tutorial where I demonstrated how to create Graphic User Interface (GUI) - • Build Python Graphic User Interface (...
This is real world example how to design SQLite3 functions for Python application.
By this I try to answer to etudiant edutiand Youtube user.
In this video I demonstrate how to create functions for all GUI buttons (real world example). This is simple SQL type functions and requests to Python database.
For this purpose sqlite3 library is used.
After you create backend.py scripts, this script should be imported to frontend.py as a library (import backend). And then finally set these functions to buttons. This part is not demonstrated in this video but I hope I will create the video lessons for the last part of this Python project.
Python GUI buttons that SQL request are created for:
Add Entry (INSERT) : 4:05
View (SELECT * from book) : 5:14
Search (SELECT * from book WHERE ...) : 6:10
Delete selected (DELETE from book WHERE ...) : 7:48
Update selected (UPDATE book SET ...) : 8:46
Sorry for watermark in the video, for this time I used trial version of Camtasia...
Take a look how I converted another Tkinter GUI to Executable EXE file in Windows OS by Cx_Freeze Python module right here: • Tkinter GUI to EXE in Windows | Pytho...
Best regards
Vytautas
Watch video Python Backend script for Graphic User Interface (GUI) - SQL Functions online without registration, duration hours minute second in high quality. This video was added by user Data Science Garage 27 June 2017, don't forget to share it with your friends and acquaintances, it has been viewed on our site 22,266 once and liked it 324 people.