Mercurial > getan
annotate contrib/convert-projects @ 307:b97d18d58f85
We already have the project here therefore pass it directly to the methods
Using item_in_focus may be dangerous because a user may have already selected
another element.
| author | Björn Ricks <bjoern.ricks@intevation.de> |
|---|---|
| date | Fri, 11 Oct 2013 11:05:22 +0200 |
| parents | a3fe8e4e9184 |
| 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 } |