Python manage_users Examples

Example #1

def getCon(conf):
	if conf["main"].has_key(conf["main"]["dbuser"]) and conf["main"]["dbuser"]=="dblink":
		con=manage_users(conf["main"][conf["main"]["dbuser"]])
	else:
		if conf.has_key(conf["main"]["dbuser"]):
			con=manage_users(parseDb(conf[conf["main"]["dbuser"]]))
	con.connect(conf)
	return con

Example #2

File: service.py Project: mapmint/mapmint

def getCon(conf):
	if conf["main"].has_key(conf["main"]["dbuser"]) and conf["main"]["dbuser"]=="dblink":
		con=manage_users(conf["main"][conf["main"]["dbuser"]])
	else:
		if conf.has_key(conf["main"]["dbuser"]):
			con=manage_users(parseDb(conf[conf["main"]["dbuser"]]))
	con.connect(conf)
	return con

Example #3

File: service.py Project: ThomasG77/mapmint

def getCon(conf):
	if conf["main"].has_key(conf["main"]["dbuser"]) and conf["main"]["dbuser"]=="dblink":
		print >> sys.stderr,"DB IS SQLITE"
		con=manage_users(conf["main"][conf["main"]["dbuser"]])
	else:
		if conf.has_key(conf["main"]["dbuser"]):
			print >> sys.stderr,"DB IS POSTGRESQL"
			con=manage_users(parseDb(conf[conf["main"]["dbuser"]]))
	con.connect(conf)
	return con

Example #4

File: service.py Project: wslerry/mapmint

def saveFavSrs(conf, inputs, outputs):
    con = manage_users(conf["main"]["dblink"])
    con.connect(conf)
    var = 0
    if inputs["fav"]["value"] == "true":
        var = 1
    clause = ""
    if inputs["srs_field"]["value"] == "id":
        clause += "code="
    else:
        clause += "name="
    clause += "[_val_]"
    v = "UPDATE spatial_ref_sys set fav=[_fav_] WHERE " + clause
    try:
        con.pexecute_req([
            v, {
                "fav": {
                    "value": str(var),
                    "format": "s"
                },
                "val": {
                    "value": inputs["srs_id"]["value"],
                    "format": "s"
                }
            }
        ])
        con.conn.commit()
        outputs["Result"]["value"] = "SRS successfully updated"
    except Exception, e:
        outputs["Result"]["value"] = "SRS update failed: " + str(e)

Example #5

File: service.py Project: wslerry/mapmint

def isFavSrs(conf, inputs, outputs):
    con = manage_users(conf["main"]["dblink"])
    con.connect(conf)
    clause = "fav and "
    if inputs["srs_field"]["value"] == "id":
        clause += "code="
    else:
        clause += "name="
    clause += "[_val_]"
    v = "SELECT count(*) from spatial_ref_sys WHERE " + clause
    try:
        con.pexecute_req(
            [v, {
                "val": {
                    "value": inputs["srs_id"]["value"],
                    "format": "s"
                }
            }])
        val = con.cur.fetchone()
        print >> sys.stderr, val
        if val[0] > 0:
            outputs["Result"]["value"] = "true"
        else:
            outputs["Result"]["value"] = "false"
    except Exception, e:
        conf["lenv"]["message"] = zoo._("Error occured: ") + str(e)
        return zoo.SERVICE_FAILED

Example #6

File: service.py Project: mapmint/mapmint

def saveFavSrs(conf,inputs,outputs):
    con=manage_users(conf["main"]["dblink"])
    con.connect(conf)
    var=0
    if inputs["fav"]["value"]=="true":
        var=1
    clause=""
    if inputs["srs_field"]["value"]=="id":
        clause+="code="
    else:
        clause+="name="
    clause+="[_val_]"
    v="UPDATE spatial_ref_sys set fav=[_fav_] WHERE "+clause
    try:
        con.pexecute_req([v,{"fav":{"value":str(var),"format":"s"},"val":{"value":inputs["srs_id"]["value"],"format":"s"}}])
        con.conn.commit()
        outputs["Result"]["value"]="SRS successfully updated"
    except Exception,e:
        outputs["Result"]["value"]="SRS update failed: "+str(e)

Example #7

File: service.py Project: mapmint/mapmint

def isFavSrs(conf,inputs,outputs):
    con=manage_users(conf["main"]["dblink"])
    con.connect(conf)
    clause="fav and "
    if inputs["srs_field"]["value"]=="id":
        clause+="code="
    else:
        clause+="name="
    clause+="[_val_]"
    v="SELECT count(*) from spatial_ref_sys WHERE "+clause
    try:
        con.pexecute_req([v,{"val":{"value":inputs["srs_id"]["value"],"format":"s"}}])
	val=con.cur.fetchone()
	print >> sys.stderr,val
	if val[0]>0:
        	outputs["Result"]["value"]="true"
	else:
		outputs["Result"]["value"]="false"
    except Exception,e:
	conf["lenv"]["message"]=zoo._("Error occured: ")+str(e)
	return zoo.SERVICE_FAILED