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
En esta página del sitio puede ver el video en línea Python Backend script for Graphic User Interface (GUI) - SQL Functions de Duración hora minuto segunda en buena calidad , que subió el usuario Data Science Garage 27 junio 2017, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 22,266 veces y le gustó 324 a los espectadores. Disfruta viendo!
