示例#1
0
    def executePost(self):
        """ POST notification

            post notifation request handler
            create new notifcation, simple or complex
        """
        servicedb = databaseManager.PgDB(
            self.serviceconf.connectionWns['user'],
            self.serviceconf.connectionWns['password'],
            self.serviceconf.connectionWns['dbname'],
            self.serviceconf.connectionWns['host'],
            self.serviceconf.connectionWns['port'])

        name = self.json["name"]
        description = self.json["description"]
        interval = self.json["interval"]
        not_id = None
        store = self.json.get("store", False)

        sql = """INSERT INTO wns.notification (name, description,
                        interval, store) VALUES (%s,%s, %s, %s) RETURNING id;"""
        par = [name, description, interval, store]
        try:
            not_id = servicedb.executeInTransaction(sql, par)[0][0]
        except psycopg2.Error as e:
            self.setException(e.pgerror)
            servicedb.rollbackTransaction()
            return

        if not not_id:
            self.setException('Exception while creating a new notification')
            return
        try:
            from wnslib import notificationManager as notManager
            if "params" in self.json.keys():
                params = self.json["params"]
                condition = self.json["condition"]
                service = self.json["service"]
                period = self.json.get("period", None)

                notManager.createSimpleNotification(name, service, params,
                                                    condition, interval,
                                                    period, store)
            else:
                print "Notification"
                funcFile = self.json["function"]
                msg = notManager.addNotification(name, funcFile, interval,
                                                 store)
                if msg:
                    self.setException(msg)
                    servicedb.rollbackTransaction()
                    return

        except Exception, e:
            msg = "The following error occoured: " + str(e)
            msg += "\n\nPlease try again"
            self.setException(msg)
            servicedb.rollbackTransaction()
            return
示例#2
0
    def executePut(self):
        #self.json = self.json['data']
        description = self.json.get("description", None)

        from wnslib import notificationManager as notManager

        if description:
            servicedb = databaseManager.PgDB(
                self.serviceconf.connectionWns['user'],
                self.serviceconf.connectionWns['password'],
                self.serviceconf.connectionWns['dbname'],
                self.serviceconf.connectionWns['host'],
                self.serviceconf.connectionWns['port'])

            sql = "UPDATE wns.notification SET description = %s WHERE id=%s;"
            params = (description, self.not_id,)
            servicedb.executeInTransaction(sql, params)

        if not self.json.get("params") or not self.json.get("function"):
            self.setMessage("Updated notifcation description")
            servicedb.commitTransaction()
            return

        try:
            name = self.json["name"]
            interval = self.json["interval"]

            if "params" in self.json.keys():
                print >> sys.stderr, "simpleNot"
                params = self.json["params"]
                condition = self.json["condition"]
                service = self.json["service"]
                period = self.json.get("period", None)

                notManager.createSimpleNotification(name, service, params,
                                            condition, interval, period)
            else:
                print >> sys.stderr, "Notification"
                funcFile = self.json["function"]
                msg = notManager.addNotification(name, funcFile, interval)
                if msg:
                    self.setException(msg)
                    if description:
                        servicedb.rollbackTransaction()
                    return
            if description:
                servicedb.commitTransaction()
            # Delete old notification function
            notManager.delNotification(name)

        except Exception, e:
            msg = "The following error occoured: " + str(e)
            msg += "\n\nPlease try again"
            if description:
                servicedb.rollbackTransaction()
            self.setException(msg)
            return
