Mercurial > getan
view 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 |
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 '.read 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