Today I am back with a new video for the Python SQLite3 Database project with Ktinker GUI. Also I switched my video editor recently since my old one started giving me errors, I am now using Kdenlive, so let me know in the comments if you gu…
Today I am back with a new video for the Python SQLite3 Database project with Ktinker GUI. Also I switched my video editor recently since my old one started giving me errors, I am now using Kdenlive, so let me know in the comments if you guys have noticed any difference in video quality!
This time, I have added new functions which help organize my code into specific sections, where I can place specific methods in order to interact with the database from a second script.
I have created a createdatabase function which does what I already covered in my last video, it creates a database if one is not already present.
I have also create a delete function to remove items from the database table, an insert function, which has the insert item to table code from the last video placed within it; and also an update function with can edit or modify items in our table without having to insert or delete items from the table.
Also I have made these functions such that they store the changes they have made temporarily to 4 global variables in the main.py script. In addition, I have also created a new data column for storing the rowid for each item in the table, in order for me to better track it in the script.
Lastly, I have created a showtable function and Query function, both do the same thing which is output the data stored within the tables. The Query function will be modified later to interact as a interface for the GUI script which I will make in the next video, where as the showtable function is currently only there for debugging.