示例#1
0
def AddUser(conf,inputs,outputs):
	if is_connected(conf):
		c = auth.getCon(conf)
		prefix=auth.getPrefix(conf)
		if c.is_admin(conf["senv"]["login"]):
			try:
				user = json.loads(inputs["user"]["value"])
                	except Exception,e:
				print >> sys.stderr,inputs["user"]["value"]
                        	print >> sys.stderr,e
                        	conf["lenv"]["message"] = zoo._("invalid user parameter: ")+inputs["user"]["value"]
                        	return 4
			for (i,j) in user.items():
				if not manage_users.check_user_params(i,j):
					conf["lenv"]["message"] = 'Parametre %s incorrect'%(i)
					return 4
			if c.add_user(user):
				outputs["Result"]["value"] = inputs["user"]["value"]
				if inputs.has_key("group"):
					if inputs["group"].has_key("length"):
						for i in range(0,len(inputs["group"]["value"])):
							linkGroupToUser(c,prefix,inputs["group"]["value"],inputs["login"]["value"])
					else:
						linkGroupToUser(c,prefix,inputs["group"]["value"],user["login"])
				return 3
			else:
				conf["lenv"]["message"] = zoo._("SQL Error")
				return 4
		else:
			conf["lenv"]["message"]= zoo._("Action not permited")
			return 4
示例#2
0
def AddUser(conf,inputs,outputs):
    if is_connected(conf):
        c = auth.getCon(conf)
        prefix=auth.getPrefix(conf)
        if c.is_admin(conf["senv"]["login"]):
            try:
                user = json.loads(inputs["user"]["value"])
            except Exception,e:
                print >> sys.stderr,inputs["user"]["value"]
                print >> sys.stderr,e
                conf["lenv"]["message"] = zoo._("invalid user parameter: ")+inputs["user"]["value"]
                return 4
            for (i,j) in user.items():
                if i!="phone" and not manage_users.check_user_params(i,j):
                    conf["lenv"]["message"] = 'Parametre %s incorrect'%(i)
                    return 4
            if c.add_user(user):
                outputs["Result"]["value"] = zoo._("User successfully inserted")
                #outputs["Result"]["value"] = inputs["user"]["value"]
                if inputs.has_key("group"):
                    if inputs["group"].has_key("length"):
                        for i in range(0,len(inputs["group"]["value"])):
                            linkGroupToUser(conf,c,prefix,inputs["group"]["value"][i],user["login"])
                    else:
                        linkGroupToUser(conf,c,prefix,inputs["group"]["value"],user["login"])
                return 3
            else:
                conf["lenv"]["message"] = zoo._("SQL Error")
                return 4
        else:
            conf["lenv"]["message"]= zoo._("Action not permited")
            return 4
示例#3
0
def UpdateUser(conf,inputs,outputs):
	if is_connected(conf):
		prefix=auth.getPrefix(conf)
		c = auth.getCon(conf)
		
		try:
			user = json.loads(inputs["set"]["value"])
               	except Exception,e:
			user={}
			print >> sys.stderr,inputs["set"]["value"]
                       	print >> sys.stderr,e
                       	conf["lenv"]["message"] = zoo._("invalid set parameter :")+inputs["set"]["value"]
                       	#return 4

		if inputs['id']["value"] == "NULL":
			userl=conf["senv"]["login"]
			if not(inputs.has_key("type")) or inputs["type"]["value"]!="delete":
				for (i,j) in user.items():
					if not manage_users.check_user_params(i,j):
						conf["lenv"]["message"] = 'Parametre %s incorrect'%(i)
						return 4
					if i=="login":
						userl=j
			if inputs.has_key("login"):
				userl=inputs["login"]["value"]
			if inputs.has_key("type") and inputs["type"]["value"]=="delete":
				try:
					c.cur.execute("DELETE FROM "+prefix+"user_group WHERE id_user=(select id from "+prefix+"users where login='******')")
				except Exception,e:
					print >> sys.stderr,e
					pass
				try:
					c.cur.execute("DELETE FROM indicateurs_favoris WHERE u_id=(select id from "+prefix+"users where login='******')")
				except Exception,e:
					print >> sys.stderr,e
					pass
				try:
					c.cur.execute("DELETE FROM "+prefix+"favoris WHERE u_id=(select id from "+prefix+"users where login='******')")
				except Exception,e:
					print >> sys.stderr,e
					pass
