SMTL

commit d99157785ce8e6b0c6e68dc7105e98ff24fdff2f
parent c0203bcfacfaae40d215598ae25a7b5258b55150
Author: Oshgnacknak <osh@oshgnacknak.de>
Date:   Sat,  3 Aug 2019 18:28:58 +0100

mysql support + fix player list

Diffstat:
M
config.py.dist
 | 
11
+++++++++--
M
requirements.txt
 | 
1
+
M
smtl/routes/api.py
 | 
4
++--
M
smtl/templates/player_table.html
 | 
4
++--

4 files changed, 14 insertions(+), 6 deletions(-)
diff --git a/config.py.dist b/config.py.dist
@@ -8,10 +8,17 @@ meta = {
     "author": "SK Langen e.V."
 }
 
-
 app_config = {
     'SECRET_KEY': 'some_key',
-    'SQLALCHEMY_DATABASE_URI': 'sqlite:///../database.db',
+
+      # db uri
+      # memory
+      'SQLALCHEMY_DATABASE_URI': 'sqlite:///:memory:',
+      # sqlite
+      #app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///../db.db'
+      # mysql
+      #app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql+pymysql://username:password@server.site.com/database'
+
     'RECAPTCHA_PUBLIC_KEY': 'some_other_key',
     'RECAPTCHA_PRIVATE_KEY': 'some_otherer_key'
 }
diff --git a/requirements.txt b/requirements.txt
@@ -3,3 +3,4 @@ wtforms
 flask_wtf
 flask-sqlalchemy
 flask_caching
+pymysql
diff --git a/smtl/routes/api.py b/smtl/routes/api.py
@@ -19,7 +19,7 @@ def add_player():
             form_errors=form.errors
         )
     try:
-        p = add_player(form)
+        p = save_player(form)
         logger.info(request.remote_addr + ' added ' + str(p))
         return jsonify(status='success', message=f'{p.name} wurde hinzugefügt.')
     except SQLAlchemyError as e:
@@ -27,7 +27,7 @@ def add_player():
         return jsonify(status='error', message='Database Error!'), 500
 
 
-def add_player(form):
+def save_player(form):
     p = Player(
         name=form.data['name'],
         gender=Gender[form.data['gender']],
diff --git a/smtl/templates/player_table.html b/smtl/templates/player_table.html
@@ -17,7 +17,7 @@
       attr: (a, b) => a.attr < b.attr
     }
 
-    const table = getElementById('player_table');
+    const table = document.getElementById('player_table');
     let players;
 
     function render() {
@@ -28,7 +28,7 @@
         const tr = document.createElement('tr');
         tr.classList.add("data");
         ['name', 'club', 'dwz', 'attr'].forEach(k =>
-          td.innerHTML += `<td>${p[k]}</td>\n`);
+          tr.innerHTML += `<td>${p[k]}</td>\n`);
         table.appendChild(tr);
       });
     }