[chronojump-server] Before adding a person, it checks if RFID exists
- From: Xavier de Blas <xaviblas src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [chronojump-server] Before adding a person, it checks if RFID exists
- Date: Mon, 8 May 2017 19:10:59 +0000 (UTC)
commit 0420c1243b95426c1e8c882c1da856d64f600bf2
Author: Xavier de Blas <xaviblas gmail com>
Date: Mon May 8 21:10:27 2017 +0200
Before adding a person, it checks if RFID exists
chronojump-flask/chronojump_server.py | 11 ++++++++++-
1 files changed, 10 insertions(+), 1 deletions(-)
---
diff --git a/chronojump-flask/chronojump_server.py b/chronojump-flask/chronojump_server.py
index ed8ecda..1864e56 100644
--- a/chronojump-flask/chronojump_server.py
+++ b/chronojump-flask/chronojump_server.py
@@ -122,7 +122,16 @@ def player_add_submit():
added=False, msg = "No s'ha detectat el RFID", name=name, weight=weight, rfid=rfid)
- #4 insert person and show success
+ #4 check if RFID exists
+ cursor.execute("SELECT * FROM person WHERE rfid = '" + rfid + "'");
+ rows = cursor.fetchall()
+ if rows:
+ msg = "Error, ja existeix el rfid: " + rfid
+ return render_template("player_add_result.html", header = getHeader("Afegir jugador"),
+ added=False, msg = msg, name=name, weight=weight, rfid=rfid)
+
+
+ #5 insert person and show success
cursor.execute("INSERT INTO person (name,weight,rfid) VALUES (" +
"'" + name + "', " + str(weight) + ", '" + rfid + "')")
db.commit()
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]