示例#4
0
def UpdateUser(conf, inputs, outputs):
    if is_connected(conf):
        prefix = auth.getPrefix(conf)
        c = auth.getCon(conf)

        try:
            user = json.loads(inputs["set"]["value"])
        except Exception, e:
            user = {}
            print >> sys.stderr, inputs["set"]["value"]
            print >> sys.stderr, e
            conf["lenv"]["message"] = zoo._(
                "invalid set parameter :") + inputs["set"]["value"]
            return 4

        if inputs['id']["value"] == "NULL":
            userl = conf["senv"]["login"]
            if not (inputs.has_key("type")
                    ) or inputs["type"]["value"] != "delete":
                for (i, j) in user.items():
                    if not manage_users.check_user_params(i, j):
                        conf["lenv"]["message"] = 'Parametre %s incorrect' % (
                            i)
                        return 4
                    if i == "login":
                        userl = j
            if inputs.has_key("login"):
                userl = inputs["login"]["value"].decode("utf-8")
            if inputs.has_key("type") and inputs["type"]["value"] == "delete":
                try:
                    c.cur.execute("DELETE FROM " + prefix +
                                  "users WHERE login='******'")
                except Exception, e:
                    print >> sys.stderr, e
                    pass
                c.conn.commit()
                tmpStr = zoo._('User succcessfully %s')
                tmpStr = tmpStr % (inputs["type"]["value"] + 'd')
                outputs["Result"]["value"] = tmpStr

                #outputs["Result"]["value"] = inputs["set"]["value"]
                return 3

            if c.update_user_by_login(user, userl):
                #outputs["Result"]["value"] = inputs["set"]["value"]
                tmpStr = zoo._('User succcessfully %s')
                tmpStr = tmpStr % (inputs["type"]["value"] + 'd')
                outputs["Result"]["value"] = tmpStr
                print >> sys.stderr, inputs["group"]["value"]
                if inputs.has_key(
                        "group") and inputs["group"]["value"] != "NULL":
                    print >> sys.stderr, inputs["group"]
                    try:
                        c.cur.execute(
                            "DELETE FROM " + prefix +
                            "user_group where id_user=(select id from " +
                            prefix + "users where login='******')")
                        c.con.commit()
                    except:
                        pass
                    if inputs["group"].has_key("length"):
                        for i in range(0, len(inputs["group"]["value"])):
                            linkGroupToUser(conf, c, prefix,
                                            inputs["group"]["value"][i],
                                            inputs["login"]["value"])
                    else:
                        linkGroupToUser(conf, c, prefix,
                                        inputs["group"]["value"],
                                        inputs["login"]["value"])
                return 3
            else:
                conf["lenv"]["message"] = zoo._("Update failed")
                return 4
示例#5
0
def UpdateUser(conf,inputs,outputs):
    if is_connected(conf):
        prefix=auth.getPrefix(conf)
        c = auth.getCon(conf)
		
        try:
            user = json.loads(inputs["set"]["value"])
        except Exception,e:
            user={}
            print >> sys.stderr,inputs["set"]["value"]
            print >> sys.stderr,e
            conf["lenv"]["message"] = zoo._("invalid set parameter :")+inputs["set"]["value"]
            return 4

        if inputs['id']["value"] == "NULL":
            userl=conf["senv"]["login"]
            if not(inputs.has_key("type")) or inputs["type"]["value"]!="delete":
                for (i,j) in user.items():
                    if not manage_users.check_user_params(i,j):
                        conf["lenv"]["message"] = 'Parametre %s incorrect'%(i)
                        return 4
                    if i=="login":
                        userl=j
            if inputs.has_key("login"):
                userl=inputs["login"]["value"].decode("utf-8")
            if inputs.has_key("type") and inputs["type"]["value"]=="delete":
                try:
                    c.cur.execute("DELETE FROM "+prefix+"users WHERE login='******'")
                except Exception,e:
                    print >> sys.stderr,e
                    pass
                c.conn.commit()
                tmpStr=zoo._('Group succcessfully %s')
                tmpStr=tmpStr % (inputs["type"]["value"]+'d')
                outputs["Result"]["value"]=tmpStr

                #outputs["Result"]["value"] = inputs["set"]["value"]
                return 3
				
            if c.update_user_by_login(user,userl):
                #outputs["Result"]["value"] = inputs["set"]["value"]
                tmpStr=zoo._('User succcessfully %s')
                tmpStr=tmpStr % (inputs["type"]["value"]+'d')
                outputs["Result"]["value"]=tmpStr
                print >> sys.stderr,inputs["group"]["value"]
                if inputs.has_key("group") and inputs["group"]["value"]!="NULL":
                    print >> sys.stderr,inputs["group"]
                    try:
                        c.cur.execute("DELETE FROM "+prefix+"user_group where id_user=(select id from "+prefix+"users where login='******')")
                        c.con.commit()
                    except:
                        pass
                    if inputs["group"].has_key("length"):
                        for i in range(0,len(inputs["group"]["value"])):
                            linkGroupToUser(conf,c,prefix,inputs["group"]["value"][i],inputs["login"]["value"])
                    else:
                        linkGroupToUser(conf,c,prefix,inputs["group"]["value"],inputs["login"]["value"])
                return 3
            else:
                conf["lenv"]["message"] = zoo._("Update failed")
                return 4