def match(q): q = unicode(q.decode("utf8")) q = q.upper() conn = db.opendbconnection("search") cur = conn.cursor() sql = "SELECT objektnamn FROM poi_skane_adressregister_apl WHERE objektnamn LIKE (%s);" safeParam = (q+"%", ) cur.execute(sql, safeParam) #cur.execute("SELECT objektnamn FROM poi_hbg_sok WHERE objektnamn like '" + q + "%';") out = "" for record in cur: out += record[0] #print conn.encoding cur.close() db.closedbconnection(conn) return out
def match(q): q = unicode(q.decode("utf8")) q = q.upper() conn = db.opendbconnection("search") cur = conn.cursor() sql = "SELECT objektnamn FROM poi_skane_adressregister_apl WHERE objektnamn LIKE (%s);" safeParam = (q + "%", ) cur.execute(sql, safeParam) #cur.execute("SELECT objektnamn FROM poi_hbg_sok WHERE objektnamn like '" + q + "%';") out = "" for record in cur: out += record[0] #print conn.encoding cur.close() db.closedbconnection(conn) return out
def locate(q): q = unicode(q.decode("utf8")) q = q.upper() conn = db.opendbconnection() cur = conn.cursor() sql = "SELECT easting, northing, objektnamn, objekttyp FROM poi_skane_adressregister_apl WHERE objektnamn = (%s);" safeParam = (q, ) cur.execute(sql, safeParam) #cur.execute("SELECT objektnamn FROM poi_hbg_sok WHERE objektnamn like '" + q + "%';") features = [] for record in cur: coordinates=[record[0],record[1]] geometry={} geometry['type'] = 'Point' geometry['coordinates'] = coordinates properties={} properties['name']=record[2] properties['category']=record[3] feature={} feature['type']='Feature' feature['geometry']=geometry feature['properties']=properties features=[feature] out = {} out['type'] = 'FeatureCollection' out['features'] = features cur.close() db.closedbconnection(conn) return out
def locate(q): q = unicode(q.decode("utf8")) q = q.upper() conn = db.opendbconnection() cur = conn.cursor() sql = "SELECT easting, northing, objektnamn, objekttyp FROM poi_skane_adressregister_apl WHERE objektnamn = (%s);" safeParam = (q, ) cur.execute(sql, safeParam) #cur.execute("SELECT objektnamn FROM poi_hbg_sok WHERE objektnamn like '" + q + "%';") features = [] for record in cur: coordinates = [record[0], record[1]] geometry = {} geometry['type'] = 'Point' geometry['coordinates'] = coordinates properties = {} properties['name'] = record[2] properties['category'] = record[3] feature = {} feature['type'] = 'Feature' feature['geometry'] = geometry feature['properties'] = properties features = [feature] out = {} out['type'] = 'FeatureCollection' out['features'] = features cur.close() db.closedbconnection(conn) return out
def _getCursor(self, cursor_factory=psycopg2.extras.DictCursor): conn = opendbconnection() #cur = cherrypy.thread_data.conn.cursor(cursor_factory=cursor_factory) cur = conn.cursor(cursor_factory=cursor_factory) return cur