getan: contrib/convert-projects annotate

annotate contrib/convert-projects @ 273:a5c5675b6fa4

Give more "weight" to the description when displaying the project node entry With this change the project description will get more space in the row then the time. This avoids cutting long description texts even if the there is enough free space. With urwid 1.1 it would even better to user ("pack", time) for this.

author	Björn Ricks <bjoern.ricks@intevation.de>
date	Fri, 12 Apr 2013 09:34:18 +0200
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 @ 273:a5c5675b6fa4