|
39
|
1 import time
|
|
|
2
|
|
|
3 d = {'now':time.time()}
|
|
|
4 sql = [
|
|
|
5 #-- Separate between due and completed time for milestones.
|
|
|
6 """CREATE TEMPORARY TABLE milestone_old AS SELECT * FROM milestone;""",
|
|
|
7 """DROP TABLE milestone;""",
|
|
|
8 """CREATE TABLE milestone (
|
|
|
9 name text PRIMARY KEY,
|
|
|
10 due integer, -- Due date/time
|
|
|
11 completed integer, -- Completed date/time
|
|
|
12 description text
|
|
|
13 );""",
|
|
|
14 """INSERT INTO milestone(name,due,completed,description)
|
|
|
15 SELECT name,time,time,descr FROM milestone_old WHERE time <= %(now)s;""" % d,
|
|
|
16 """INSERT INTO milestone(name,due,description)
|
|
|
17 SELECT name,time,descr FROM milestone_old WHERE time > %(now)s;""" % d
|
|
|
18 ]
|
|
|
19
|
|
|
20 def do_upgrade(env, ver, cursor):
|
|
|
21 for s in sql:
|
|
|
22 cursor.execute(s)
|
