Changes between Version 1 and Version 2 of ReScheduleScript

Timestamp:

Nov 27, 2007, 4:16:10 AM (16 years ago)

Author:

Terry Brown

Comment:

--

ReScheduleScript

@@ -4 +4 @@
 
 This isn't a normal Trac Hack, but a small standalone python program that stretches or compresses milestones between new start and stop dates, keeping the time allocations for each the same, proportionally.
+
+{{{
+Usage: reschedule.py [options]
+
+Fit Trac milestone due dates into a new time range, preserving relative
+spacing
+
+Options:
+  -h, --help            show this help message and exit
+  -D DBTYPE, --dbtype=DBTYPE
+                        database type: sqlite (default), postgres, mysql
+  -d DSN, --dsn=DSN     connect spec, eg. 'user=foo dbname=bar host=eg.com',
+                        or a filename for sqlite systems
+  -s START, --start=START
+                        new start date YYYYMMDD
+  -e END, --end=END     new end date YYYYMMDD
+  -o OLD, --old=OLD     old start date YYYYMMDD
+  -S SCHEMA, --schema=SCHEMA
+                        name of schema containing milestone table
+  -c, --commit          commit changes to table
+}}}
 
 == Bugs/Feature Requests == 
@@ -23 +44 @@
 == Example ==
 
-{{{python reschedule.py --dsn 'user=someuser host=localhost dbname=trac' --old 20071101 --start 20071203 --end 20090630}}}
+{{{
+python reschedule.py --dsn 'user=someuser host=localhost dbname=trac' \
+  --old 20071101 --start 20071203 --end 20090630 --dbtype postgres
+}}}
 
 would reschedule the milestones for a project that originally started 20071101 and ran until the due date of the last milestone to run instead between 20071203 and 20090630, which the same proportional allocation of time for each milestone.