/[dehs]/trunk/update_wwwal.sh
ViewVC logotype

Contents of /trunk/update_wwwal.sh

Parent Directory Parent Directory | Revision Log Revision Log

Revision 95 - (show annotations) (download) (as text)
Wed Jan 23 21:23:41 2008 UTC (5 years, 3 months ago) by atomo64-guest
File MIME type: application/x-sh
File size: 5541 byte(s) 
dehs_pg.php:
Finished new version notifier code: added _recordEvent, _searchEvent
Made the database 'updated' column store true when updated and false when not updated
update_wwwal.sh:
Updated accordingly for the 'updated' change
Added updated_real_count* to stats.txt
www/*
Updated accordingly for the 'updated' change
tpls/new_version.mail.tpl:
Updated the message and destinations
1 #!/bin/sh
2 set -e
3
4 if [ ! -d "$WORKDIR" ]; then
5 echo "\$WORKDIR is empty!" >&2
6 exit 1
7 fi
8
9 if [ "$STATS_ONLY" != "1" ]; then
10 php4 -q $WORKDIR/www/no_watch.php > /org/alioth.debian.org/chroot/home/groups/dehs/htdocs/no_watch.html
11 php4 -q $WORKDIR/www/no_upstream.php > /org/alioth.debian.org/chroot/home/groups/dehs/htdocs/no_upstream.html
12 php4 -q $WORKDIR/www/no_updated.php > /org/alioth.debian.org/chroot/home/groups/dehs/htdocs/no_updated.html
13 psql -A -q -d dehs -c "SELECT name || ': N/A' FROM pkgs WHERE watch IS NULL OR watch='' AND dist='unstable' ORDER BY name ASC;" | egrep -v '\?column\?|rows\)' > /org/alioth.debian.org/chroot/home/groups/dehs/htdocs/no_watch.txt
14 psql -A -q -d dehs -c "SELECT name || ': Error' FROM pkgs WHERE up_version='' AND watch!='' AND dist='unstable' order by name asc;" | egrep -v '\?column\?|rows\)' > /org/alioth.debian.org/chroot/home/groups/dehs/htdocs/no_upstream.txt
15 psql -A -q -d dehs -c "SELECT name || ': ' || up_version FROM pkgs WHERE up_version!='' AND watch!='' AND dist='unstable' order by name asc;" | egrep -v '\?column\?|rows\)' > /org/alioth.debian.org/chroot/home/groups/dehs/htdocs/no_updated.txt
16 psql -A -q -d dehs -c "SELECT name || ': N/A' FROM pkgs WHERE watch IS NULL OR watch='' AND dist='unstable' UNION SELECT name || ': Error' FROM pkgs WHERE up_version='' AND watch!='' AND dist='unstable' UNION SELECT name || ': ' || up_version FROM pkgs WHERE up_version!='' AND watch!='' AND dist='unstable';" | egrep -v '\?column\?|rows\)' > /org/alioth.debian.org/chroot/home/groups/dehs/htdocs/dehs_debianqa.txt
17 fi
18
19 STATS=/org/alioth.debian.org/chroot/home/groups/dehs/htdocs/dehs_stats.txt
20 cat /dev/null > $STATS.new
21 echo -n 'watch_count:' >> $STATS.new
22 psql -A -q -d dehs -c "SELECT COUNT(id) FROM pkgs WHERE watch!='';" | egrep -v '[^0-9]' >> $STATS.new
23 echo -n 'watch_count_unstable:' >> $STATS.new
24 psql -A -q -d dehs -c "SELECT COUNT(id) FROM pkgs WHERE watch!='' AND dist='unstable';" | egrep -v '[^0-9]' >> $STATS.new
25 echo -n 'watch_count_experimental:' >> $STATS.new
26 psql -A -q -d dehs -c "SELECT COUNT(id) FROM pkgs WHERE watch!='' AND dist='experimental';" | egrep -v '[^0-9]' >> $STATS.new
27 echo -n 'no_watch_count:' >> $STATS.new
28 psql -A -q -d dehs -c "SELECT COUNT(id) FROM pkgs WHERE watch IS NULL OR watch='';" | egrep -v '[^0-9]' >> $STATS.new
29 echo -n 'no_watch_count_unstable:' >> $STATS.new
30 psql -A -q -d dehs -c "SELECT COUNT(id) FROM pkgs WHERE (watch IS NULL OR watch='') AND dist='unstable';" | egrep -v '[^0-9]' >> $STATS.new
31 echo -n 'no_watch_count_experimental:' >> $STATS.new
32 psql -A -q -d dehs -c "SELECT COUNT(id) FROM pkgs WHERE (watch IS NULL OR watch='') AND dist='experimental';" | egrep -v '[^0-9]' >> $STATS.new
33 echo -n 'watch_failed:' >> $STATS.new
34 psql -A -q -d dehs -c "SELECT COUNT(id) FROM pkgs WHERE up_version='' AND watch!='';" | egrep -v '[^0-9]' >> $STATS.new
35 echo -n 'watch_failed_unstable:' >> $STATS.new
36 psql -A -q -d dehs -c "SELECT COUNT(id) FROM pkgs WHERE up_version='' AND watch!='' AND dist='unstable';" | egrep -v '[^0-9]' >> $STATS.new
37 echo -n 'watch_failed_experimental:' >> $STATS.new
38 psql -A -q -d dehs -c "SELECT COUNT(id) FROM pkgs WHERE up_version='' AND watch!='' AND dist='experimental';" | egrep -v '[^0-9]' >> $STATS.new
39 echo -n 'wwiz_count:' >> $STATS.new
40 psql -A -q -d dehs -c "SELECT COUNT(id) FROM pkgs WHERE wwiz_type='watch';" | egrep -v '[^0-9]' >> $STATS.new
41 echo -n 'wwiz_count_unstable:' >> $STATS.new
42 psql -A -q -d dehs -c "SELECT COUNT(id) FROM pkgs WHERE wwiz_type='watch' AND dist='unstable';" | egrep -v '[^0-9]' >> $STATS.new
43 echo -n 'wwiz_count_experimental:' >> $STATS.new
44 psql -A -q -d dehs -c "SELECT COUNT(id) FROM pkgs WHERE wwiz_type='watch' AND dist='experimental';" | egrep -v '[^0-9]' >> $STATS.new
45 echo -n 'updated_count:' >> $STATS.new
46 psql -A -q -d dehs -c "SELECT COUNT(id) FROM pkgs WHERE updated='1';" | egrep -v '[^0-9]' >> $STATS.new
47 echo -n 'updated_count_unstable:' >> $STATS.new
48 psql -A -q -d dehs -c "SELECT COUNT(id) FROM pkgs WHERE updated='1' AND dist='unstable';" | egrep -v '[^0-9]' >> $STATS.new
49 echo -n 'updated_count_experimental:' >> $STATS.new
50 psql -A -q -d dehs -c "SELECT COUNT(id) FROM pkgs WHERE updated='1' AND dist='experimental';" | egrep -v '[^0-9]' >> $STATS.new
51 echo -n 'updated_real_count:' >> $STATS.new
52 psql -A -q -d dehs -c "SELECT COUNT(id) FROM pkgs WHERE updated='1' AND version!='';" | egrep -v '[^0-9]' >> $STATS.new
53 echo -n 'updated_real_count_unstable:' >> $STATS.new
54 psql -A -q -d dehs -c "SELECT COUNT(id) FROM pkgs WHERE updated='1' AND version!='' AND dist='unstable';" | egrep -v '[^0-9]' >> $STATS.new
55 echo -n 'updated_real_count_experimental:' >> $STATS.new
56 psql -A -q -d dehs -c "SELECT COUNT(id) FROM pkgs WHERE updated='1' AND version!='' AND dist='experimental';" | egrep -v '[^0-9]' >> $STATS.new
57 echo -n 'updated_wwiz_count:' >> $STATS.new
58 psql -A -q -d dehs -c "SELECT COUNT(id) FROM pkgs WHERE updated='1' AND wwiz_type='watch';" | egrep -v '[^0-9]' >> $STATS.new
59 echo -n 'updated_wwiz_count_unstable:' >> $STATS.new
60 psql -A -q -d dehs -c "SELECT COUNT(id) FROM pkgs WHERE updated='1' AND dist='unstable' AND wwiz_type='watch';" | egrep -v '[^0-9]' >> $STATS.new
61 echo -n 'updated_wwiz_count_experimental:' >> $STATS.new
62 psql -A -q -d dehs -c "SELECT COUNT(id) FROM pkgs WHERE updated='1' AND dist='experimental' AND wwiz_type='watch';" | egrep -v '[^0-9]' >> $STATS.new
63 mv $STATS.new $STATS
64 php4 -q $WORKDIR/www/stats.html > /org/alioth.debian.org/chroot/home/groups/dehs/htdocs/stats.html "$STATS"

Properties

Name Value
svn:executable *
  ViewVC Help
Powered by ViewVC 1.1.5