getan: scripts/convert-projects annotate

annotate scripts/convert-projects @ 540:91aaf455c44e

Add new template zeiterfassung-hierarchy1 * Add template for getan-report for the use case where hierarchical project keys are used to select the workpackages within a project. The grouping within the new template is done the way it is, because a second attribute lookup is not possible in Jinja2, when having just an entry it is not possible to get the `projects[entry.project_id].key`.

author	Bernhard Reiter <bernhard@intevation.de>
date	Thu, 30 Jan 2020 10:47:20 +0100
parents	20fde79f8e12
children

rev	line source
1 a3fe8e4e9184 - To exit getan you now can use double BACKSPACE, too. Sascha L. Teichmann <teichmann@intevation.de> parents: diff changeset	1 #!/usr/bin/awk -f
a3fe8e4e9184 - To exit getan you now can use double BACKSPACE, too. Sascha L. Teichmann <teichmann@intevation.de> parents: diff changeset	2
a3fe8e4e9184 - To exit getan you now can use double BACKSPACE, too. Sascha L. Teichmann <teichmann@intevation.de> parents: diff changeset	3 # Convert classic worklog projects file to SQL statements for inseration in the getan database.
a3fe8e4e9184 - To exit getan you now can use double BACKSPACE, too. Sascha L. Teichmann <teichmann@intevation.de> parents: diff changeset	4 # USAGE:
a3fe8e4e9184 - To exit getan you now can use double BACKSPACE, too. Sascha L. Teichmann <teichmann@intevation.de> parents: diff changeset	5 # ./convert-projects </PATH/TO/projects \| sqlite3 time.db
a3fe8e4e9184 - To exit getan you now can use double BACKSPACE, too. Sascha L. Teichmann <teichmann@intevation.de> parents: diff changeset	6
a3fe8e4e9184 - To exit getan you now can use double BACKSPACE, too. Sascha L. Teichmann <teichmann@intevation.de> parents: diff changeset	7 BEGIN { FS=":"; }
a3fe8e4e9184 - To exit getan you now can use double BACKSPACE, too. Sascha L. Teichmann <teichmann@intevation.de> parents: diff changeset	8
a3fe8e4e9184 - To exit getan you now can use double BACKSPACE, too. Sascha L. Teichmann <teichmann@intevation.de> parents: diff changeset	9 /[^# \t]/ {
a3fe8e4e9184 - To exit getan you now can use double BACKSPACE, too. Sascha L. Teichmann <teichmann@intevation.de> parents: diff changeset	10 printf "INSERT INTO projects (key, description) VALUES ('%s', '%s');\n", $1, $2;
a3fe8e4e9184 - To exit getan you now can use double BACKSPACE, too. Sascha L. Teichmann <teichmann@intevation.de> parents: diff changeset	11 }

Mercurial > getan

annotate scripts/convert-projects @ 540:91aaf455c44e