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

Subscribe: https://www.youtube.com/c/VytautasBielinskas/featured

#python #sql