diff options
| author | ced <> | 2007-09-14 13:42:11 +0000 |
|---|---|---|
| committer | ced <> | 2007-09-14 13:42:11 +0000 |
| commit | 26b7bb43f92ec6529b73935e473a5d18367cba7f (patch) | |
| tree | bc52621c9fd6a68dbfa0e035bef21552dfec3351 /doc | |
| parent | 5d9bd6a8d79036344bd761ba2cb82f96c5aa022d (diff) | |
Fix migration script for new res_bank
bzr revid: ced-3e3bbc39c351c4f94b2eca9e0c1247a22dba2c73
Diffstat (limited to 'doc')
| -rw-r--r-- | doc/migrate/4.0.0-4.2.0/pre.py | 28 |
1 files changed, 27 insertions, 1 deletions
diff --git a/doc/migrate/4.0.0-4.2.0/pre.py b/doc/migrate/4.0.0-4.2.0/pre.py index b9ab20a12ce..1ea4cea4738 100644 --- a/doc/migrate/4.0.0-4.2.0/pre.py +++ b/doc/migrate/4.0.0-4.2.0/pre.py @@ -177,11 +177,37 @@ cr.commit() cr.execute('SELECT a.attname FROM pg_class c, pg_attribute a, pg_type t WHERE c.relname = \'product_uom\' AND a.attname = \'factor\' AND c.oid = a.attrelid AND a.atttypid = t.oid AND t.typname = \'float8\'') if cr.fetchall(): + cr.execute('SELECT viewname FROM pg_views WHERE viewname = \'report_account_analytic_planning_stat_account\'') + if cr.fetchall(): + cr.execute('DROP VIEW report_account_analytic_planning_stat_account') + cr.execute('SELECT viewname FROM pg_views WHERE viewname = \'report_account_analytic_planning_stat\'') + if cr.fetchall(): + cr.execute('DROP VIEW report_account_analytic_planning_stat') + cr.execute('SELECT viewname FROM pg_views WHERE viewname = \'report_account_analytic_planning_stat_user\'') + if cr.fetchall(): + cr.execute('DROP VIEW report_account_analytic_planning_stat_user') + cr.execute('SELECT viewname FROM pg_views WHERE viewname = \'report_purchase_order_product\'') + if cr.fetchall(): + cr.execute('DROP VIEW report_purchase_order_product') + cr.execute('SELECT viewname FROM pg_views WHERE viewname = \'report_purchase_order_category\'') + if cr.fetchall(): + cr.execute('DROP VIEW report_purchase_order_category') + cr.execute('SELECT viewname FROM pg_views WHERE viewname = \'report_sale_order_product\'') + if cr.fetchall(): + cr.execute('DROP VIEW report_sale_order_product') + cr.execute('SELECT viewname FROM pg_views WHERE viewname = \'report_sale_order_category\'') + if cr.fetchall(): + cr.execute('DROP VIEW report_sale_order_category') + cr.execute('SELECT viewname FROM pg_views WHERE viewname = \'report_hr_timesheet_invoice_journal\'') + if cr.fetchall(): + cr.execute('DROP VIEW report_hr_timesheet_invoice_journal') + cr.execute('ALTER TABLE product_uom RENAME COLUMN factor to temp_column') cr.execute('ALTER TABLE product_uom ADD COLUMN factor NUMERIC(12,6)') cr.execute('UPDATE product_uom SET factor = temp_column') - cr.execute('ALTER TABLE product_uom SET factor NOT NULL') + cr.execute('ALTER TABLE product_uom ALTER factor SET NOT NULL') cr.execute('ALTER TABLE product_uom DROP COLUMN temp_column') +cr.commit() # ------------------------------------------------- # |