credativ team mailing list archive

["Stefan Rijnhart \(Therp\)" <stefan@xxxxxxxx>]

Stefan Rijnhart (Therp) has proposed merging lp:~openupgrade-committers/openupgrade-addons/7.0-account_analytic_plans-pedro.baeza into lp:openupgrade-addons.

Requested reviews:
  OpenUpgrade Committers (openupgrade-committers)

For more details, see:
https://code.launchpad.net/~openupgrade-committers/openupgrade-addons/7.0-account_analytic_plans-pedro.baeza/+merge/210213

Reup of https://code.launchpad.net/~pedro.baeza/openupgrade-addons/7.0-account_analytic_plans/+merge/209051
-- 
https://code.launchpad.net/~openupgrade-committers/openupgrade-addons/7.0-account_analytic_plans-pedro.baeza/+merge/210213
Your team OpenUpgrade Committers is requested to review the proposed merge of lp:~openupgrade-committers/openupgrade-addons/7.0-account_analytic_plans-pedro.baeza into lp:openupgrade-addons.

=== added file 'account_analytic_plans/migrations/7.0.1.0/openupgrade_analysis_work.txt'
--- account_analytic_plans/migrations/7.0.1.0/openupgrade_analysis_work.txt	1970-01-01 00:00:00 +0000
+++ account_analytic_plans/migrations/7.0.1.0/openupgrade_analysis_work.txt	2014-03-10 14:28:39 +0000
@@ -0,0 +1,10 @@
+---Fields in module 'account_analytic_plans'---
+account_analytic_plans / account.analytic.plan.line / plan_id (many2one)            : now required
+### -> Created script for filling it for empty values
+
+---XML records in module 'account_analytic_plans'---
+DEL account.journal.column: account.journal_col11
+DEL ir.actions.act_window: account_analytic_plans.account_analytic_plan_form_action_installer
+DEL ir.actions.todo: account_analytic_plans.account_analytic_plan_installer_todo
+### -> Nothing to do
+

=== added file 'account_analytic_plans/migrations/7.0.1.0/pre-migration.py'
--- account_analytic_plans/migrations/7.0.1.0/pre-migration.py	1970-01-01 00:00:00 +0000
+++ account_analytic_plans/migrations/7.0.1.0/pre-migration.py	2014-03-10 14:28:39 +0000
@@ -0,0 +1,44 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    This migration script copyright (C) 2014
+#            Pedro M. Baeza (pedro.baeza@xxxxxxxxxxxxxxxxxx)
+#
+#    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
+
+@openupgrade.migrate()
+def migrate(cr, version):
+    # look for account.analytic.plan.line without plan_id
+    cr.execute("""
+        SELECT id
+        FROM account_analytic_plan_line
+        WHERE plan_id is NULL""")
+    record = cr.fetchone()
+    if record:
+        # Create support plan 
+        logged_query(cr, ("""
+            INSERT INTO account_analytic_plan ('name')
+            FROM account_analytic_plan_line
+            VALUES ('OpenUpgrade migration plan')""")
+        # Fill empty values with this new record value
+        logged_query(cr, ("""
+            UPDATE account_analytic_plan_line
+            SET plan_id = 
+                (SELECT id FROM account_analytic_plan 
+                 WHERE NAME='OpenUpgrade migration plan')
+            WHERE plan_id is NULL""")