def expand_macro(self, formatter, name, txt): r1 = re.compile(r'^\s*\"(.+)\"\s*,\s*\"(.+)\"\s*$') if r1.search(txt): (address,location) = r1.search(txt).groups() else: address = txt.strip('"') location = None req = formatter.req author = req.authname ipnr = req.remote_addr resource = formatter.resource page = WikiPage(self.env,resource) name = page.name db = self.env.get_db_cnx() place = wikiaddress.wikiaddress(db,name,_API_KEY,author, ipnr,address,location) if place.lat is None: return address if location is None: loctag = 'l' else: loctag = 'l_'+location.replace(' ','') nearby = place.getNearby() # use the req object to store whether the base javascript has # been rendered. don't do it twice out = '' if not hasattr(req,'addressmacro'): req.addressmacro = True out += self.apiURL(_API_KEY) out += self.basemap() out += self.singlemap(name,place,loctag,location,nearby) out += address+" <a onclick=\"javascript:toggle('"+loctag+"div');"+loctag+"_load();return false;\" href=\"\">"+" [View Map]"+"</a>" out += "<div id=\""+loctag+"div\" style=\"width: 450px; height: 300px;display: none;\"></div>" return out
import sys sys.path.append('../') import wikiaddress _API_KEY = 'PUT YOUR KEY HERE' my_dbapi = __import__("MySQLdb") mydb = my_dbapi.connect(host='localhost', user='******', passwd='password', db='password') w = wikiaddress.wikiaddress(mydb,'mundo grill',_API_KEY,'somebody','1.2.3.4','2833 Monroe Ave, Rochester NY 14618',None) nb = w.getNearby() print "Lat=%s,Long=%s"%(w.lat,w.long) if nb is None: print "NB is empty" else: for x in nb: print "name = %s, address=%s, lat=%s, long=%s"%(x['name'],x['address'],x['lat'],x['long'])