[Ml-yokadi] New recurrence storage layer

[Sébastien Renard]

Hello all,

I finally get stuck with home made rrule object serialisation in database. This 
has been triggered by complex recurrence like first monday, third wenesday, 
last sunday that use weekdays objects.
So I switch to pickle. More reliable but less readable...

I won't make a formal migration script as we never release the previous 
recurrence table format ;-)
But here a way to migrate your recurrence by hand:

(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;

(2) with sqlite3, connect and drop recurrence table

(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()

(6) retype your recurrence ;-)

a+
-- 
Sébastien