Willy Andres Gomez Solorzano has proposed merging lp:~wg.clearcorp/openerp-ccorp-addons/6.1-instance-generic-merge into lp:openerp-ccorp-addons.
Requested reviews: Ronald Rubi (rr.clearcorp) For more details, see: https://code.launchpad.net/~wg.clearcorp/openerp-ccorp-addons/6.1-instance-generic-merge/+merge/144171 Added generic-instance-merge for changing references from one instance to another. -- https://code.launchpad.net/~wg.clearcorp/openerp-ccorp-addons/6.1-instance-generic-merge/+merge/144171 Your team CLEARCORP development team is subscribed to branch lp:openerp-ccorp-addons.
=== added directory 'generic_instance_merge' === added file 'generic_instance_merge/__init__.py' --- generic_instance_merge/__init__.py 1970-01-01 00:00:00 +0000 +++ generic_instance_merge/__init__.py 2013-01-21 19:37:21 +0000 @@ -0,0 +1,23 @@ +# -*- coding: utf-8 -*- +############################################################################## +# +# OpenERP, Open Source Management Solution +# Addons modules by CLEARCORP S.A. +# Copyright (C) 2009-TODAY CLEARCORP S.A. (<http://clearcorp.co.cr>). +# +# 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/>. +# +############################################################################## + +import generic_instance_merge === added file 'generic_instance_merge/__openerp__.py' --- generic_instance_merge/__openerp__.py 1970-01-01 00:00:00 +0000 +++ generic_instance_merge/__openerp__.py 2013-01-21 19:37:21 +0000 @@ -0,0 +1,42 @@ +# -*- coding: utf-8 -*- +############################################################################## +# +# OpenERP, Open Source Management Solution +# Addons modules by CLEARCORP S.A. +# Copyright (C) 2009-TODAY CLEARCORP S.A. (<http://clearcorp.co.cr>). +# +# 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/>. +# +############################################################################## + + +{ + 'name': 'Generic Instance Merge', + 'description': """ +This a library with a method to merge instances from a given object and update references,it doesn't do anything on its own. + """, + 'version': '1.0', + 'author': 'CLEARCORP S.A.', + 'category': 'Hidden', + 'website': "http://clearcorp.co.cr";, + 'images': [], + 'depends': [], + 'init_xml': [], + 'demo_xml' : [], + 'update_xml': [], + 'test': [], + 'active': False, + 'installable': True, + 'license': 'AGPL-3', +} === added file 'generic_instance_merge/generic_instance_merge.py' --- generic_instance_merge/generic_instance_merge.py 1970-01-01 00:00:00 +0000 +++ generic_instance_merge/generic_instance_merge.py 2013-01-21 19:37:21 +0000 @@ -0,0 +1,40 @@ +import copy +import netsvc +from osv import fields, orm +import tools +from tools.translate import _ + +class generic_instance_merge(orm.Model): + _name = "generic.instance.merge" + _description = "Generic merging Library" + + def merge(self, cr, uid,obj_class, id, ids, delete_merged=False, context=None): + obj_class = obj_class.replace(".","_") + dependencies_query = 'SELECT A.relname AS tabla, C.attname AS columna, B.relname AS tabla_foranea, D.attname AS columna_foranea ' \ + 'FROM pg_catalog.pg_constraint, pg_catalog.pg_class AS A, pg_catalog.pg_class AS B, pg_catalog.pg_attribute C, pg_catalog.pg_attribute D ' \ + 'WHERE contype = '+"\'"+'f'+"\' "\ + 'AND conrelid = A.oid '\ + 'AND confrelid = B.oid '\ + 'AND conrelid = C.attrelid '\ + 'AND confrelid = D.attrelid '\ + 'AND C.attnum = pg_catalog.pg_constraint.conkey[1] '\ + 'AND D.attnum = pg_catalog.pg_constraint.confkey[1] '\ + 'AND B.relname ='+"\'"+ obj_class +"\' " \ + 'AND D.attname ='+"\'id\' " \ + 'ORDER BY tabla, columna, tabla_foranea, columna_foranea;' + cr.execute(dependencies_query) + for line in cr.fetchall(): + referencing_table = line[0] + referencing_field = line[1] + for merging_id in ids: + update_query="UPDATE "+ referencing_table + \ + " SET "+ referencing_field +" = "+ str(id) + \ + " WHERE "+ referencing_field +" = "+ str(merging_id) + cr.execute(update_query) + if delete_merged: + for deleting_id in ids: + if deleting_id != id: + delete_query = "DELETE FROM "+ obj_class + \ + " WHERE id = "+ str(deleting_id) + cr.execute(delete_query) + return True
_______________________________________________ Mailing list: https://launchpad.net/~clearcorp Post to : [email protected] Unsubscribe : https://launchpad.net/~clearcorp More help : https://help.launchpad.net/ListHelp
