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-h...
Royalty Free Music | No Copyright Sounds | Undefeated - Hip Hop Beat Rap Instrumental
On this page of the site you can watch the video online SQLite3 Database Insert, Delete, Update, and Output functions - Ktinker Database Project Series #3! with a duration of hours minute second in good quality, which was uploaded by the user Hedia 06 May 2020, share the link with friends and acquaintances, this video has already been watched 83 times on youtube and it was liked by 1 viewers. Enjoy your viewing!
