1 # -*- coding: utf-8 -*-
2 ##############################################################################
4 # OpenERP, Open Source Management Solution
5 # Copyright (C) 2004-2010 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 ##############################################################################
23 import openerp.tools.config
24 import openerp.modules.registry
25 import openerp.addons.web.http as http
26 from openerp.addons.web.http import request
27 from openerp.tools.misc import DEFAULT_SERVER_DATETIME_FORMAT
29 from openerp.osv import osv, fields
35 _logger = logging.getLogger(__name__)
37 def listen_channel(cr, channel_name, handle_message, check_stop=(lambda: False), check_stop_timer=60.):
39 Begin a loop, listening on a PostgreSQL channel. This method does never terminate by default, you need to provide a check_stop
40 callback to do so. This method also assume that all notifications will include a message formated using JSON (see the
41 corresponding notify_channel() method).
43 :param db_name: database name
44 :param channel_name: the name of the PostgreSQL channel to listen
45 :param handle_message: function that will be called when a message is received. It takes one argument, the message
46 attached to the notification.
47 :type handle_message: function (one argument)
48 :param check_stop: function that will be called periodically (see the check_stop_timer argument). If it returns True
49 this function will stop to watch the channel.
50 :type check_stop: function (no arguments)
51 :param check_stop_timer: The maximum amount of time between calls to check_stop_timer (can be shorter if messages
56 cr.execute("listen " + channel_name + ";")
63 if select.select([conn], [], [], check_stop_timer) == ([],[],[]):
68 message = json.loads(conn.notifies.pop().payload)
69 handle_message(message)
72 cr.execute("unlisten " + channel_name + ";")
75 pass # can't do anything if that fails
77 def notify_channel(cr, channel_name, message):
79 Send a message through a PostgreSQL channel. The message will be formatted using JSON. This method will
80 commit the given transaction because the notify command in Postgresql seems to work correctly when executed in
81 a separate transaction (despite what is written in the documentation).
83 :param cr: The cursor.
84 :param channel_name: The name of the PostgreSQL channel.
85 :param message: The message, must be JSON-compatible data.
88 cr.execute("notify " + channel_name + ", %s", [json.dumps(message)])
92 DISCONNECTION_TIMER = POLL_TIMER + 5
93 WATCHER_ERROR_DELAY = 10
95 class LongPollingController(http.Controller):
97 @http.route('/longpolling/im/poll', type="json", auth="none")
98 def poll(self, last=None, users_watch=None, db=None, uid=None, password=None, uuid=None):
100 if not openerp.evented:
101 raise Exception("Not usable in a server not running gevent")
102 from openerp.addons.im.watcher import ImWatcher
104 openerp.service.security.check(db, uid, password)
106 uid = request.session.uid
107 db = request.session.db
109 registry = openerp.modules.registry.RegistryManager.get(db)
110 with registry.cursor() as cr:
111 registry.get('im.user').im_connect(cr, uid, uuid=uuid, context=request.context)
112 my_id = registry.get('im.user').get_my_id(cr, uid, uuid, request.context)
115 with registry.cursor() as cr:
116 res = registry.get('im.message').get_messages(cr, uid, last, users_watch, uuid=uuid, context=request.context)
117 if num >= 1 or len(res["res"]) > 0:
121 ImWatcher.get_watcher(res["dbname"]).stop(my_id, users_watch or [], POLL_TIMER)
123 @http.route('/longpolling/im/activated', type="json", auth="none")
125 return not not openerp.evented
127 @http.route('/longpolling/im/gen_uuid', type="json", auth="none")
130 return "%s" % uuid.uuid1()
132 def assert_uuid(uuid):
133 if not isinstance(uuid, (str, unicode, type(None))) and uuid != False:
134 raise Exception("%s is not a uuid" % uuid)
137 class im_message(osv.osv):
143 'message': fields.text(string="Message", required=True),
144 'from_id': fields.many2one("im.user", "From", required= True, ondelete='cascade'),
145 'session_id': fields.many2one("im.session", "Session", required=True, select=True, ondelete='cascade'),
146 'to_id': fields.many2many("im.user", "im_message_users", 'message_id', 'user_id', 'To'),
147 'date': fields.datetime("Date", required=True, select=True),
148 'technical': fields.boolean("Technical Message"),
152 'date': lambda *args: datetime.datetime.now().strftime(DEFAULT_SERVER_DATETIME_FORMAT),
156 def get_messages(self, cr, uid, last=None, users_watch=None, uuid=None, context=None):
158 users_watch = users_watch or []
160 # complex stuff to determine the last message to show
161 users = self.pool.get("im.user")
162 my_id = users.get_my_id(cr, uid, uuid, context=context)
163 c_user = users.browse(cr, openerp.SUPERUSER_ID, my_id, context=context)
165 if c_user.im_last_received < last:
166 users.write(cr, openerp.SUPERUSER_ID, my_id, {'im_last_received': last}, context=context)
168 last = c_user.im_last_received or -1
170 # how fun it is to always need to reorder results from read
171 mess_ids = self.search(cr, openerp.SUPERUSER_ID, ["&", ['id', '>', last], "|", ['from_id', '=', my_id], ['to_id', 'in', [my_id]]], order="id", context=context)
172 mess = self.read(cr, openerp.SUPERUSER_ID, mess_ids, ["id", "message", "from_id", "session_id", "date"], context=context)
174 for i in xrange(len(mess)):
175 index[mess[i]["id"]] = mess[i]
178 mess.append(index[i])
181 last = mess[-1]["id"]
182 users_status = users.read(cr, openerp.SUPERUSER_ID, users_watch, ["im_status"], context=context)
183 return {"res": mess, "last": last, "dbname": cr.dbname, "users_status": users_status}
185 def post(self, cr, uid, message, to_session_id, uuid=None, technical=False, context=None):
187 my_id = self.pool.get('im.user').get_my_id(cr, uid, uuid)
188 session = self.pool.get('im.session').browse(cr, uid, to_session_id, context)
189 to_ids = [x.id for x in session.user_ids if x.id != my_id]
190 self.create(cr, openerp.SUPERUSER_ID, {"message": message, 'from_id': my_id,
191 'to_id': [(6, 0, to_ids)], 'session_id': to_session_id, technical=technical}, context=context)
192 notify_channel(cr, "im_channel", {'type': 'message', 'receivers': [my_id] + to_ids})
195 class im_session(osv.osv):
198 def _calc_name(self, cr, uid, ids, something, something_else, context=None):
200 for obj in self.browse(cr, uid, ids, context=context):
201 res[obj.id] = ", ".join([x.name for x in obj.user_ids])
205 'user_ids': fields.many2many('im.user'),
206 "name": fields.function(_calc_name, string="Name", type='char'),
209 # Todo: reuse existing sessions if possible
210 def session_get(self, cr, uid, user_to, uuid=None, context=None):
211 my_id = self.pool.get("im.user").get_my_id(cr, uid, uuid, context=context)
214 # FP Note: does the ORM allows something better than this? == on many2many
215 sids = self.search(cr, openerp.SUPERUSER_ID, [('user_ids', 'in', [user_to]), ('user_ids', 'in', [my_id])], context=context, limit=1)
216 for session in self.browse(cr, uid, sids, context=context):
217 if len(session.user_ids) == 2:
218 session_id = session.id
221 session_id = self.create(cr, openerp.SUPERUSER_ID, {
222 'user_ids': [(6, 0, [user_to, my_id])]
224 return self.read(cr, uid, session_id, context=context)
226 def add_to_session(self, cr, uid, session_id, user_id, uuid=None, context=None):
227 my_id = self.pool.get("im.user").get_my_id(cr, uid, uuid, context=context)
228 session = self.read(cr, uid, session_id, context=context)
229 if my_id not in session.get("user_ids"):
230 raise Exception("Not allowed to modify a session when you are not in it.")
231 self.write(cr, uid, session_id, {"user_ids": [(4, user_id)]}, context=context)
233 class im_user(osv.osv):
236 def _im_status(self, cr, uid, ids, something, something_else, context=None):
238 current = datetime.datetime.now()
239 delta = datetime.timedelta(0, DISCONNECTION_TIMER)
240 data = self.read(cr, openerp.SUPERUSER_ID, ids, ["im_last_status_update", "im_last_status"], context=context)
242 last_update = datetime.datetime.strptime(obj["im_last_status_update"], DEFAULT_SERVER_DATETIME_FORMAT)
243 res[obj["id"]] = obj["im_last_status"] and (last_update + delta) > current
246 def search_users(self, cr, uid, text_search, fields, limit, context=None):
247 my_id = self.get_my_id(cr, uid, None, context)
248 found = self.search(cr, uid, [["name", "ilike", text_search], ["id", "<>", my_id], ["uuid", "=", False]],
249 order="name asc", limit=limit, context=context)
250 return self.read(cr, uid, found, fields, context=context)
252 def im_connect(self, cr, uid, uuid=None, context=None):
254 return self._im_change_status(cr, uid, True, uuid, context)
256 def im_disconnect(self, cr, uid, uuid=None, context=None):
258 return self._im_change_status(cr, uid, False, uuid, context)
260 def _im_change_status(self, cr, uid, new_one, uuid=None, context=None):
262 id = self.get_my_id(cr, uid, uuid, context=context)
263 current_status = self.read(cr, openerp.SUPERUSER_ID, id, ["im_status"], context=None)["im_status"]
264 self.write(cr, openerp.SUPERUSER_ID, id, {"im_last_status": new_one,
265 "im_last_status_update": datetime.datetime.now().strftime(DEFAULT_SERVER_DATETIME_FORMAT)}, context=context)
266 if current_status != new_one:
267 notify_channel(cr, "im_channel", {'type': 'status', 'user': id})
270 def get_my_id(self, cr, uid, uuid=None, context=None):
273 users = self.search(cr, openerp.SUPERUSER_ID, [["uuid", "=", uuid]], context=None)
275 users = self.search(cr, openerp.SUPERUSER_ID, [["user_id", "=", uid]], context=None)
276 my_id = users[0] if len(users) >= 1 else False
278 my_id = self.create(cr, openerp.SUPERUSER_ID, {"user_id": uid if not uuid else False, "uuid": uuid if uuid else False}, context=context)
281 def assign_name(self, cr, uid, uuid, name, context=None):
283 id = self.get_my_id(cr, uid, uuid, context=context)
284 self.write(cr, openerp.SUPERUSER_ID, id, {"assigned_name": name}, context=context)
287 def _get_name(self, cr, uid, ids, name, arg, context=None):
289 for record in self.browse(cr, uid, ids, context=context):
290 res[record.id] = record.assigned_name
292 res[record.id] = record.user_id.name
297 'name': fields.function(_get_name, type='char', size=200, string="Name", store=True, readonly=True),
298 'assigned_name': fields.char(string="Assigned Name", size=200, required=False),
299 'image': fields.related('user_id', 'image_small', type='binary', string="Image", readonly=True),
300 'user_id': fields.many2one("res.users", string="User", select=True, ondelete='cascade'),
301 'uuid': fields.char(string="UUID", size=50, select=True),
302 'im_last_received': fields.integer(string="Instant Messaging Last Received Message"),
303 'im_last_status': fields.boolean(strint="Instant Messaging Last Status"),
304 'im_last_status_update': fields.datetime(string="Instant Messaging Last Status Update"),
305 'im_status': fields.function(_im_status, string="Instant Messaging Status", type='boolean'),
309 'im_last_received': -1,
310 'im_last_status': False,
311 'im_last_status_update': lambda *args: datetime.datetime.now().strftime(DEFAULT_SERVER_DATETIME_FORMAT),
315 ('user_uniq', 'unique (user_id)', 'Only one chat user per OpenERP user.'),
316 ('uuid_uniq', 'unique (uuid)', 'Chat identifier already used.'),