diff options
| author | Fabien Pinckaers <fp@tinyerp.com> | 2007-12-17 20:25:36 +0000 |
|---|---|---|
| committer | Fabien Pinckaers <fp@tinyerp.com> | 2007-12-17 20:25:36 +0000 |
| commit | aa8c0e4ad916749a4eacfa38390c13f3ac46d245 (patch) | |
| tree | 8ffcb9f20f9d1a936e2c7c600bb74e9e31ab7b10 /doc | |
| parent | 909e58578d08a337e788f8a41e2b21039a535b21 (diff) | |
Migration update for crm module change
bzr revid: fp@tinyerp.com-a9432763a5041da0d4a694cf7171231b57a97490
Diffstat (limited to 'doc')
| -rw-r--r-- | doc/migrate/4.0.0-4.2.0/pre.py | 22 |
1 files changed, 22 insertions, 0 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 49ed2fc835e..67901c45d9d 100644 --- a/doc/migrate/4.0.0-4.2.0/pre.py +++ b/doc/migrate/4.0.0-4.2.0/pre.py @@ -248,4 +248,26 @@ if not cr.fetchall(): cr.execute('ALTER TABLE ir_act_wizard ADD PRIMARY KEY (id)') cr.commit() +# ------------------------ # +# change currency rounding # +# ------------------------ # + +cr.execute("""SELECT +c.relname,a.attname,a.attlen,a.atttypmod,a.attnotnull,a.atthasdef,t.typname,CASE +WHEN a.attlen=-1 THEN a.atttypmod-4 ELSE a.attlen END as size FROM pg_class +c,pg_attribute a,pg_type t WHERE c.relname='crm_case' AND +a.attname='date_deadline' AND c.oid=a.attrelid AND a.atttypid=t.oid""") + +res = cr.dictfetchall() +if res[0]['typname'] != 'timestamp': + for line in ( + "ALTER TABLE crm_case RENAME date_deadline TO date_deadline_bak", + "ALTER TABLE crm_case ADD date_deadline timestamp", + "UPDATE crm_case SET date_deadline = date_deadline_bak", + "ALTER TABLE crm_case DROP date_deadline_bak", + ): + cr.execute(line) +cr.commit() + + cr.close |