Mercurial > getan
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 379:47890f38e558 | 380:20fde79f8e12 |
|---|---|
| 1 #!/usr/bin/awk -f | |
| 2 | |
| 3 # Convert classic worklog projects file to SQL statements for inseration in the getan database. | |
| 4 # USAGE: | |
| 5 # ./convert-projects </PATH/TO/projects | sqlite3 time.db | |
| 6 | |
| 7 BEGIN { FS=":"; } | |
| 8 | |
| 9 /[^# \t]/ { | |
| 10 printf "INSERT INTO projects (key, description) VALUES ('%s', '%s');\n", $1, $2; | |
| 11 } |