getan: contrib/convert-projects annotate

annotate contrib/convert-projects @ 155:497ed1991e85

Modify project selection The new project selection has two advantages: 1. It's possible to create and run e.g. projects a and aa Therefore it is possible to create a hirarchy again. 2. When inserting the project key only letters for valid projects are accepted. E.g. two projects exists aa and ab. In that case it is not possible to insert ac. Only a will be shown in the footer.

author	Björn Ricks <bjoern.ricks@intevation.de>
date	Thu, 06 Dec 2012 13:14:22 +0100
parents	a3fe8e4e9184
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 contrib/convert-projects @ 155:497ed1991e85