delete button flask with sqlite3

#1
sorin86

Posted 09 February 2018 - 12:35

Member

Grup: Members
Posts: 797
Înscris: 16.12.2012

Salut,

Ma confrunt de 3 zile cu un buton de delete in flask si nu pot sa ii dau de cap, ori sunt batut in cap.. sigur a doua varianta.

Imi da eroarea asta :

Quote

NameError: global name 'entry_id' is not defined
Traceback (most recent call last)

@app.route('/delete')
def delete_entry():
con = sql.connect("database.db")
con.row_factory = sql.Row
cur = con.cursor()
cur.execute("delete from students where id=?", (entry_id,) )

rows = cur.fetchall();
return render_template("list.html",rows = rows)

<!doctype html>
<html>
<body>
	 <table border = 1>
		 <thead>
		 <td><b>ID</b></td>
		 <td><b>Name</b></td>
		 <td><b>Address</b></td>
		 <td><b>City</b></td>
		 <td><b>Pincode</b></td>
		 <td><b>Delete</b></td>
		 </thead>
		 {% for row in rows %}
		 <tr>
			 <td>{{row["id"]}}</td>
			 <td>{{row["name"]}}</td>
			 <td>{{row["addr"]}}</td>
			 <td> {{row["city"]}}</td>
			 <td>{{row["pin"]}}</td>
<td>		 <a href="{{ url_for('delete_entry', entry_id=row['id'] )}}">Delete</a>
</td>
{% endfor %}
	 </table>
	 <a href = "/">Go back to home page</a>
</body>
</html>

Cum ar trebui sa definesc acel "entry_id" ?

Multumesc

Back to top

#2
Baggins

Posted 09 February 2018 - 13:19

Member

Grup: Members
Posts: 264
Înscris: 09.10.2014

Cu un int/string.

Back to top

#3
sorin86

Posted 09 February 2018 - 13:27

Member

Grup: Members
Posts: 797
Înscris: 16.12.2012

Am incercat toate posibilitatile ..str..int.. nimic nu merge.

Back to top

#4
Baggins

Posted 09 February 2018 - 14:04

Member

Grup: Members
Posts: 264
Înscris: 09.10.2014

Păi cine e entry_id ăla?
De unde vine?
De asemenea, codul python se indentează.

Back to top

#5
sorin86

Posted 09 February 2018 - 15:00

Member

Grup: Members
Posts: 797
Înscris: 16.12.2012

Salut,

entry_id este folosit aici :

<a href="{{ url_for('delete_entry', entry_id=row['id'] )}}">Delete</a>

Back to top

#6
Sky_Way

Posted 11 February 2018 - 12:01

Member

Grup: Members
Posts: 350
Înscris: 25.04.2008

In Python, la funcție nu v�d nic�ieri definirea lui entry_id. Funcția ta nu accept� argumente, deci ce s� �nțeleag� prin entry_id?

Back to top

#7
sorin86

Posted 12 February 2018 - 14:16

Member

Grup: Members
Posts: 797
Înscris: 16.12.2012

1. Se pare ca acel entry_id se trimite ok de la list.html to views.py, dar nu sterge din baza de date.. nu ia in considerare acel query.

table.PNG 6.91K 8 downloads

views.py

@app.route('/delete/<int:[b]entry_id[/b]>')
def delete_entry(entry_id):

return ('Postid %d was deleted.' %(entry_id))

list.html


<a href="{{ url_for('delete_entry', entry_id=row['id'] )}}">Delete</a>

Output result:

post1.PNG 4.48K 6 downloads

post2.PNG 4.58K 3 downloads

Back to top

#8
sorin86

Posted 12 February 2018 - 15:54

Member

Grup: Members
Posts: 797
Înscris: 16.12.2012

Am reusit ..sper sa ajute pe cineva:

@app.route('/delete/<int:entry_id>')
def delete_entry(entry_id):
con = sql.connect("database.db")
con.row_factory = sql.Row
cur = con.cursor()
entry_id=int(entry_id)
cur.execute("delete from students where id=?", (entry_id,))
con.commit()
rows = cur.fetchone();
return redirect("http://0.0.0.0:4000/list")

Edited by sorin86, 12 February 2018 - 15:59.

Back to top

#9
georgica

Posted 23 February 2018 - 09:08

Active Member

Grup: Members
Posts: 1,487
Înscris: 30.01.2003

Să vezi fericire maximă când te indexează google și n-o sa mai fie nici un student în db.

Regulă: cu GET se fac doar cereri care nu au efect asupra sistemului, sînt doar de citire informații. Orice modificare a sistemul se face prin POST (sau PUT, PATCH, DELETE).

Back to top

#10
sorin86

Posted 23 February 2018 - 10:02

Member

Grup: Members
Posts: 797
Înscris: 16.12.2012

"Să vezi fericire maximă când te indexează google și n-o sa mai fie nici un student în db." nu am inteles partea asta

))

Back to top

#11
Sky_Way

Posted 03 March 2018 - 12:06

Member

Grup: Members
Posts: 350
Înscris: 25.04.2008

Probabil se refer� c� ar fi bine s� nu aib� oricine acces la webserverul t�u. Poate un .htaccess nu ar strica, ca s� previi treburile astea

Back to top

#12
dani.user

Posted 03 March 2018 - 12:12

Guru Member

Grup: Senior Members
Posts: 30,254
Înscris: 24.02.2007

GET e pentru citit informatii, nu pentru efectuari de schimbari asupra lor.

Motoarele de indexare, cand iti viziteaza site-ul, se plimba prin toate linkurile ce le gasesc. In cazul asta, vor "apasa" delete pe tot ce prind, lucru ce n-ar fi de dorit.

Edited by dani.user, 03 March 2018 - 12:14.

Back to top

Anunturi

Bun venit pe Forumul Softpedia!

delete button flask with sqlite3

#1 sorin86 Posted 09 February 2018 - 12:35

#2 Baggins Posted 09 February 2018 - 13:19

#3 sorin86 Posted 09 February 2018 - 13:27

#4 Baggins Posted 09 February 2018 - 14:04

#5 sorin86 Posted 09 February 2018 - 15:00

#6 Sky_Way Posted 11 February 2018 - 12:01

#7 sorin86 Posted 12 February 2018 - 14:16

#8 sorin86 Posted 12 February 2018 - 15:54

#9 georgica Posted 23 February 2018 - 09:08

#10 sorin86 Posted 23 February 2018 - 10:02

#11 Sky_Way Posted 03 March 2018 - 12:06

#12 dani.user Posted 03 March 2018 - 12:12

Anunturi

▶ 0 user(s) are reading this topic

Sign In

#1
sorin86

Posted 09 February 2018 - 12:35

#2
Baggins

Posted 09 February 2018 - 13:19

#3
sorin86

Posted 09 February 2018 - 13:27

#4
Baggins

Posted 09 February 2018 - 14:04

#5
sorin86

Posted 09 February 2018 - 15:00

#6
Sky_Way

Posted 11 February 2018 - 12:01

#7
sorin86

Posted 12 February 2018 - 14:16

#8
sorin86

Posted 12 February 2018 - 15:54

#9
georgica

Posted 23 February 2018 - 09:08

#10
sorin86

Posted 23 February 2018 - 10:02

#11
Sky_Way

Posted 03 March 2018 - 12:06

#12
dani.user

Posted 03 March 2018 - 12:12