Outil pour calculer et afficher les classements FFTRI raid à partir des licences et des résultats chargés dans l'application.
running at : https://classements.raidsaventure.fr/championship/
- PHP (version 7+)
- Composer
- Mysql (ou mariadb)
- php-mysql (ou php-pdo_mysql)
git clone https://github.com/janssens/classements_fftri_raids
cd classements_fftri_raids/
composer install
Edit .env
to setup the database connexion information
php bin/console doctrine:database:create
php bin/console doctrine:migrations:migrate
php bin/console app:import:registrations PATH/TO/FILE.csv
In case too heavy to handle (out of memory error)
for VAR in {0..58000..1000}; do php bin/console app:import:registrations PATH/TO/FILE.csv --map "2,3,4,5,6,17,30,31,32,33,37,38" -l 1000 -s $VAR; done
for VAR in {0..59000..500}; do docker-compose exec php php bin/console app:import:registrations ./data/2022/licences-2022.csv --map 1,2,3,5,6,18,27,29,30,31,35,36 -l 500 -s $VAR; done
php bin/console app:import:race_ranking PATH/TO/FILE.csv
get all firstname,lastname and email of racers
SELECT a.firstname, a.lastname , a.email FROM `view_racer` AS r JOIN athlete AS a ON r.parent_id = a.id WHERE outsider = 0
SELECT club as club_id, SUM(points) as points,championship_id FROM my_view_official_ranking WHERE championship_id = 3 GROUP BY CONCAT(club);
$ sed -i "s/classements/classement/" dump.sql $ docker cp dump.sql 06662ecb2126:/tmp/dump.sql $ docker-compose exec mariadb bash -c "mysql classement -uroot -proot < /tmp/dump.sql" $ docker-compose exec php php bin/console doctrine:migration:migrate