diff options
Diffstat (limited to 'history/migrate/3.4.0-4.0.0/pre.py')
| -rw-r--r-- | history/migrate/3.4.0-4.0.0/pre.py | 127 |
1 files changed, 0 insertions, 127 deletions
diff --git a/history/migrate/3.4.0-4.0.0/pre.py b/history/migrate/3.4.0-4.0.0/pre.py deleted file mode 100644 index 3e9f2bbf2d4..00000000000 --- a/history/migrate/3.4.0-4.0.0/pre.py +++ /dev/null @@ -1,127 +0,0 @@ -# -*- coding: utf-8 -*- -############################################################################## -# -# OpenERP, Open Source Management Solution -# Copyright (C) 2004-2009 Tiny SPRL (<http://tiny.be>). -# -# This program is free software: you can redistribute it and/or modify -# it under the terms of the GNU Affero General Public License as -# published by the Free Software Foundation, either version 3 of the -# License, or (at your option) any later version. -# -# This program is distributed in the hope that it will be useful, -# but WITHOUT ANY WARRANTY; without even the implied warranty of -# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the -# GNU Affero General Public License for more details. -# -# You should have received a copy of the GNU Affero General Public License -# along with this program. If not, see <http://www.gnu.org/licenses/>. -# -############################################################################## - -__author__ = 'Gaetan de Menten, <ged@tiny.be>' -__version__ = '0.1.0' - -import psycopg -import optparse -import ConfigParser - -# ----- - -parser = optparse.OptionParser(version="Tiny ERP server migration script " + __version__) - -parser.add_option("-c", "--config", dest="config", help="specify path to Tiny ERP config file") - -group = optparse.OptionGroup(parser, "Database related options") -group.add_option("--db_host", dest="db_host", help="specify the database host") -group.add_option("--db_port", dest="db_port", help="specify the database port") -group.add_option("-d", "--database", dest="db_name", help="specify the database name") -group.add_option("-r", "--db_user", dest="db_user", help="specify the database user name") -group.add_option("-w", "--db_password", dest="db_password", help="specify the database password") -parser.add_option_group(group) - -options = optparse.Values() -options.db_name = 'terp' # default value -parser.parse_args(values=options) - -if hasattr(options, 'config'): - configparser = ConfigParser.ConfigParser() - configparser.read([options.config]) - for name, value in configparser.items('options'): - if not (hasattr(options, name) and getattr(options, name)): - if value in ('true', 'True'): - value = True - if value in ('false', 'False'): - value = False - setattr(options, name, value) - -# ----- - -host = hasattr(options, 'db_host') and "host=%s" % options.db_host or '' -port = hasattr(options, 'db_port') and "port=%s" % options.db_port or '' -name = "dbname=%s" % options.db_name -user = hasattr(options, 'db_user') and "user=%s" % options.db_user or '' -password = hasattr(options, 'db_password') and "password=%s" % options.db_password or '' - -db = psycopg.connect('%s %s %s %s %s' % (host, port, name, user, password), serialize=0) -cr = db.cursor() - -# ------------------------- # -# change some columns types # -# ------------------------- # - -def change_column(cr, table, column, new_type, copy): - commands = [ - "ALTER TABLE %s RENAME COLUMN %s TO temp_column" % (table, column), - "ALTER TABLE %s ADD COLUMN %s %s" % (table, column, new_type), - "ALTER TABLE %s DROP COLUMN temp_column" % table - ] - if copy: - commands.insert( - 2, - "UPDATE %s SET %s=temp_column::%s" % (table, column, new_type)) - - for command in commands: - cr.execute(command) - -change_column(cr, 'crm_case', 'date_closed', 'timestamp', True) -cr.commit() - -# -------------------- # -# add module if needed # -# -------------------- # - -cr.execute("SELECT name FROM ir_module_module") -if not cr.rowcount: - for module in ('base', 'marketing', 'subscription', 'account', 'base_partner_relation', 'audittrail', 'account_followup', 'product', 'hr', 'l10n_simple', 'crm', 'stock', 'hr_timesheet', 'purchase', 'report_purchase', 'mrp', 'sale', 'report_sale', 'delivery', 'project', 'sale_crm', 'hr_timesheet_project', 'scrum', 'report_project'): - cr.execute("INSERT INTO ir_module_module (name, state) VALUES ('%s', 'installed')" % module) - cr.commit() - -# --------------- # -# remove old menu # -# --------------- # - -while True: - cr.execute("select id from ir_ui_menu where id not in (select parent_id from ir_ui_menu where parent_id is not null) and id not in (select res_id from ir_model_data where model='ir.ui.menu')") - if not cr.rowcount: - break - cr.execute("delete from ir_ui_menu where id not in (select parent_id from ir_ui_menu where parent_id is not null) and id not in (select res_id from ir_model_data where model='ir.ui.menu')") -cr.commit() - -# ----------------------------------------------------- # -# add some fields (which cannot be added automatically) # -# ----------------------------------------------------- # - -for line in ( - "ALTER TABLE ir_module_module ADD demo BOOLEAN", - "ALTER TABLE ir_module_module SET demo DEFAULT False", - "DELETE FROM ir_values WHERE VALUE LIKE '%,False'", - """UPDATE ir_ui_view set arch='<?xml version="1.0"?><tree string="Menu" toolbar="1"><field icon="icon" name="name"/></tree>' where name='ir.ui.menu.tree' and type='tree' and field_parent='child_id'""", - ): - cr.execute(line) - -cr.commit() -cr.close() - -# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: - |