示例#3
0
    def executePost(self):
        servicedb = databaseManager.PgDB(
            self.serviceconf.connectionWns['user'],
            self.serviceconf.connectionWns['password'],
            self.serviceconf.connectionWns['dbname'],
            self.serviceconf.connectionWns['host'],
            self.serviceconf.connectionWns['port'])

        #self.json = self.json['data']

        name = self.json["name"]
        description = self.json["description"]
        interval = self.json["interval"]
        not_id = None

        sql = """INSERT INTO wns.notification (name, description)
                        VALUES (%s,%s) RETURNING id;"""
        par = [name, description]
        not_id = servicedb.executeInTransaction(sql, par)[0][0]

        if not not_id:
            self.setException('Exception while creating a new notification')
            return
        try:
            from wnslib import notificationManager as notManager
            if "params" in self.json.keys():
                print "simpleNot"
                params = self.json["params"]
                condition = self.json["condition"]
                service = self.json["service"]
                period = self.json.get("period", None)

                notManager.createSimpleNotification(name, service, params,
                                            condition, interval, period)
            else:
                print  "Notification"
                funcFile = self.json["function"]
                msg = notManager.addNotification(name, funcFile, interval)
                if msg:
                    self.setException(msg)
                    servicedb.rollbackTransaction()
                    return

        except Exception, e:
            msg = "The following error occoured: " + str(e)
            msg += "\n\nPlease try again"
            self.setException(msg)
            servicedb.rollbackTransaction()
            return
示例#4
0
    def executePut(self):
        """ PUT notification

            Put notification request handler

            Update a existing notification
        """
        description = self.json.get("description", None)
        interval = self.json.get("interval", None)

        from wnslib import notificationManager as notManager
        servicedb = databaseManager.PgDB(
            self.serviceconf.connectionWns['user'],
            self.serviceconf.connectionWns['password'],
            self.serviceconf.connectionWns['dbname'],
            self.serviceconf.connectionWns['host'],
            self.serviceconf.connectionWns['port'])

        if description:

            sql = "UPDATE wns.notification SET description = %s "
            params = (description, )

            sql += " WHERE id=%s RETURNING *"
            params += (self.not_id, )

            try:
                row = servicedb.executeInTransaction(sql, params)
            except psycopg2.Error as e:
                self.setException(e.pgerror)
                servicedb.rollbackTransaction()
                return
        else:
            sql = "SELECT * FROM wns.notification WHERE id=%s"
            params = (self.not_id, )

            try:
                row = servicedb.executeInTransaction(sql, params)
            except psycopg2.Error as e:
                self.setException(e.pgerror)
                servicedb.rollbackTransaction()
                return

        if not self.json.get("params") and not self.json.get("function"):
            self.setMessage("Updated notifcation description")
            servicedb.commitTransaction()
            return

        if self.json.get('params') and self.json.get('function'):
            self.setException("What?!?!")
            servicedb.rollbackTransaction()
            return

        try:
            interval = self.json.get("interval", row[0][3])
            name = row[0][1]
            store = self.json.get("store", row[0][4])

            # Delete old notification function
            notManager.delNotification(name)

            if "params" in list(self.json.keys()):
                print("simpleNot", file=sys.stderr)
                params = self.json["params"]
                condition = self.json["condition"]
                service = self.json["service"]
                period = self.json.get("period", None)

                notManager.createSimpleNotification(name, service, params,
                                                    condition, interval,
                                                    period, store)
            else:
                print("Notification", file=sys.stderr)
                function_path = self.json["function"]
                msg = notManager.addNotification(name, function_path, interval,
                                                 store)

                if msg:
                    self.setException(msg)
                    if description:
                        servicedb.rollbackTransaction()
                    return

            if description:
                servicedb.commitTransaction()
            else:
                sql = "UPDATE wns.notification SET interval = %s, store = %s"
                sql += " WHERE id=%s"

                params = (interval, store, self.not_id)

                try:
                    servicedb.executeInTransaction(sql, params)
                except psycopg2.Error as e:
                    self.setException(e.pgerror)
                    servicedb.rollbackTransaction()

                servicedb.commitTransaction()

        except Exception as e:
            msg = "The following error occoured: " + str(e)
            msg += "\n\nPlease try again"
            if description:
                servicedb.rollbackTransaction()
            self.setException(msg)
            return

        self.setMessage("Notification " + name + " updated")