首页 > 代码库 > Python访问MongoDB数据库
Python访问MongoDB数据库
#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("插入完毕...")
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。