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