Merge lp:~pedro.baeza/openupgrade-addons/7.0-project into lp:openupgrade-addons

[Pedro Manuel Baeza]

[ADD] project: Analysis work and migration scripts.

[Holger Brunn (Therp) (hbrunn)]

Concerning warn_*: I'd say that should be managed by subscriptions now?

#179 are you aware of postgres' update from construction? That would save you the subquery here:
update project_project set state=%s from account_analytic_account where account_analytic_account.id = project_project.analytic_account_id

review: Approve

[Sandy Carter (http://www.savoirfairelinux.com) (sandy-carter)]

PEP8
l.225 l.271

I would like to test this more in depth eventually.

review: Needs Fixing (code review, pep8)

[Pedro Manuel Baeza (pedro.baeza)]

Changes according your comments have been done.

Regards.

[Sandy Carter (http://www.savoirfairelinux.com) (sandy-carter)]

review: Approve (code review, no test)

=== added file 'project/migrations/7.0.1.1/openupgrade_analysis_work.txt'
--- project/migrations/7.0.1.1/openupgrade_analysis_work.txt	1970-01-01 00:00:00 +0000
+++ project/migrations/7.0.1.1/openupgrade_analysis_work.txt	2014-03-27 16:20:36 +0000
@@ -0,0 +1,144 @@
+---Fields in module 'project'---
+project      / account.analytic.account / use_tasks (boolean)           : NEW 
+### -> New field to indicate to use tasks in the project. It can be default to False. (Nothing to do)
+
+project      / project.category         / name (char)                   : NEW required: required
+project      / project.task             / categ_ids (many2many)         : NEW relation: project.category
+### -> New complete model for categorizing tasks. It can be none category. (Nothing to do)
+
+project      / project.project          / state (selection)             : NEW required: required, selection_keys: ['cancelled', 'close', 'draft', 'open', 'pending', 'template'], req_default: open
+### -> This state field has been moved from analytic account to the project. Done.
+
+project      / project.task             / stage_id (many2one)           : NEW relation: project.task.type
+project      / project.task             / type_id (many2one)            : DEL relation: project.task.type
+### -> Column rename. Done.
+
+project      / project.task.type        / case_default (boolean)        : NEW 
+project      / project.task.type        / project_default (boolean)     : DEL 
+### -> Column rename. Done.
+
+project      / project.project          / warn_customer (boolean)       : DEL 
+project      / project.project          / warn_footer (text)            : DEL 
+project      / project.project          / warn_header (text)            : DEL 
+project      / project.project          / warn_manager (boolean)        : DEL 
+### -> #TODO: Deleted fields, difficult to translate to the new system. Rarely used.
+
+project      / project.task             / state (selection)             : now a function
+project      / project.task.type        / state (selection)             : NEW required: required, selection_keys: ['cancelled', 'done', 'draft', 'open', 'pending'], req_default: open
+### -> #TODO: State field has been added on the stage, and state field in task is define as a function.
+### -> It can be queried previous state from tasks and deduced state value for the stage.
+
+project      / project.project          / alias_id (many2one)           : NEW relation: mail.alias, required: required
+project      / project.project          / alias_model (selection)       : NEW required: required, selection_keys: function, req_default: project.task
+### -> Alias for mail messages. Force creation on migration. Done.
+
+project      / project.project          / color (integer)               : NEW 
+### -> Optional field for color projects. (Nothing to do)
+
+project      / project.project          / privacy_visibility (selection): NEW required: required, selection_keys: ['followers', 'public'], req_default: public
+### -> New required field with default. (Nothing to do)
+
+project      / project.task.history.cumulative / project_id (many2one)         : not a function anymore
+### -> Now a related field. (Nothing to do)
+
+project      / project.task.type        / fold (boolean)                : NEW 
+### -> Optional field. Default to False is OK. (Nothing to do)
+
+project      / report.project.task.user / type_id (many2one)            : DEL relation: project.task.type
+### -> Removed field in a table view. (Nothing to do)
+
+project      / res.users                / context_project_id (many2one) : DEL relation: project.project
+### -> Useless field removed. (Nothing to do)
+
+---XML records in module 'project'---
+NEW ir.actions.act_window: project.action_config_settings
+DEL ir.actions.act_window: project.act_my_account
+DEL ir.actions.act_window: project.act_my_project
+DEL ir.actions.act_window: project.act_res_users_2_project_project
+DEL ir.actions.act_window: project.action_create_initial_projects_installer
+DEL ir.actions.act_window: project.action_project_vs_remaining_hours_graph
+DEL ir.actions.act_window: project.action_review_task_stage
+DEL ir.actions.act_window: project.action_task_by_days_graph
+DEL ir.actions.act_window: project.action_view_delegate_task_tree
+DEL ir.actions.act_window: project.action_view_task_history_burndown
+DEL ir.actions.act_window: project.action_view_task_tree_deadline
+DEL ir.actions.act_window.view: project.open_view_project_vs_remaining_hours_graph
+DEL ir.actions.act_window.view: project.open_view_project_vs_remaining_hours_tree
+NEW ir.actions.client: project.action_client_project_menu
+### -> Deleted and added window and client actions. (Nothing to do)
+
+NEW ir.actions.todo: base.open_menu
+DEL ir.actions.todo: project.config_wizard_action_create_initial_projects_installer
+DEL ir.actions.todo: project.config_wizard_action_review_task_stage
+DEL ir.actions.todo.category: project.category_project_config
+### -> Changed configuration wizards. (Nothing to do)
+
+NEW ir.model.access: project.access_account_analytic_account_user
+NEW ir.model.access: project.access_project_category
+NEW ir.model.access: project.access_project_category_manager
+NEW ir.model.access: project.access_project_project_manager
+NEW ir.model.access: project.access_project_task_history_sale_user
+NEW ir.model.access: project.access_project_task_type_sale_user
+DEL ir.model.access: project.access_mail_message_project_user
+DEL ir.model.access: project.access_partner_address_task user
+DEL ir.model.access: project.access_project_vs_hours
+DEL ir.model.access: project.access_task_by_days
+NEW ir.rule: project.project_public_members_rule
+### -> Changed security rules. (Nothing to do)
+
+NEW ir.ui.menu: base.menu_definitions
+NEW ir.ui.menu: base.menu_project_config
+NEW ir.ui.menu: base.menu_project_config_project
+NEW ir.ui.menu: project.menu_project_dashboard
+NEW ir.ui.menu: project.menu_projects
+DEL ir.ui.menu: project.menu_action_view_task_history_burndown
+DEL ir.ui.menu: project.menu_board_project
+DEL ir.ui.menu: project.menu_definitions
+DEL ir.ui.menu: project.menu_open_view_project_all
+DEL ir.ui.menu: project.menu_project_config_project
+DEL ir.ui.menu: project.next_id_86
+DEL ir.ui.menu: project.project_report_task
+### -> Changed menus. (Nothing to do)
+
+NEW ir.ui.view: project.analytic_account_inherited_form
+NEW ir.ui.view: project.view_config_settings
+NEW ir.ui.view: project.view_project_kanban
+DEL ir.ui.view: base.view_crm_partner_info_History
+DEL ir.ui.view: project.view_delegated_task_tree
+DEL ir.ui.view: project.view_project_users_form_simple
+DEL ir.ui.view: project.view_project_vs_planned_total_hours_graph
+DEL ir.ui.view: project.view_project_vs_planned_total_hours_tree
+DEL ir.ui.view: project.view_project_vs_remaining_hours_graph
+DEL ir.ui.view: project.view_project_vs_remaining_hours_tree
+DEL ir.ui.view: project.view_task_by_days_graph
+DEL ir.ui.view: project.view_task_by_days_tree
+DEL ir.ui.view: project.view_task_history_burndown_graph
+DEL ir.ui.view: project.view_users_form_project_modif_inherited1
+### -> Changed views. (Nothing to do)
+
+NEW mail.message: project.module_install_notification
+NEW mail.message.subtype: project.mt_project_task_blocked
+NEW mail.message.subtype: project.mt_project_task_closed
+NEW mail.message.subtype: project.mt_project_task_new
+NEW mail.message.subtype: project.mt_project_task_stage
+NEW mail.message.subtype: project.mt_project_task_started
+NEW mail.message.subtype: project.mt_task_blocked
+NEW mail.message.subtype: project.mt_task_closed
+NEW mail.message.subtype: project.mt_task_new
+NEW mail.message.subtype: project.mt_task_stage
+NEW mail.message.subtype: project.mt_task_started
+### -> Chatter functions. (Nothing to do)
+
+NEW project.task.type: project.project_tt_analysis
+NEW project.task.type: project.project_tt_cancel
+NEW project.task.type: project.project_tt_deployment
+NEW project.task.type: project.project_tt_design
+### -> New task stages. (Nothing to do)
+
+NEW res.company: base.main_company
+### -> Company alias. (Nothing to do)
+
+NEW res.groups: project.group_delegate_task
+NEW res.groups: project.group_tasks_work_on_tasks
+NEW res.groups: project.group_time_work_estimation_tasks
+### -> New security groups. (Nothing to do)

=== added file 'project/migrations/7.0.1.1/post-migration.py'
--- project/migrations/7.0.1.1/post-migration.py	1970-01-01 00:00:00 +0000
+++ project/migrations/7.0.1.1/post-migration.py	2014-03-27 16:20:36 +0000
@@ -0,0 +1,70 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+# OpenERP, Open Source Management Solution
+# This migration script copyright (C) 2014
+# Pedro M. Baeza ([e-mail])
+#
+# This program is free software: you can redistribute it and/or modify
+# it under the terms of the GNU Affero General Public License as
+# published by the Free Software Foundation, either version 3 of the
+# License, or (at your option) any later version.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+# GNU Affero General Public License for more details.
+#
+# You should have received a copy of the GNU Affero General Public License
+# along with this program. If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+from openupgrade import openupgrade
+from openerp import pooler, SUPERUSER_ID
+
+def copy_state_from_analytic_account(cr):
+    openupgrade.logged_query(cr, """
+        UPDATE project_project
+        SET state = account_analytic_account.%s
+        FROM project_project
+        INNER JOIN account_analytic_account
+        ON account_analytic_account.id = project_project.analytic_account_id
+        WHERE analytic_account_id is not NULL
+        """ %(openupgrade.get_legacy_name('state')))
+
+def short_name(name):
+    """Keep first word(s) of name to make it small enough
+       but distinctive"""
+    if not name: return name
+    # keep 7 chars + end of the last word
+    keep_words = name[:7].strip().split()
+    return ' '.join(name.split()[:len(keep_words)])
+
+def createProjectAliases(cr, pool):
+    alias_obj = pool.get('mail.alias')
+    project_obj = pool.get('project.project')
+    cr.execute("""
+    SELECT project_project.id, account_analytic_account.name
+    FROM project_project, account_analytic_account
+    WHERE account_analytic_account.name is not NULL
+    AND project_project.alias_id is NULL
+    AND project_project.analytic_account_id = account_analytic_account.id
+    """)
+    for (id, name) in cr.fetchall():
+        alias_id = alias_obj.create_unique_alias(cr, SUPERUSER_ID,
+                              {'alias_name': "project+" + short_name(name)},
+                              model_name='project.task')
+        cr.execute("""
+            UPDATE project_project
+            SET alias_id=%s
+            WHERE id=%s
+            """, (alias_id, id))
+
[e-mail]()
+def migrate(cr, version):
+    if not version:
+        return
+    pool = pooler.get_pool(cr.dbname)
+    copy_state_from_analytic_account(cr)
+    createProjectAliases(cr, pool)
+    openupgrade.logged_query(cr,'DROP VIEW project_vs_hours')

=== added file 'project/migrations/7.0.1.1/pre-migration.py'
--- project/migrations/7.0.1.1/pre-migration.py	1970-01-01 00:00:00 +0000
+++ project/migrations/7.0.1.1/pre-migration.py	2014-03-27 16:20:36 +0000
@@ -0,0 +1,40 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+# OpenERP, Open Source Management Solution
+# This migration script copyright (C) 2014
+# Pedro M. Baeza ([e-mail])
+#
+# This program is free software: you can redistribute it and/or modify
+# it under the terms of the GNU Affero General Public License as
+# published by the Free Software Foundation, either version 3 of the
+# License, or (at your option) any later version.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+# GNU Affero General Public License for more details.
+#
+# You should have received a copy of the GNU Affero General Public License
+# along with this program. If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+from openupgrade import openupgrade
+
+column_renames = {
+    'account_analytic_account':[
+        ('state', None),
+    ],
+    'project_task':[
+        ('type_id', 'stage_id'),
+    ],
+    'project_task_type':[
+        ('project_default', 'case_default'),
+    ],
+}
+
[e-mail]()
+def migrate(cr, version):
+    if not version:
+        return
+    openupgrade.rename_columns(cr, column_renames)

=== added file 'project/migrations/7.0.1.1/user_notes.txt'
--- project/migrations/7.0.1.1/user_notes.txt	1970-01-01 00:00:00 +0000
+++ project/migrations/7.0.1.1/user_notes.txt	2014-03-27 16:20:36 +0000
@@ -0,0 +1,11 @@
+********************************************************************************
+1/ If you have defined custom project stages (project.task.type), related state
+will be set default to open, and related task will have this state. If you
+want to set them to another state, you will have to do it manually.
+
+2/ Project warning messages when you close tasks are lost in the migration,
+because they are not easily translated to the new system, so you will have to
+rewrite them on v7.
+
+3/ All projects are set by default to public visibility. Change manually
+on each project accordingly new possibilities and your needs.