view README @ 68:a25dab413260

Add new method to update a description of an entry in the database backend
author Björn Ricks <bjoern.ricks@intevation.de>
date Wed, 25 May 2011 13:26:09 +0200
parents 9c4e8ba3c4fa
children 565825db59d2
line wrap: on
line source
0 - install pysqlite2 

    On Debian GNU/Linux just do:

    # apt-get install python-pysqlite2 
    # apt-get install python-urwid

    NOTE: getan requires urwid >= 0.9.9.1.

1 - create new time.db

    To create an empty database you need the 'sqlite3'
    commandline tool. TODO: This will change.

    # apt-get install sqlite3

    $ echo '.r schema.sql' | sqlite3 time.db

2 - adding new projects to time.db:

    $ sqlite3 time.db
    sqlite> INSERT INTO projects (key, description) VALUES ('f', 'FOO');
    sqlite> INSERT INTO projects (key, description) VALUES ('b', 'BAR');
    sqlite> .q

    To import an old worklog configuration you may use:

    ./contrib/convert-projects </PATH/TO/projects | sqlite3 time.db

	If you want to keep the reverse task order of the original config
	file you might pipe it through tac first.

3 - starting getan:

    $ ./getan.py

    or

    $ ./getan.py mytime.db

    or (for the classic version of 'getan' based on curses):
    $ classic/getan

    or

    $ classic/getan mytime.db
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)