[chronojump-server] Updated howtos
- From: Xavier de Blas <xaviblas src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [chronojump-server] Updated howtos
- Date: Fri, 23 Feb 2018 13:30:50 +0000 (UTC)
commit 489051fb687b2866c76612d56bc0377ea25a9d0a
Author: Xavier de Blas <xaviblas gmail com>
Date: Fri Feb 23 14:30:18 2018 +0100
Updated howtos
howto_compujump_server.txt | 33 ++++++++++++++++++++++++++++++---
tables.txt | 9 +++++++++
2 files changed, 39 insertions(+), 3 deletions(-)
---
diff --git a/howto_compujump_server.txt b/howto_compujump_server.txt
index 81f6821..f11db1f 100644
--- a/howto_compujump_server.txt
+++ b/howto_compujump_server.txt
@@ -115,9 +115,9 @@ NO: /srv/api-app/chronojump-flask$ . venv/bin/activate
FLASK_APP="chronojumpserver" /srv/api-app/venv/bin/flask run --host 0.0.0.0
-/srv/api-app$ virtualenv venv
-/srv/api-app$ source venv/bin/activate
-pip install -e .
+/srv/api-app$ virtualenv venv #create venv
+/srv/api-app$ source venv/bin/activate #activates (get into) venv
+pip install -e . #install stuff if requirements.txt changed
copy logo_club.png to /srv/api-app/chronojumpserver/static/images
@@ -150,3 +150,30 @@ copy services/flask.service to /etc/systemd/system/
# apt-get install mono-mcs
cd /srv/api-app/chronojumpserver/rfid-csharp
mono RFID.cs
+
+--------------------------------
+5. Update code
+--------------------------------
+
+/srv/api-app$ virtualenv venv #create venv
+/srv/api-app$ source venv/bin/activate #activates (get into) venv
+pip install -e . #install stuff if requirements.txt changed
+
+SQL stuff recents
+-------------------
+insert into user(username, password, user_type) values ('myuser', MD5('mypass'), 'admin');
+alter table person add org_id int(11) DEFAULT null;
+alter table task add column lossBySpeed int(11) DEFAULT null;
+alter table task add column lossByPower int(11) DEFAULT null;
+ALTER TABLE STATION ADD COLUMN gym_id INT not null default 1;
+
+#potser no calen:
+alter table `group` rename group_;
+alter table resultSprint add column t1 float
+alter table resultSprint add column t2 float
+alter table resultSprint add column t3 float
+alter table resultSprint add column t4 float
+alter table resultSprint drop column times;
+
+
+
diff --git a/tables.txt b/tables.txt
index fc59518..779ddfe 100644
--- a/tables.txt
+++ b/tables.txt
@@ -52,3 +52,12 @@ INSERT INTO results VALUES(NULL, NULL, 1, 2, "press de banca", 45.2 , 9,
#INSERT INTO results VALUES(NULL, NULL, 1, 1, 2, "sprint", NULL, NULL, "5 segons");
#INSERT INTO task VALUES(NULL, NULL, 1, "Mig squat amb 45 Kg, 3 series de 8 repeticions a 1,1 m/s.
Desplaçaments laterals amb la inercial de 800 W");
+
+#Afegir lossByPower i lossBySpeed:
+alter table task add column lossBySpeed int(11) DEFAULT null;
+alter table task add column lossByPower int(11) DEFAULT null;
+
+#canvis de player i de group (revisar)
+alter table `group` rename group_;
+alter table person add org_id int(11) DEFAULT null;
+ALTER TABLE station ADD COLUMN gym_id INT not null default 1;
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]