[chronojump-server] Before adding a person, it checks if RFID exists

[Xavier de Blas <xaviblas src gnome org>]

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()