Mercurial > getan
annotate contrib/convert-projects @ 131:3d5232dad59a
Add methods to reset the ProjectList footer
When going back from the move state ist must be possible to restore the old
footer entry in the ProjectList. The footer may be overriden by the move state
to select a project. In this case the old entry should be restored instead of
showing a blank footer.
author | Björn Ricks <bjoern.ricks@intevation.de> |
---|---|
date | Wed, 31 Oct 2012 09:53:57 +0100 |
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 } |