Mercurial > getan
view scripts/convert-projects @ 535:d5acadeef0f8
improve usage message & simply code
* Shorten help output for `--database` as the good option name is enough
to explain.
* Fix typo in help output for `--empty'
* Simplyied code by removing `dest` and `metavar` for add_argument
where it was not necessary because it was already the default if those
parameters are not given.
* Add Intevation and Magnus as rights holder and author for 2019 and 2020.
author | Bernhard Reiter <bernhard@intevation.de> |
---|---|
date | Wed, 08 Jan 2020 09:22:23 +0100 |
parents | 20fde79f8e12 |
children |
line wrap: on
line source
#!/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; }