Mercurial > getan
diff scripts/convert-projects @ 380:20fde79f8e12
Move all scripts in a common scripts directory
Currently console scripts were kept in several directories. Now use a common
directory for all scripts.
| author | Björn Ricks <bjoern.ricks@intevation.de> |
|---|---|
| date | Mon, 05 Jan 2015 10:54:20 +0100 |
| parents | contrib/convert-projects@a3fe8e4e9184 |
| children |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/scripts/convert-projects Mon Jan 05 10:54:20 2015 +0100 @@ -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; +}