Mercurial > dive4elements > river

annotate contrib/make_flys_release/issue_overview.sh @ 7698:7efeaa2058e1

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
SQ Relation: Added CSV dumping to raw SedDB query results. If system property 'minfo.dump.sq.seddb.prefix' is set files are generate from this to contain the results of the raw SQL queries.
author Sascha L. Teichmann <teichmann@intevation.de>
date Mon, 16 Dec 2013 16:39:12 +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