www

commit 3844a80c15638c99430f49a17dd5c96125280469
parent 68be416ce0cb1084d109827ea33383d3cbe79356
Author: Georges Dupéron <jahvascriptmaniac+github@free.fr>
Date:   Sat, 12 Feb 2011 15:36:32 +0100

Automatisation de la régénération de la BDD.

Diffstat:
M
code/serveur/README
 | 
14
++++++++++++--
M
code/serveur/dump.url
 | 
2
+-
M
code/serveur/dump2sqlite.sh
 | 
20
++++++++++----------

3 files changed, 23 insertions(+), 13 deletions(-)
diff --git a/code/serveur/README b/code/serveur/README
@@ -1,6 +1,16 @@
-cat dump.url
+#!/bin/sh
+
+# cat dump.url
 # Aller à cette adresse, et télécharger le dernier dump
+echo "Étape 1/3 : Téléchargement"
+wget 'http://www.lirmm.fr/~lafourcade/JDM-LEXICALNET-FR/02122011-LEXICALNET-JEUXDEMOTS-FR-NOHTML.txt'
+
+echo "Étape 2/3 : Conversion vers sql"
 ./dump2sqlite.sh 01232011-LEXICALNET-JEUXDEMOTS-FR-NOHTML.txt > sql
+
+echo "Étape 3/3 : Insertion dans la bdd"
+mv php/db php/db.old
 pv sql | sqlite3 php/db
-sudo chown -R user.www-data php
+
+sudo chown -R $USER.www-data php
 chmod 664 php/db
diff --git a/code/serveur/dump.url b/code/serveur/dump.url
@@ -1 +1 @@
-http://www.lirmm.fr/~lafourcade/JDM-LEXICALNET-FR/
+http://www.lirmm.fr/~lafourcade/JDM-LEXICALNET-FR/?C=M;O=D
diff --git a/code/serveur/dump2sqlite.sh b/code/serveur/dump2sqlite.sh
@@ -8,6 +8,7 @@ echo "  Et c'est parti !" >&2
 echo >&2
 
 # Played_game(type) : 0 => partie de référence, 1 => joueur
+# Note : l'index i_played_game_all sert à la vérification lors du set_partie.
 
 cat <<EOF
 begin transaction;
@@ -20,7 +21,15 @@ create table game(gid integer primary key autoincrement, eid_central_word, relat
 create table game_cloud(gid, num, difficulty, eid_word, totalWeight, probaR1, probaR2, probaR0, probaTrash);
 create table played_game(pgid integer primary key autoincrement, gid, login, timestamp);
 create table played_game_cloud(pgid, gid, type, num, relation, weight, score);
+
 insert into user(login, mail, hash_passwd, score) values('foo', 'foo@isp.com', '$(echo -n 'bar' | md5sum | cut -d ' ' -f 1)', 0);
+
+create index i_relation_start on relation(start);
+create index i_relation_end on relation(end);
+create index i_relation_type on relation(type);
+create index i_relation_start_type on relation(start,type);
+create index i_relation_end_type on relation(end,type);
+create index i_played_game_all on played_game(pgid, gid, login, timestamp);
 EOF
 
 # tr : pour virer le CRLF qui traîne
@@ -38,13 +47,4 @@ cat "$1" \
 | grep -v '^//' \
 | grep -v '^$'
 
-# Note : l'index i_played_game_all sert à la vérification lors du set_partie.
-cat <<EOF
-create index i_relation_start on relation(start);
-create index i_relation_end on relation(end);
-create index i_relation_type on relation(type);
-create index i_relation_start_type on relation(start,type);
-create index i_relation_end_type on relation(end,type);
-create index i_played_game_all on played_game(pgid, gid, login, timestamp);
-commit;
-EOF
+echo "commit;"