Mercurial > getan
annotate README @ 191:64624032611d
Add function to convert from iso to unix week
For evaluation we use the iso week as week parameter which is commonly known in
europe. But SQLite internally uses unix weeks which may differ. Therefore
convert the iso week to the unix week.
| author | Björn Ricks <bjoern.ricks@intevation.de> |
|---|---|
| date | Thu, 17 Jan 2013 11:41:36 +0100 |
| parents | 13a963546ee9 |
| children | b6e91535acb7 |
| rev | line source |
|---|---|
| 0 | 1 0 - install pysqlite2 |
| 2 | |
| 3 On Debian GNU/Linux just do: | |
| 4 | |
| 5 # apt-get install python-pysqlite2 | |
|
23
9c4e8ba3c4fa
Added a new implementation of 'getan' based on urwid, a python console user interface library.
Ingo Weinzierl <ingo_weinzierl@web.de>
parents:
3
diff
changeset
|
6 # apt-get install python-urwid |
|
9c4e8ba3c4fa
Added a new implementation of 'getan' based on urwid, a python console user interface library.
Ingo Weinzierl <ingo_weinzierl@web.de>
parents:
3
diff
changeset
|
7 |
|
9c4e8ba3c4fa
Added a new implementation of 'getan' based on urwid, a python console user interface library.
Ingo Weinzierl <ingo_weinzierl@web.de>
parents:
3
diff
changeset
|
8 NOTE: getan requires urwid >= 0.9.9.1. |
| 0 | 9 |
| 10 1 - create new time.db | |
| 11 | |
| 12 To create an empty database you need the 'sqlite3' | |
| 13 commandline tool. TODO: This will change. | |
| 14 | |
| 15 # apt-get install sqlite3 | |
| 16 | |
|
92
565825db59d2
Use ".read" instead of ".r" in sqlite3 command
Thomas Arendsen Hein <thomas@intevation.de>
parents:
23
diff
changeset
|
17 $ echo '.read schema.sql' | sqlite3 time.db |
| 0 | 18 |
| 19 2 - adding new projects to time.db: | |
| 20 | |
| 21 $ sqlite3 time.db | |
| 22 sqlite> INSERT INTO projects (key, description) VALUES ('f', 'FOO'); | |
| 23 sqlite> INSERT INTO projects (key, description) VALUES ('b', 'BAR'); | |
| 24 sqlite> .q | |
| 25 | |
|
1
a3fe8e4e9184
- To exit getan you now can use double BACKSPACE, too.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
0
diff
changeset
|
26 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
|
27 |
|
a3fe8e4e9184
- To exit getan you now can use double BACKSPACE, too.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
0
diff
changeset
|
28 ./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
|
29 |
|
110
13a963546ee9
Change tab into spaces in README
Björn Ricks <bjoern.ricks@intevation.de>
parents:
92
diff
changeset
|
30 If you want to keep the reverse task order of the original config |
|
13a963546ee9
Change tab into spaces in README
Björn Ricks <bjoern.ricks@intevation.de>
parents:
92
diff
changeset
|
31 file you might pipe it through tac first. |
|
3
1513c716eef0
- Added total sum of all projects.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
1
diff
changeset
|
32 |
| 0 | 33 3 - starting getan: |
| 34 | |
|
23
9c4e8ba3c4fa
Added a new implementation of 'getan' based on urwid, a python console user interface library.
Ingo Weinzierl <ingo_weinzierl@web.de>
parents:
3
diff
changeset
|
35 $ ./getan.py |
| 0 | 36 |
| 37 or | |
| 38 | |
|
23
9c4e8ba3c4fa
Added a new implementation of 'getan' based on urwid, a python console user interface library.
Ingo Weinzierl <ingo_weinzierl@web.de>
parents:
3
diff
changeset
|
39 $ ./getan.py mytime.db |
| 0 | 40 |
|
23
9c4e8ba3c4fa
Added a new implementation of 'getan' based on urwid, a python console user interface library.
Ingo Weinzierl <ingo_weinzierl@web.de>
parents:
3
diff
changeset
|
41 or (for the classic version of 'getan' based on curses): |
|
9c4e8ba3c4fa
Added a new implementation of 'getan' based on urwid, a python console user interface library.
Ingo Weinzierl <ingo_weinzierl@web.de>
parents:
3
diff
changeset
|
42 $ classic/getan |
|
9c4e8ba3c4fa
Added a new implementation of 'getan' based on urwid, a python console user interface library.
Ingo Weinzierl <ingo_weinzierl@web.de>
parents:
3
diff
changeset
|
43 |
|
9c4e8ba3c4fa
Added a new implementation of 'getan' based on urwid, a python console user interface library.
Ingo Weinzierl <ingo_weinzierl@web.de>
parents:
3
diff
changeset
|
44 or |
|
9c4e8ba3c4fa
Added a new implementation of 'getan' based on urwid, a python console user interface library.
Ingo Weinzierl <ingo_weinzierl@web.de>
parents:
3
diff
changeset
|
45 |
|
9c4e8ba3c4fa
Added a new implementation of 'getan' based on urwid, a python console user interface library.
Ingo Weinzierl <ingo_weinzierl@web.de>
parents:
3
diff
changeset
|
46 $ classic/getan mytime.db |