1 # -*- coding: utf-8 -*-
2 ##############################################################################
4 # OpenERP, Open Source Management Solution
5 # Copyright (C) 2004-2009 Tiny SPRL (<http://tiny.be>).
7 # This program is free software: you can redistribute it and/or modify
8 # it under the terms of the GNU Affero General Public License as
9 # published by the Free Software Foundation, either version 3 of the
10 # License, or (at your option) any later version.
12 # This program is distributed in the hope that it will be useful,
13 # but WITHOUT ANY WARRANTY; without even the implied warranty of
14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 # GNU Affero General Public License for more details.
17 # You should have received a copy of the GNU Affero General Public License
18 # along with this program. If not, see <http://www.gnu.org/licenses/>.
20 ##############################################################################
22 #.apidoc title: Objects Services (OSV)
24 from functools import wraps
28 from psycopg2 import IntegrityError, OperationalError, errorcodes
32 import openerp.netsvc as netsvc
33 import openerp.pooler as pooler
34 import openerp.sql_db as sql_db
35 from openerp.tools.translate import translate
36 from openerp.osv.orm import MetaModel, Model, TransientModel, AbstractModel
37 import openerp.exceptions
43 _logger = logging.getLogger(__name__)
45 PG_CONCURRENCY_ERRORS_TO_RETRY = (errorcodes.LOCK_NOT_AVAILABLE, errorcodes.SERIALIZATION_FAILURE, errorcodes.DEADLOCK_DETECTED)
46 MAX_TRIES_ON_CONCURRENCY_FAILURE = 5
49 class except_osv(Exception):
50 def __init__(self, name, value):
53 self.args = (name, value)
57 class object_proxy(object):
64 def wrapper(self, dbname, *args, **kwargs):
65 """ Wraps around OSV functions and normalises a few exceptions
69 # We try to do the same as the _(), but without the frame
70 # inspection, since we aready are wrapping an osv function
71 # trans_obj = self.get('ir.translation') cannot work yet :(
74 if args and isinstance(args[-1], dict):
76 elif isinstance(kwargs, dict):
77 ctx = kwargs.get('context', {})
80 if args and isinstance(args[0], (long, int)):
83 lang = ctx and ctx.get('lang')
84 if not (lang or hasattr(src, '__call__')):
87 # We open a *new* cursor here, one reason is that failed SQL
88 # queries (as in IntegrityError) will invalidate the current one.
91 if hasattr(src, '__call__'):
92 # callable. We need to find the right parameters to call
93 # the orm._sql_message(self, cr, uid, ids, context) function,
95 # our signature is f(osv_pool, dbname [,uid, obj, method, args])
97 if args and len(args) > 1:
98 obj = self.get(args[1])
99 if len(args) > 3 and isinstance(args[3], (long, int, list)):
103 cr = sql_db.db_connect(dbname).cursor()
104 return src(obj, cr, uid, ids, context=(ctx or {}))
110 return False # so that the original SQL error will
111 # be returned, it is the best we have.
114 cr = sql_db.db_connect(dbname).cursor()
115 res = translate(cr, name=False, source_type=ttype,
116 lang=lang, source=src)
125 return tr(src, 'code')
130 if pooler.get_pool(dbname)._init:
131 raise except_osv('Database not ready', 'Currently, this database is not fully loaded and can not be used.')
132 return f(self, dbname, *args, **kwargs)
133 except OperationalError, e:
134 # Automatically retry the typical transaction serialization errors
135 if e.pgcode not in PG_CONCURRENCY_ERRORS_TO_RETRY:
137 if tries >= MAX_TRIES_ON_CONCURRENCY_FAILURE:
138 _logger.warning("%s, maximum number of tries reached" % errorcodes.lookup(e.pgcode))
140 wait_time = random.uniform(0.0, 2 ** tries)
142 _logger.info("%s, retry %d/%d in %.04f sec..." % (errorcodes.lookup(e.pgcode), tries, MAX_TRIES_ON_CONCURRENCY_FAILURE, wait_time))
143 time.sleep(wait_time)
144 except orm.except_orm, inst:
145 _, _, tb = sys.exc_info()
146 raise except_osv(inst.name, inst.value), None, tb
149 except IntegrityError, inst:
150 osv_pool = pooler.get_pool(dbname)
151 for key in osv_pool._sql_error.keys():
153 netsvc.abort_response(1, _('Constraint Error'), 'warning',
154 tr(osv_pool._sql_error[key], 'sql_constraint') or inst[0])
155 if inst.pgcode in (errorcodes.NOT_NULL_VIOLATION, errorcodes.FOREIGN_KEY_VIOLATION, errorcodes.RESTRICT_VIOLATION):
156 msg = _('The operation cannot be completed, probably due to the following:\n- deletion: you may be trying to delete a record while other records still reference it\n- creation/update: a mandatory field is not correctly set')
157 _logger.debug("IntegrityError", exc_info=True)
159 errortxt = inst.pgerror.replace('«','"').replace('»','"')
160 if '"public".' in errortxt:
161 context = errortxt.split('"public".')[1]
162 model_name = table = context.split('"')[1]
164 last_quote_end = errortxt.rfind('"')
165 last_quote_begin = errortxt.rfind('"', 0, last_quote_end)
166 model_name = table = errortxt[last_quote_begin+1:last_quote_end].strip()
167 model = table.replace("_",".")
168 model_obj = osv_pool.get(model)
170 model_name = model_obj._description or model_obj._name
171 msg += _('\n\n[object with reference: %s - %s]') % (model_name, model)
174 netsvc.abort_response(1, _('Integrity Error'), 'warning', msg)
176 netsvc.abort_response(1, _('Integrity Error'), 'warning', inst[0])
178 _logger.exception("Uncaught exception")
183 def execute_cr(self, cr, uid, obj, method, *args, **kw):
184 object = pooler.get_pool(cr.dbname).get(obj)
186 raise except_osv('Object Error', 'Object %s doesn\'t exist' % str(obj))
187 return getattr(object, method)(cr, uid, *args, **kw)
189 def execute_kw(self, db, uid, obj, method, args, kw=None):
190 return self.execute(db, uid, obj, method, *args, **kw or {})
193 def execute(self, db, uid, obj, method, *args, **kw):
194 cr = pooler.get_db(db).cursor()
197 if method.startswith('_'):
198 raise except_osv('Access Denied', 'Private methods (such as %s) cannot be called remotely.' % (method,))
199 res = self.execute_cr(cr, uid, obj, method, *args, **kw)
201 _logger.warning('The method %s of the object %s can not return `None` !', method, obj)
210 def exec_workflow_cr(self, cr, uid, obj, signal, *args):
211 object = pooler.get_pool(cr.dbname).get(obj)
213 raise except_osv('Object Error', 'Object %s doesn\'t exist' % str(obj))
215 return object._workflow_signal(cr, uid, [res_id], signal)[res_id]
218 def exec_workflow(self, db, uid, obj, signal, *args):
219 cr = pooler.get_db(db).cursor()
222 res = self.exec_workflow_cr(cr, uid, obj, signal, *args)
231 # deprecated - for backward compatibility.
233 osv_memory = TransientModel
234 osv_abstract = AbstractModel # ;-)
237 def start_object_proxy():
240 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: