Mercurial > getan
diff contrib/convert-projects @ 1:a3fe8e4e9184
- To exit getan you now can use double BACKSPACE, too.
- Fixed typo, added hint to Sascha Wilde's projects converter.
- Added Sascha Wilde's converter to import existing worklog configuration files.
| author | Sascha L. Teichmann <teichmann@intevation.de> |
|---|---|
| date | Tue, 29 Jul 2008 16:38:40 +0200 |
| parents | |
| children |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/contrib/convert-projects Tue Jul 29 16:38:40 2008 +0200 @@ -0,0 +1,11 @@ +#!/usr/bin/awk -f + +# Convert classic worklog projects file to SQL statements for inseration in the getan database. +# USAGE: +# ./convert-projects </PATH/TO/projects | sqlite3 time.db + +BEGIN { FS=":"; } + +/[^# \t]/ { + printf "INSERT INTO projects (key, description) VALUES ('%s', '%s');\n", $1, $2; +}