Mercurial > dive4elements > river

annotate contrib/make_flys_release/issue_overview.sh @ 7602:c50dbbe17950

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
issue1596: Store table (cell) data twice: Once as (formatted) string as coming from server, once transformed into float (or string). The benefit is that now we can sort table data numerically, while keeping the formatted and i18ned display of values.
author Felix Wolfsteller <felix.wolfsteller@intevation.de>
date Wed, 27 Nov 2013 14:55:25 +0100
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