[Ml-yokadi] yokadid updates and somes questions

[Aurélien Gâteau]

Sébastien Renard wrote:
> Hello fellow yokadi citizen,
> 
> I've made some update on yokadi daemon to ignore done tasks and esapce quotes 
> in task title when launching external command.
> 
> I've had to update default parameters ALARM_DELAY_CMD and ALARM_DUE_CMD to 
> replace simple quote by double quotes.
> I don't know how to update that properly for existing yokadi installation, as 
> default parameters are copied during db initialisation on first run.
> An update script for that is quite overkill isn't it ?
> Any idea ?

You can change the existing update script so that it replaces the
default value with the new if it hasn't been modified by the user.

Which makes me think we should probably try to actually release
something :). What about listing the tasks we would like to get done
before a v1.0 can be released? :)

Here are mine:
- Support for date limits in 't_list'
- Write a README, getting started doc
- Doc update system
- Merge YokadiParser and cmd help
- Make it possible to run update.py from outside its dir
- When project does not exist, prompt the user to create|edit|cancel
- Show task title in t_mark* and t_remove


> Other question, about sqlobject (I don't like sqlobject :D). How to filter 
> following a foreign key ?
> Ex., I want tasks of inactive projects.
> This request (in Django style ORM) does not work : 
> Task.select(Task.q.project.active==True)
> 
> I can start my request on Project and then get Tasks, but it's more 
> complicated if I also want to filter task on name or status for instance.

Here it is:

Task.select(AND(
     Task.q.projectID == Project.q.id,
     Project.q.active == False))

Aurélien