diff options
| author | Fabien Pinckaers <fp@tinyerp.com> | 2007-12-18 12:37:59 +0000 |
|---|---|---|
| committer | Fabien Pinckaers <fp@tinyerp.com> | 2007-12-18 12:37:59 +0000 |
| commit | cc2d3de1bd798975d48c8de5adf3b593aed30117 (patch) | |
| tree | a02491ec43bc1ce1403f8b3130f8d30663cd9c65 /doc/migrate | |
| parent | 5c9688d74299e8c2d3a56a2309a9f5f7e46dd3ca (diff) | |
Modifications
bzr revid: fp@tinyerp.com-25c1dc66ea09209b6b356c3460108e8e9a895ff1
Diffstat (limited to 'doc/migrate')
| -rw-r--r-- | doc/migrate/4.0.0-4.2.0/pre.py | 22 | ||||
| -rw-r--r-- | doc/migrate/4.2.0-4.4.0/pre.py | 22 |
2 files changed, 22 insertions, 22 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 67901c45d9d..49ed2fc835e 100644 --- a/doc/migrate/4.0.0-4.2.0/pre.py +++ b/doc/migrate/4.0.0-4.2.0/pre.py @@ -248,26 +248,4 @@ 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 diff --git a/doc/migrate/4.2.0-4.4.0/pre.py b/doc/migrate/4.2.0-4.4.0/pre.py index b886b074a0a..f04a1881a5d 100644 --- a/doc/migrate/4.2.0-4.4.0/pre.py +++ b/doc/migrate/4.2.0-4.4.0/pre.py @@ -82,4 +82,26 @@ cr.execute('ALTER TABLE ir_attachment \ ALTER COLUMN res_id DROP NOT NULL') cr.commit() +# ---------------------------------- # +# change case date_deadline 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 |