Mercurial > getan
annotate scripts/convert-projects @ 433:266634f3712a
Improves command line options.
* Adds option '--init-only' which will non-interactively just
create the databasefile if it does not exits. This is useful if you want
to add tasks non-interatively. It allows to remove the superfluous file
`schema.sql` which duplicates the build-in schema in `backend.py`.
| author | Bernhard Reiter <bernhard@intevation.de> |
|---|---|
| date | Thu, 07 Sep 2017 17:08:23 +0200 |
| parents | 20fde79f8e12 |
| 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 } |