[tryton-dev] SQL script to fix old database prior to 1.8

[Cédric Krier]

Hi,

plantian got issues to migrate an old database 1.8 due to a change in
the design of ir.action*

I wrote SQL script that fix the ids of all ir.action*, here it is for
the record.

-- 
Cédric Krier

B2CK SPRL
Rue de Rotterdam, 4
4000 Liège
Belgium
Tel: +32 472 54 46 59
Email/Jabber: cedric.kr...@b2ck.com
Website: http://www.b2ck.com/

BEGIN;

UPDATE ir_model_data AS m
SET db_id = a.action
FROM ir_action_report AS a
WHERE m.model = 'ir.action.report'
AND m.db_id = a.id;

UPDATE ir_action_report
SET id = action;

UPDATE ir_model_data AS m
SET db_id = a.action
FROM ir_action_wizard AS a
WHERE m.model = 'ir.action.wizard'
AND m.db_id = a.id;

UPDATE ir_action_wizard
SET id = action;

UPDATE ir_model_data AS m
SET db_id = a.action
FROM ir_action_url AS a
WHERE m.model = 'ir.action.url'
AND m.db_id = a.id;

UPDATE ir_action_url
SET id = action;

UPDATE ir_model_data AS m
SET db_id = a.action
FROM ir_action_act_window AS a
WHERE m.model = 'ir.action.act_window'
AND m.db_id = a.id;

ALTER TABLE ir_action_act_window_view
DROP CONSTRAINT ir_action_act_window_view_act_window_fkey;

UPDATE ir_action_act_window_view AS v
SET act_window = w.action
FROM ir_action_act_window AS w
WHERE v.act_window = w.id;

UPDATE ir_action_act_window
SET id = action;

ALTER TABLE ir_action_act_window_view
ADD CONSTRAINT ir_action_act_window_view_act_window_fkey
FOREIGN KEY (act_window) REFERENCES ir_action_act_window;

COMMIT;

pgppMCtfqdbJC.pgp
Description: PGP signature