teichmann@0: 0 - install pysqlite2 teichmann@0: teichmann@0: On Debian GNU/Linux just do: teichmann@0: teichmann@0: # apt-get install python-pysqlite2 teichmann@0: teichmann@0: 1 - create new time.db teichmann@0: teichmann@0: To create an empty database you need the 'sqlite3' teichmann@0: commandline tool. TODO: This will change. teichmann@0: teichmann@0: # apt-get install sqlite3 teichmann@0: teichmann@0: $ echo '.r schema.sql' | sqlite3 time.db: teichmann@0: teichmann@0: 2 - adding new projects to time.db: teichmann@0: teichmann@0: $ sqlite3 time.db teichmann@0: sqlite> INSERT INTO projects (key, description) VALUES ('f', 'FOO'); teichmann@0: sqlite> INSERT INTO projects (key, description) VALUES ('b', 'BAR'); teichmann@0: sqlite> .q teichmann@0: teichmann@0: 3 - starting getan: teichmann@0: teichmann@0: $ ./getan teichmann@0: teichmann@0: or teichmann@0: teichmann@0: $ ./getan mytime.db teichmann@0: