[Ml-yokadi] New recurrence storage layer

Aurélien Gâteau aurelien.gateau at free.fr
Mon Jul 6 20:04:57 CEST 2009


A few more details on this dev-only update:

Sébastien Renard wrote:
> (1) before pulling code (or go backward to b809b3c97e1dc89) note all the task 
> that have recurrence. You can get id with this sql request: select t.id from 
> recurrence r, task t where r.id=t.recurrence_id;

It's important to do this *before* the checkout if you want to print the
task details within Yokadi so that it's easier to recreate the recurrences.
> 
> (2) with sqlite3, connect and drop recurrence table

This means:

  sqlite3 /path/to/yokadi.db
  drop table recurrence;

(2.5) missing command to reset the recurrence_id of the task table:

  update task set recurrence_id = null;

> 
> (3) checkout master.
>


> (4) open python shell, cd to src/yokadi and import db
> 
> (5) open your database with db.connectDatabase(<path to .db>) and create the 
> new table with : db.Recurrence.createTable()

More detailed version of step (4) and (5):
1. cd to src/yokadi
2. start python
3. type this:

  import db
  db.connectDatabase("/path/to/yokadi.db")
  db.Recurrence.createTable()

> 
> (6) retype your recurrence ;-)
> 
> a+



More information about the Ml-yokadi mailing list