SQLite3 Database Insert, Delete, Update, and Output functions - Ktinker Database Project Series #3!

Hi Guys

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.

Music by Royalty Free Music: ►Download ➜ https://cfmfreemusic.com/undefeated-hip-hop-beat-rap-instrumental/ Royalty Free Music | No Copyright Sounds | Undefeated - Hip Hop Beat Rap Instrumental

Youtube: https://youtu.be/nN_7ejdfnAI