Python訪問MongoDB資料庫

標籤：blog   資料   for   div   log   資料庫   sql   python   

#encoding: utf-8__author__ = ‘Administrator‘#import pymongofrom pymongo import MongoClient,GEO2Dimport sqlite3import sysimport psycopg2import ppygisimport cx_Oracleimport datetimereload(sys)#中文錯誤sys.setdefaultencoding( "utf-8" )#mongoclient = MongoClient("192.98.12.245",30007)db = client[‘tiledb‘]tiles = db[‘tiles‘]poi = db[‘poi‘]#assert isinstance(tiles, object)print(tiles.find_one())#拉框查詢函數def doWithinQuery():    print(poi.find({"loc":{"$within":{"$box":[[75.23,20.32],[152.23,60]]}}}).count())    for p in poi.find({"loc":{"$within":{"$box":[[75.23,20.32],[152.23,60]]}}}):        print p[‘address‘]def readSQLite2MongonDB():  #刪除以前記錄   poi.remove()   sql_txt = sqlite3.connect("c://POI.tdb")   cusor = sql_txt.cursor()   cusor.execute("select * from poi")   row = cusor.fetchone();   for _row in cusor.fetchall():     print _row     _p = {"name":_row[1],"address":_row[2],"loc":[_row[9],_row[10]]}     poi.insert(_p)   print("插入完畢...")