def trg_validate(self, uid, res_type, res_id, signal, cr): result = False ident = (uid,res_type,res_id) # ids of all active workflow instances for a corresponding resource (id, model_nam) cr.execute('select id from wkf_instance where res_id=%s and res_type=%s and state=%s', (res_id, res_type, 'active')) for (id,) in cr.fetchall(): res2 = instance.validate(cr, id, ident, signal) result = result or res2 return result
def trg_validate(self, uid, res_type, res_id, signal, cr): """ Fire a signal on a given workflow instance :param res_type: the model name :param res_id: the model instance id the workflow belongs to :signal: the signal name to be fired :param cr: a database cursor """ result = False ident = (uid,res_type,res_id) # ids of all active workflow instances for a corresponding resource (id, model_nam) cr.execute('select id from wkf_instance where res_id=%s and res_type=%s and state=%s', (res_id, res_type, 'active')) for (id,) in cr.fetchall(): res2 = instance.validate(cr, id, ident, signal) result = result or res2 return result
def _execute(cr, workitem, activity, ident, stack): result = True # # send a signal to parent workflow (signal: subflow.signal_name) # signal_todo = [] if (workitem['state']=='active') and activity['signal_send']: cr.execute("select i.id,w.osv,i.res_id from wkf_instance i left join wkf w on (i.wkf_id=w.id) where i.id IN (select inst_id from wkf_workitem where subflow_id=%s)", (workitem['inst_id'],)) for i in cr.fetchall(): signal_todo.append((i[0], (ident[0],i[1],i[2]), activity['signal_send'])) if activity['kind']=='dummy': if workitem['state']=='active': _state_set(cr, workitem, activity, 'complete', ident) if activity['action_id']: res2 = wkf_expr.execute_action(cr, ident, workitem, activity) if res2: stack.append(res2) result=res2 elif activity['kind']=='function': if workitem['state']=='active': _state_set(cr, workitem, activity, 'running', ident) returned_action = wkf_expr.execute(cr, ident, workitem, activity) if type(returned_action) in (dict,): stack.append(returned_action) if activity['action_id']: res2 = wkf_expr.execute_action(cr, ident, workitem, activity) # A client action has been returned if res2: stack.append(res2) result=res2 _state_set(cr, workitem, activity, 'complete', ident) elif activity['kind']=='stopall': if workitem['state']=='active': _state_set(cr, workitem, activity, 'running', ident) cr.execute('delete from wkf_workitem where inst_id=%s and id<>%s', (workitem['inst_id'], workitem['id'])) if activity['action']: wkf_expr.execute(cr, ident, workitem, activity) _state_set(cr, workitem, activity, 'complete', ident) elif activity['kind']=='subflow': if workitem['state']=='active': _state_set(cr, workitem, activity, 'running', ident) if activity.get('action', False): id_new = wkf_expr.execute(cr, ident, workitem, activity) if not id_new: cr.execute('delete from wkf_workitem where id=%s', (workitem['id'],)) return False assert type(id_new)==type(1) or type(id_new)==type(1L), 'Wrong return value: '+str(id_new)+' '+str(type(id_new)) cr.execute('select id from wkf_instance where res_id=%s and wkf_id=%s', (id_new,activity['subflow_id'])) id_new = cr.fetchone()[0] else: id_new = instance.create(cr, ident, activity['subflow_id']) cr.execute('update wkf_workitem set subflow_id=%s where id=%s', (id_new, workitem['id'])) workitem['subflow_id'] = id_new if workitem['state']=='running': cr.execute("select state from wkf_instance where id=%s", (workitem['subflow_id'],)) state= cr.fetchone()[0] if state=='complete': _state_set(cr, workitem, activity, 'complete', ident) for t in signal_todo: instance.validate(cr, t[0], t[1], t[2], force_running=True) return result
def _execute(cr, workitem, activity, ident, stack): """ Execute wkf_activity's action on a given workitem @param cr: database handle @param workitem: dict of the wkf_workitem to process @param activity: dict of the wkf_activity @param ident: tuple of (uid, dotted model name, resource id ) @param stack: ??? There are 4 different types of activities: * dummy: blank state, no processing required stack is used to return data from an ir.act.server function call if action_id is set * function: executes a particular function on a workitem note that while the function is executing the system will mark the wkf_workitem's state as 'running' to prevent doubled up work * stopall: deletes the current workitem from the database * subflow: creates a new subflow if required """ result = True # # send a signal to parent workflow (signal: subflow.signal_name) # signal_todo = [] if (workitem['state'] == 'active') and activity['signal_send']: cr.execute( "select i.id,w.osv,i.res_id from wkf_instance i left join wkf w on (i.wkf_id=w.id) where i.id IN (select inst_id from wkf_workitem where subflow_id=%s)", (workitem['inst_id'], )) for i in cr.fetchall(): signal_todo.append( (i[0], (ident[0], i[1], i[2]), activity['signal_send'])) if config['debug_workflow']: exec_started = datetime.datetime.now() _logger.debug(" execute {a[kind]} {i[1]},{i[2]} {d}".format( i=ident, w=workitem, a=activity, d=exec_started)) # ACTIVITY: dummy if activity['kind'] == 'dummy': if workitem['state'] == 'active': _state_set(cr, workitem, activity, 'complete', ident) if activity['action_id']: res2 = wkf_expr.execute_action(cr, ident, workitem, activity) if res2: stack.append(res2) result = res2 # ACTIVITY: function elif activity['kind'] == 'function': if workitem['state'] == 'active': if config['debug_workflow']: _logger.debug(" function {i[1]},{i[2]}: {a[action]}".format( i=ident, w=workitem, a=activity)) _state_set(cr, workitem, activity, 'running', ident) returned_action = wkf_expr.execute(cr, ident, workitem, activity) if type(returned_action) in (dict, ): stack.append(returned_action) if activity['action_id']: res2 = wkf_expr.execute_action(cr, ident, workitem, activity) # A client action has been returned if res2: stack.append(res2) result = res2 _state_set(cr, workitem, activity, 'complete', ident) # ACTIVITY: stopall elif activity['kind'] == 'stopall': if workitem['state'] == 'active': _state_set(cr, workitem, activity, 'running', ident) cr.execute('delete from wkf_workitem where inst_id=%s and id<>%s', (workitem['inst_id'], workitem['id'])) if activity['action']: wkf_expr.execute(cr, ident, workitem, activity) _state_set(cr, workitem, activity, 'complete', ident) # ACTIVITY: subflow elif activity['kind'] == 'subflow': # If the state is currently marked as 'active' it means that the node # has yet to start the subflow. So let's create it. if workitem['state'] == 'active': _state_set(cr, workitem, activity, 'running', ident) # action will be a python function on the wkf_instance's res_type model # What we expect from this function is the new target record's ID # As we expect that the new record will have its own workflow, we just # need to know what workflow this object will be launched into. We know # the new record's workflow id because the current wkf_activity has # wkf_activity.subflow_id references the target sub-object's wkf record if activity.get('action', False): id_new = wkf_expr.execute(cr, ident, workitem, activity) # If we don't get a new record id, stop the workflow and drop out if not (id_new): cr.execute('delete from wkf_workitem where id=%s', (workitem['id'], )) return False assert type(id_new) == type(1) or type(id_new) == type( 1L), 'Wrong return value: ' + str(id_new) + ' ' + str( type(id_new)) cr.execute( 'select id from wkf_instance where res_id=%s and wkf_id=%s', (id_new, activity['subflow_id'])) id_new = cr.fetchone()[0] # If there is no function, we just put the current object on the subflow. # TODO: this seems a little perilous if the workflow references some other model else: id_new = instance.create(cr, ident, activity['subflow_id']) cr.execute('update wkf_workitem set subflow_id=%s where id=%s', (id_new, workitem['id'])) workitem['subflow_id'] = id_new # If the state is running, we're waiting for the subflow to complete. Check the subflow # to see what the status it happens to be and if the subflow is marked 'complete', we can # finally mark this activity as complete as well if workitem['state'] == 'running': cr.execute("select state from wkf_instance where id=%s", (workitem['subflow_id'], )) state = cr.fetchone()[0] if state == 'complete': _state_set(cr, workitem, activity, 'complete', ident) for t in signal_todo: instance.validate(cr, t[0], t[1], t[2], force_running=True) if config['debug_workflow']: _logger.debug(" /execute {a[kind]} {i[1]},{i[2]} started {d}".format( i=ident, w=workitem, a=activity, d=exec_started)) return result
def _execute(cr, workitem, activity, ident, stack): result = True # # send a signal to parent workflow (signal: subflow.signal_name) # signal_todo = [] if (workitem["state"] == "active") and activity["signal_send"]: cr.execute( "select i.id,w.osv,i.res_id from wkf_instance i left join wkf w on (i.wkf_id=w.id) where i.id IN (select inst_id from wkf_workitem where subflow_id=%s)", (workitem["inst_id"],), ) for i in cr.fetchall(): signal_todo.append((i[0], (ident[0], i[1], i[2]), activity["signal_send"])) if activity["kind"] == "dummy": if workitem["state"] == "active": _state_set(cr, workitem, activity, "complete", ident) if activity["action_id"]: res2 = wkf_expr.execute_action(cr, ident, workitem, activity) if res2: stack.append(res2) result = res2 elif activity["kind"] == "function": if workitem["state"] == "active": _state_set(cr, workitem, activity, "running", ident) returned_action = wkf_expr.execute(cr, ident, workitem, activity) if type(returned_action) in (dict,): stack.append(returned_action) if activity["action_id"]: res2 = wkf_expr.execute_action(cr, ident, workitem, activity) # A client action has been returned if res2: stack.append(res2) result = res2 _state_set(cr, workitem, activity, "complete", ident) elif activity["kind"] == "stopall": if workitem["state"] == "active": _state_set(cr, workitem, activity, "running", ident) cr.execute("delete from wkf_workitem where inst_id=%s and id<>%s", (workitem["inst_id"], workitem["id"])) if activity["action"]: wkf_expr.execute(cr, ident, workitem, activity) _state_set(cr, workitem, activity, "complete", ident) elif activity["kind"] == "subflow": if workitem["state"] == "active": _state_set(cr, workitem, activity, "running", ident) if activity.get("action", False): id_new = wkf_expr.execute(cr, ident, workitem, activity) if not (id_new): cr.execute("delete from wkf_workitem where id=%s", (workitem["id"],)) return False assert type(id_new) == type(1) or type(id_new) == type(1L), ( "Wrong return value: " + str(id_new) + " " + str(type(id_new)) ) cr.execute( "select id from wkf_instance where res_id=%s and wkf_id=%s", (id_new, activity["subflow_id"]) ) id_new = cr.fetchone()[0] else: id_new = instance.create(cr, ident, activity["subflow_id"]) cr.execute("update wkf_workitem set subflow_id=%s where id=%s", (id_new, workitem["id"])) workitem["subflow_id"] = id_new if workitem["state"] == "running": cr.execute("select state from wkf_instance where id=%s", (workitem["subflow_id"],)) state = cr.fetchone()[0] if state == "complete": _state_set(cr, workitem, activity, "complete", ident) for t in signal_todo: instance.validate(cr, t[0], t[1], t[2], force_running=True) return result