Python Backend script for Graphic User Interface (GUI) - SQL Functions HD
This video is continue from my last Python video tutorial where I demonstrated how to create Graphic User Interface (GUI) - https://www.youtube.com/watch?v=ddoPYppcppc&t=1s 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... Best regards Vytautas