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
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
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)
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
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)
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