Misiu
Punchline Warrior
LEVEL 1
200 XP
In this tutorial we will create a Simple CRUD ( Update, Delete) Application using Python/SQLite. In my previous tutorial we already tackle the create and read on Python Simple CRUD, this time we will continue on and add some features to make the application fully functional. Before we proceed make sure you already read the previous tutorial Python: Simple CRUD Application Using SQLite - Part 1 for resources to this tutorial, because I will only add some features from the previous tutorials. So let's now do the coding.
Getting started
First you will have to download & install the Python IDLE's, here's the link for the Integrated Development And Learning Environment for Python https://www.python.org/downloads/.
Installing SQLite Browser
After you installed Python, we will now then install the SQLite, here's the link for the DB Browser for SQLite http://sqlitebrowser.org/.
Adding an event to List Widget
This code will bind the list view to trigger an event called OnSelected when the list is clicked twice. Just simple remove the previous code from the LIST WIDGET then copy the code below and paste it.
Fixing the Button
Simple add the syntax inside the Button widget, then remove the state=DISABLED from the btn_delete.
Creating the Delete Function
This where the code will delete the highlighted list item from the list view when the button delete is clicked. Copy the code below and paste it inside the IDLE text editor
Creating the Update Function.
This is where code will display the data into the Entry widget when the list item is double clicked simultaneously, then will update the data from the database when the button edit is clicked. To do that just simply copy the code below then paste it inside the IDLE text editor.
There you have it we successfully completed the Simple CRUD Application in Python. I hope that this simple tutorial help you for what you are looking for. For more updates and tutorials just simply visit this site. Enjoy Coding!!
Download
Getting started
First you will have to download & install the Python IDLE's, here's the link for the Integrated Development And Learning Environment for Python https://www.python.org/downloads/.
Installing SQLite Browser
After you installed Python, we will now then install the SQLite, here's the link for the DB Browser for SQLite http://sqlitebrowser.org/.
Adding an event to List Widget
This code will bind the list view to trigger an event called OnSelected when the list is clicked twice. Just simple remove the previous code from the LIST WIDGET then copy the code below and paste it.
- scrollbary =
Scrollbar(
Right,
orient=
VERTICAL)
- scrollbarx =
Scrollbar(
Right,
orient=
HORIZONTAL)
- tree =
ttk.Treeview
(
Right,
columns=
(
"MemberID"
,
"Firstname"
,
"Lastname"
,
"Gender"
,
"Address"
,
"Username"
,
"Password"
)
,
selectmode=
"extended"
,
height=
500
,
yscrollcommand=
scrollbary.set
,
xscrollcommand=
scrollbarx.set
)
- scrollbary.config
(
command=
tree.yview
)
- scrollbary.pack
(
side=
RIGHT,
fill=
Y)
- scrollbarx.config
(
command=
tree.xview
)
- scrollbarx.pack
(
side=
BOTTOM,
fill=
X)
- tree.heading
(
'MemberID'
,
text=
"MemberID"
,
anchor=
W)
- tree.heading
(
'Firstname'
,
text=
"Firstname"
,
anchor=
W)
- tree.heading
(
'Lastname'
,
text=
"Lastname"
,
anchor=
W)
- tree.heading
(
'Gender'
,
text=
"Gender"
,
anchor=
W)
- tree.heading
(
'Address'
,
text=
"Address"
,
anchor=
W)
- tree.heading
(
'Username'
,
text=
"Username"
,
anchor=
W)
- tree.heading
(
'Password'
,
text=
"Password"
,
anchor=
W)
- tree.column
(
'#0'
,
stretch=
NO,
minwidth=
0
,
width=
0
)
- tree.column
(
'#1'
,
stretch=
NO,
minwidth=
0
,
width=
0
)
- tree.column
(
'#2'
,
stretch=
NO,
minwidth=
0
,
width=
80
)
- tree.column
(
'#3'
,
stretch=
NO,
minwidth=
0
,
width=
120
)
- tree.column
(
'#4'
,
stretch=
NO,
minwidth=
0
,
width=
80
)
- tree.column
(
'#5'
,
stretch=
NO,
minwidth=
0
,
width=
150
)
- tree.column
(
'#6'
,
stretch=
NO,
minwidth=
0
,
width=
120
)
- tree.column
(
'#7'
,
stretch=
NO,
minwidth=
0
,
width=
120
)
- tree.pack
(
)
- tree.bind
(
'<Double-Button-1>'
,
OnSelected)
Fixing the Button
Simple add the syntax inside the Button widget, then remove the state=DISABLED from the btn_delete.
- btn_update =
Button(
Buttons,
width=
10
,
text=
"Update"
,
command=
Update,
state=
DISABLED)
- btn_update.pack
(
side=
LEFT)
- btn_delete =
Button(
Buttons,
width=
10
,
text=
"Delete"
,
command=
Delete)
- btn_delete.pack
(
side=
LEFT)
Creating the Delete Function
This where the code will delete the highlighted list item from the list view when the button delete is clicked. Copy the code below and paste it inside the IDLE text editor
- def
Delete(
)
:
- if
not
tree.selection
(
)
:
- txt_result.config
(
text=
"Please select an item first"
,
fg=
"red"
)
- else
:
- result =
tkMessageBox.askquestion
(
'Python: Simple CRUD Applition'
,
'Are you sure you want to delete this record?'
,
icon=
"warning"
)
- if
result ==
'yes'
:
- curItem =
tree.focus
(
)
- contents =
(
tree.item
(
curItem)
)
- selecteditem =
contents[
'values'
]
- tree.delete
(
curItem)
- Database(
)
- cursor.execute
(
"DELETE FROM `member` WHERE `mem_id` = %d"
% selecteditem[
0
]
)
- conn.commit
(
)
- cursor.close
(
)
- conn.close
(
)
- txt_result.config
(
text=
"Successfully deleted the data"
,
fg=
"black"
)
Creating the Update Function.
This is where code will display the data into the Entry widget when the list item is double clicked simultaneously, then will update the data from the database when the button edit is clicked. To do that just simply copy the code below then paste it inside the IDLE text editor.
- def
Update(
)
:
- Database(
)
- if
GENDER.get
(
)
==
""
:
- txt_result.config
(
text=
"Please select a gender"
,
fg=
"red"
)
- else
:
- tree.delete
(
*tree.get_children
(
)
)
- cursor.execute
(
"UPDATE `member` SET `firstname` = ?, `lastname` = ?, `gender` =?, `address` = ?, `username` = ?, `password` = ? WHERE `mem_id` = ?"
,
(
str
(
FIRSTNAME.get
(
)
)
,
str
(
LASTNAME.get
(
)
)
,
str
(
GENDER.get
(
)
)
,
str
(
ADDRESS.get
(
)
)
,
str
(
USERNAME.get
(
)
)
,
str
(
PASSWORD.get
(
)
)
,
int
(
mem_id)
)
)
- conn.commit
(
)
- cursor.execute
(
"SELECT * FROM `member` ORDER BY `lastname` ASC"
)
- fetch =
cursor.fetchall
(
)
- for
data in
fetch:
- tree.insert
(
''
,
'end'
,
values=
(
data[
0
]
,
data[
1
]
,
data[
2
]
,
data[
3
]
,
data[
4
]
,
data[
5
]
,
data[
6
]
)
)
- cursor.close
(
)
- conn.close
(
)
- FIRSTNAME.set
(
""
)
- LASTNAME.set
(
""
)
- GENDER.set
(
""
)
- ADDRESS.set
(
""
)
- USERNAME.set
(
""
)
- PASSWORD.set
(
""
)
- btn_create.config
(
state=
NORMAL)
- btn_read.config
(
state=
NORMAL)
- btn_update.config
(
state=
DISABLED)
- btn_delete.config
(
state=
NORMAL)
- txt_result.config
(
text=
"Successfully updated the data"
,
fg=
"black"
)
- def
OnSelected(
event)
:
- global
mem_id;
- curItem =
tree.focus
(
)
- contents =
(
tree.item
(
curItem)
)
- selecteditem =
contents[
'values'
]
- mem_id =
selecteditem[
0
]
- FIRSTNAME.set
(
""
)
- LASTNAME.set
(
""
)
- GENDER.set
(
""
)
- ADDRESS.set
(
""
)
- USERNAME.set
(
""
)
- PASSWORD.set
(
""
)
- FIRSTNAME.set
(
selecteditem[
1
]
)
- LASTNAME.set
(
selecteditem[
2
]
)
- ADDRESS.set
(
selecteditem[
4
]
)
- USERNAME.set
(
selecteditem[
5
]
)
- PASSWORD.set
(
selecteditem[
6
]
)
- btn_create.config
(
state=
DISABLED)
- btn_read.config
(
state=
DISABLED)
- btn_update.config
(
state=
NORMAL)
- btn_delete.config
(
state=
DISABLED)
There you have it we successfully completed the Simple CRUD Application in Python. I hope that this simple tutorial help you for what you are looking for. For more updates and tutorials just simply visit this site. Enjoy Coding!!
Download
You must upgrade your account or reply in the thread to view the hidden content.