Python Backend script for Graphic User Interface (GUI) - SQL Functions

Опубликовано: 27 Июнь 2017
на канале: Data Science Garage
22,266
324

!!! - 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


Смотрите видео Python Backend script for Graphic User Interface (GUI) - SQL Functions онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Data Science Garage 27 Июнь 2017, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 22,266 раз и оно понравилось 324 людям.