Mercurial > getan
annotate README @ 154:a620eb6e1fb0
Add controller method to find projects by key
The new methods returns projects which project key starts with the passed key.
| author | Björn Ricks <bjoern.ricks@intevation.de> |
|---|---|
| date | Thu, 06 Dec 2012 13:10:10 +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 |