Mercurial > dive4elements > river

annotate contrib/make_flys_release/issue_overview.sh @ 9195:a4121ec450d6

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
'ca.'-issue ExportContextCSV+PDF separated uinfo.inundationduration url export
author gernotbelger
date Fri, 29 Jun 2018 14:52:54 +0200
parents 93c0a1692aa5
children
rev   line source
6866
93c0a1692aa5 Add small script to generate an issue overview from a roundup querry.
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
1 #!/bin/sh
93c0a1692aa5 Add small script to generate an issue overview from a roundup querry.
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
2
93c0a1692aa5 Add small script to generate an issue overview from a roundup querry.
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
3 # Use this on an exported query from roundup
93c0a1692aa5 Add small script to generate an issue overview from a roundup querry.
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
4 # Known issue: Tiles with more then three , in them fail.
93c0a1692aa5 Add small script to generate an issue overview from a roundup querry.
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
5 # Yes (ah) I do not know how to correctly handle the csv quoting...
93c0a1692aa5 Add small script to generate an issue overview from a roundup querry.
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
6
93c0a1692aa5 Add small script to generate an issue overview from a roundup querry.
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
7 echo "-------------"
93c0a1692aa5 Add small script to generate an issue overview from a roundup querry.
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
8 echo "Unter anderem wurden folgende issues bearbeitet und können getestet werden:"
93c0a1692aa5 Add small script to generate an issue overview from a roundup querry.
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
9
93c0a1692aa5 Add small script to generate an issue overview from a roundup querry.
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
10 sed 's/"\(.*\),\(.*\)"/"\1§\2"/g' "$1" | \
93c0a1692aa5 Add small script to generate an issue overview from a roundup querry.
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
11 sed 's/"\(.*\),\(.*\)"/"\1§\2"/g' | \
93c0a1692aa5 Add small script to generate an issue overview from a roundup querry.
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
12 sed 's/"\(.*\),\(.*\)"/\1§\2/g' | \
93c0a1692aa5 Add small script to generate an issue overview from a roundup querry.
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
13 gawk -F, '$5 > 5 {
93c0a1692aa5 Add small script to generate an issue overview from a roundup querry.
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
14 print "- flys/issue"$2 " ("$1")"
93c0a1692aa5 Add small script to generate an issue overview from a roundup querry.
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
15 print "[https://roundup-intern.intevation.de/flys/issue"$2"]"
93c0a1692aa5 Add small script to generate an issue overview from a roundup querry.
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
16 print ""
93c0a1692aa5 Add small script to generate an issue overview from a roundup querry.
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
17 }' | sed 's/§/,/g'
93c0a1692aa5 Add small script to generate an issue overview from a roundup querry.
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
18
93c0a1692aa5 Add small script to generate an issue overview from a roundup querry.
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
19
93c0a1692aa5 Add small script to generate an issue overview from a roundup querry.
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
20 echo "-------------"
93c0a1692aa5 Add small script to generate an issue overview from a roundup querry.
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
21 echo "Desweiteren gab es fortschritte in folgenden Issues:"
93c0a1692aa5 Add small script to generate an issue overview from a roundup querry.
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
22 echo ""
93c0a1692aa5 Add small script to generate an issue overview from a roundup querry.
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
23 sed 's/"\(.*\),\(.*\)"/"\1§\2"/g' "$1" | \
93c0a1692aa5 Add small script to generate an issue overview from a roundup querry.
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
24 sed 's/"\(.*\),\(.*\)"/"\1§\2"/g' | \
93c0a1692aa5 Add small script to generate an issue overview from a roundup querry.
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
25 sed 's/"\(.*\),\(.*\)"/\1§\2/g' | \
93c0a1692aa5 Add small script to generate an issue overview from a roundup querry.
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
26 gawk -F, '$5 <= 5 && $5 > 0 {
93c0a1692aa5 Add small script to generate an issue overview from a roundup querry.
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
27 print "- flys/issue"$2 " ("$1")"
93c0a1692aa5 Add small script to generate an issue overview from a roundup querry.
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
28 print "[https://roundup-intern.intevation.de/flys/issue"$2"]"
93c0a1692aa5 Add small script to generate an issue overview from a roundup querry.
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
29 print ""
93c0a1692aa5 Add small script to generate an issue overview from a roundup querry.
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
30 }' | sed 's/§/,/g'
93c0a1692aa5 Add small script to generate an issue overview from a roundup querry.
Andre Heinecke <aheinecke@intevation.de>
parents:
diff changeset
31
http://dive4elements.wald.intevation.org