Mercurial > getan
annotate README @ 117:c5c877d6c1e3
Load and create default database for installed scripts
Load default database from current dir if default dabase exists.
If not load or create a default database in $HOME/.getan/
author | Björn Ricks <bjoern.ricks@intevation.de> |
---|---|
date | Mon, 12 Dec 2011 09:48:20 +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 |