/usr/share/yokadi/update/update3to4 is in yokadi 0.14.0-1.
This file is owned by root:root, with mode 0o755.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 | #! /usr/bin/python
# -*- coding: UTF-8 -*-
"""
Update from version 3 to version 4 of Yokadi DB
@author: Sébastien Renard <Sebastien.Renard@digitalfox.org>
@license: GPL v3 or newer
"""
import sys
from os.path import dirname, join
from sqlobject import connectionForURI, sqlhub, SQLObject, ForeignKey, StringCol
""" This is the v4 table """
class Recurrence(SQLObject):
rule = StringCol(default="", notNone=True)
""" This is a fake table (we only need table name) """
class Task(SQLObject):
pass
def createRecurrenceTable():
Recurrence.createTable()
def alterTaskTable():
Task.sqlmeta.addColumn(ForeignKey("Recurrence", default=None))
def removeDefaultProject():
sqlhub.processConnection.query("delete from config where name='DEFAULT_PROJECT'")
def main():
sqlhub.processConnection = connectionForURI('sqlite:' + sys.argv[1])
createRecurrenceTable()
alterTaskTable()
removeDefaultProject()
if __name__ == "__main__":
main()
# vi: ts=4 sw=4 et
|