#DATA
export PGPASSWORD=`cat /golem/production/psql_password`;psql -c "SELECT session_date,shot_no,ROUND(t_plasma_duration,3),\"U_loop_mean\", \"Ip_mean\" FROM shots WHERE (shot_no > 31150) AND (t_plasma_duration != -1) AND (tags IS NULL OR tags NOT LIKE 'score=ko') ORDER BY t_plasma_duration DESC LIMIT 50;" -qAt -U golem golem_database |tee results.top
#HTML:
awk -F "|" 'BEGIN{print "---\nformat:markdown\n...\n\n<ol>"}{print "<li>"$1":<b>"$3" ms</b>@<a href=http://golem.fjfi.cvut.cz/shots/"$2">"$2"</a></li>"}END{print "</ol>"}' results.top|tee results.page
#SCORES
awk -F "|" '{print "export PGPASSWORD=`cat /golem/production/psql_password`;psql -c \"UPDATE shots SET tags=score=ko WHERE shot_no="$2"\" -qAt -U golem golem_database"}' results.top|sed "s/score=ko/'score=ko'/g"|tee bad_results_to_delete.sh
# and final git
git add .;git commit -am "discharge length develop"
#export PGPASSWORD=`cat /golem/production/psql_password`;psql -c "UPDATE shots SET tags='score=ko' WHERE shot_no=36200" -qAt -U golem golem_database
