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

Publicado em: 06 Maio 2020
no canal de: Hedia

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

Nesta página do site você pode assistir ao vídeo on-line SQLite3 Database Insert, Delete, Update, and Output functions - Ktinker Database Project Series #3! duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Hedia 06 Maio 2020, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 83 vezes e gostou 1 espectadores. Boa visualização!

5,147

474