From f97bae5c3e98ae91a30397a1927144c3f22f4d80 Mon Sep 17 00:00:00 2001 From: "P. Christeas" Date: Wed, 14 Jan 2009 10:03:35 +0200 Subject: SQL: help script to clean after missing ref data.. In devel environments, db elements get messy. Clean some. bzr revid: p_christ@hol.gr-20090114080335-xtfb13e3qcekh7fr --- sql/clean-model.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 sql/clean-model.sql (limited to 'sql') diff --git a/sql/clean-model.sql b/sql/clean-model.sql new file mode 100644 index 00000000000..7328f6b4909 --- /dev/null +++ b/sql/clean-model.sql @@ -0,0 +1,4 @@ + +SELECT model, res_id, module FROM ir_model_data + WHERE model = 'ir.actions.act_window' + AND NOT EXISTS (SELECT 1 FROM ir_act_window WHERE id = ir_model_data.res_id); \ No newline at end of file -- cgit v1.2.3 From 114872c3d74749377097df4ac5974989a3606288 Mon Sep 17 00:00:00 2001 From: "P. Christeas" Date: Fri, 16 Jan 2009 10:53:14 +0200 Subject: Some more example queries for SQL data clean. bzr revid: p_christ@hol.gr-20090116085314-xktvy3v7i5y5a0z6 --- sql/clean-model.sql | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) (limited to 'sql') diff --git a/sql/clean-model.sql b/sql/clean-model.sql index 7328f6b4909..9d1f2a8fb79 100644 --- a/sql/clean-model.sql +++ b/sql/clean-model.sql @@ -1,4 +1,9 @@ SELECT model, res_id, module FROM ir_model_data WHERE model = 'ir.actions.act_window' - AND NOT EXISTS (SELECT 1 FROM ir_act_window WHERE id = ir_model_data.res_id); \ No newline at end of file + AND NOT EXISTS (SELECT 1 FROM ir_act_window WHERE id = ir_model_data.res_id); + + +-- Other cleanups: +-- DELETE from ir_model_data where module = 'audittrail' AND model = 'ir.ui.view' AND NOT EXISTS( SELECT 1 FROM ir_ui_view WHERE ir_ui_view.id = ir_model_data.res_id); +-- DELETE from ir_model_data where module = 'audittrail' AND model = 'ir.ui.menu' AND NOT EXISTS( SELECT 1 FROM ir_ui_menu WHERE id = ir_model_data.res_id); \ No newline at end of file -- cgit v1.2.3 From 3b59f2eed07b9dac16dc01c789215fc03c445c25 Mon Sep 17 00:00:00 2001 From: "P. Christeas" Date: Mon, 26 Jan 2009 22:27:21 +0200 Subject: Better sql cleaners. bzr revid: p_christ@hol.gr-20090126202721-txt4sh40tbid59ae --- sql/clean-model.sql | 15 +++++++++++++++ 1 file changed, 15 insertions(+) (limited to 'sql') diff --git a/sql/clean-model.sql b/sql/clean-model.sql index 9d1f2a8fb79..59b492aab2d 100644 --- a/sql/clean-model.sql +++ b/sql/clean-model.sql @@ -4,6 +4,21 @@ SELECT model, res_id, module FROM ir_model_data AND NOT EXISTS (SELECT 1 FROM ir_act_window WHERE id = ir_model_data.res_id); +SELECT model, res_id, module FROM ir_model_data + WHERE model = 'ir.ui.menu' + AND NOT EXISTS (SELECT 1 FROM ir_ui_menu WHERE id = ir_model_data.res_id); + +SELECT model, res_id, module FROM ir_model_data + WHERE model = 'ir.ui.view' + AND NOT EXISTS (SELECT 1 FROM ir_ui_view WHERE id = ir_model_data.res_id); + +DONT DELETE FROM ir_model_data + WHERE model = 'ir.actions.act_window' + AND NOT EXISTS (SELECT 1 FROM ir_act_window WHERE id = ir_model_data.res_id); + +DONT DELETE FROM ir_model_data + WHERE model = 'ir.ui.menu' + AND NOT EXISTS (SELECT 1 FROM ir_ui_menu WHERE id = ir_model_data.res_id); -- Other cleanups: -- DELETE from ir_model_data where module = 'audittrail' AND model = 'ir.ui.view' AND NOT EXISTS( SELECT 1 FROM ir_ui_view WHERE ir_ui_view.id = ir_model_data.res_id); -- DELETE from ir_model_data where module = 'audittrail' AND model = 'ir.ui.menu' AND NOT EXISTS( SELECT 1 FROM ir_ui_menu WHERE id = ir_model_data.res_id); \ No newline at end of file -- cgit v1.2.3