Mercurial > getan
annotate README @ 15:0bb0100b2c8d
Added a script to sort zeiterfassung.txt files by date. Useful to merge them.
| author | Sascha L. Teichmann <teichmann@intevation.de> |
|---|---|
| date | Tue, 09 Sep 2008 21:43:00 +0200 |
| parents | 1513c716eef0 |
| children | 9c4e8ba3c4fa |
| rev | line source |
|---|---|
| 0 | 1 0 - install pysqlite2 |
| 2 | |
| 3 On Debian GNU/Linux just do: | |
| 4 | |
| 5 # apt-get install python-pysqlite2 | |
| 6 | |
| 7 1 - create new time.db | |
| 8 | |
| 9 To create an empty database you need the 'sqlite3' | |
| 10 commandline tool. TODO: This will change. | |
| 11 | |
| 12 # apt-get install sqlite3 | |
| 13 | |
|
1
a3fe8e4e9184
- To exit getan you now can use double BACKSPACE, too.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
0
diff
changeset
|
14 $ echo '.r schema.sql' | sqlite3 time.db |
| 0 | 15 |
| 16 2 - adding new projects to time.db: | |
| 17 | |
| 18 $ sqlite3 time.db | |
| 19 sqlite> INSERT INTO projects (key, description) VALUES ('f', 'FOO'); | |
| 20 sqlite> INSERT INTO projects (key, description) VALUES ('b', 'BAR'); | |
| 21 sqlite> .q | |
| 22 | |
|
1
a3fe8e4e9184
- To exit getan you now can use double BACKSPACE, too.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
0
diff
changeset
|
23 To import an old worklog configuration you may use: |
|
a3fe8e4e9184
- To exit getan you now can use double BACKSPACE, too.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
0
diff
changeset
|
24 |
|
a3fe8e4e9184
- To exit getan you now can use double BACKSPACE, too.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
0
diff
changeset
|
25 ./contrib/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:
0
diff
changeset
|
26 |
|
3
1513c716eef0
- Added total sum of all projects.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
1
diff
changeset
|
27 If you want to keep the reverse task order of the original config |
|
1513c716eef0
- Added total sum of all projects.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
1
diff
changeset
|
28 file you might pipe it through tac first. |
|
1513c716eef0
- Added total sum of all projects.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
1
diff
changeset
|
29 |
| 0 | 30 3 - starting getan: |
| 31 | |
| 32 $ ./getan | |
| 33 | |
| 34 or | |
| 35 | |
| 36 $ ./getan mytime.db | |
| 37 |