Mercurial > getan
annotate scripts/convert-projects @ 382:7a63212924c3
Rename getan_report.py to getan-report.py
All scripts are using the minus symbol do split words.
author | Björn Ricks <bjoern.ricks@intevation.de> |
---|---|
date | Mon, 05 Jan 2015 11:04:07 +0100 |
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 } |