MigrationStory

Introduction

In the current setup Project has attributes Tasks, in the new setup Projects will have QuoteTasks and ImplementationTasks. For existing projects all Tasks have to be rewritten to Implementationtasks and dummy QuoteTask has to be created.

Functional description

This story should result in an application for migrating the ldap contents of ops_admin before estimates where in place to a new database for ops_admin with estimates. Namely ou=Projects with Project children that support task estimates.

Technical description

Steps:

1. create new schema that extends the old schema with additional Q-Tasks and I-Tasks, upload, restart
2. rewrite existing Tasks to I-Tasks, as children of a dummy Q-Task
3. check
4. remove all Tasks
5. create new schema without Tasks, upload, restart

For a little about LDAP see OpsAdminTechnicalInfo.

Finally remove 'task' as attribute from the schema, and close this bug. See legacy project tasks.

Schema

Writing the new schema is part of EnableTaskEstimates.

Rewriting app

• setup
• rewriteDao.updateProject write away an intermediate Project object, with a collection of Q-tasks, which may have I-Tasks, but with the old opsProjectTasks. Remove any remaining attribute tasks.
• rewriteDao.writeTaskTree: for each legacy project: create Q task with project name, create I-task for every task and add it as a child to the Q-task.
• rewriteDao.checkProject assert:
  • if a project has tasks, it must have at least 1 Q-Task
  • Tasks <> I-Tasks.
• rewriteDao.removeOpsProjectTasks remove all opsProjectTasks.

Estimates

task	hours	todo
rewriteDao	24	0
Total	24	0

---

Discussion

If we want tasks to have guids, now is the time to implement. (But why?)

There are 5 legacy projects with task attributes in the production ldap. These projects also have OpsProjectTasks which appear in the timesheets. The attribute tasks should be removed by hand through some ldap interface, note that attribute-tasks are never shown in the admin tool.

project	task attribute(s)	!OpsProjectTasks, in timesheets
Enof Hunesus Website	deploy	deploy
Enof NRF Miss 2006	deploy	deploy
Enof Zokantook Website	closed	deploy
Kara-Tau Website Joomla	uitleg joomla	projectmanagement, Mambo security patches doorvoeren, deploy
UMC Documentbeheersysteem Analyse	analyse, overleg, uitwerking

-- IvanaCace - 11 Aug 2008