New trunk

bzr revid: pinky-3f10ee12cea3c4c75cef44ab04ad33ef47432907

1 files changed, 98 insertions, 0 deletions

diff --git a/bin/workflow/wkf_service.py b/bin/workflow/wkf_service.py
new file mode 100644
index 00000000000..707ce97eb9c
--- /dev/null
+++ b/bin/workflow/wkf_service.py
@@ -0,0 +1,98 @@
+##############################################################################
+#
+# Copyright (c) 2004 TINY SPRL. (http://tiny.be) All Rights Reserved.
+#                    Fabien Pinckaers <fp@tiny.Be>
+#
+# WARNING: This program as such is intended to be used by professional
+# programmers who take the whole responsability of assessing all potential
+# consequences resulting from its eventual inadequacies and bugs
+# End users who are looking for a ready-to-use solution with commercial
+# garantees and support are strongly adviced to contract a Free Software
+# Service Company
+#
+# This program is Free Software; you can redistribute it and/or
+# modify it under the terms of the GNU General Public License
+# as published by the Free Software Foundation; either version 2
+# 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 General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with this program; if not, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+#
+##############################################################################
+
+import wkf_logs
+import workitem
+import instance
+
+import netsvc
+import pooler
+
+class workflow_service(netsvc.Service):
+	def __init__(self, name='workflow', audience='*'):
+		netsvc.Service.__init__(self, name, audience)
+		self.exportMethod(self.trg_write)
+		self.exportMethod(self.trg_delete)
+		self.exportMethod(self.trg_create)
+		self.exportMethod(self.trg_validate)
+		self.exportMethod(self.trg_redirect)
+		self.exportMethod(self.trg_trigger)
+
+	def trg_write(self, uid, res_type, res_id, cr):
+		ident = (uid,res_type,res_id)
+		cr.execute('select id from wkf_instance where res_id=%d and res_type=%s and state=%s', (res_id,res_type, 'active'))
+		for (id,) in cr.fetchall():
+			instance.update(cr, id, ident)
+
+	def trg_trigger(self, uid, res_type, res_id, cr):
+		cr.execute('select instance_id from wkf_triggers where res_id=%d and model=%s', (res_id,res_type))
+		res = cr.fetchall()
+		for (instance_id,) in res:
+			cr.execute('select uid,res_type,res_id from wkf_instance where id=%d', (instance_id,))
+			ident = cr.fetchone()
+			instance.update(cr, instance_id, ident)
+
+	def trg_delete(self, uid, res_type, res_id, cr):
+		ident = (uid,res_type,res_id)
+		instance.delete(cr, ident)
+
+	def trg_create(self, uid, res_type, res_id, cr):
+		ident = (uid,res_type,res_id)
+		cr.execute('select id from wkf where osv=%s and on_create=True', (res_type,))
+		for (wkf_id,) in cr.fetchall():
+			instance.create(cr, ident, wkf_id)
+
+	def trg_validate(self, uid, res_type, res_id, signal, cr):
+		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=%d and res_type=%s and state=%s', (res_id, res_type, 'active'))
+		for (id,) in cr.fetchall():
+			instance.validate(cr, id, ident, signal)
+
+	# make all workitems which are waiting for a (subflow) workflow instance
+	# for the old resource point to the (first active) workflow instance for
+	# the new resource
+	def trg_redirect(self, uid, res_type, res_id, new_rid, cr):
+		# get ids of wkf instances for the old resource (res_id)
+#CHECKME: shouldn't we get only active instances?
+		cr.execute('select id, wkf_id from wkf_instance where res_id=%d and res_type=%s', (res_id, res_type))
+		for old_inst_id, wkf_id in cr.fetchall():
+			# first active instance for new resource (new_rid), using same wkf
+			cr.execute(
+				'SELECT id '\
+				'FROM wkf_instance '\
+				'WHERE res_id=%d AND res_type=%s AND wkf_id=%d AND state=%s', 
+				(new_rid, res_type, wkf_id, 'active'))
+			new_id = cr.fetchone()
+			if new_id:
+				# select all workitems which "wait" for the old instance
+				cr.execute('select id from wkf_workitem where subflow_id=%d', (old_inst_id,))
+				for (item_id,) in cr.fetchall():
+					# redirect all those workitems to the wkf instance of the new resource
+					cr.execute('update wkf_workitem set subflow_id=%d where id=%d', (new_id[0], item_id))
+workflow_service()