This article mainly introduces how python reads json files and inserts data into mongodb. it analyzes Python's skills in operating json and mongodb databases, for more information about how to read json files and insert data to mongodb, see the example in this article. Share it with you for your reference. The specific implementation method is as follows:
#coding=utf-8import sunburntimport urllibfrom pymongo import Connectionfrom bson.objectid import ObjectIdimport loggingfrom datetime import datetimeimport jsonfrom time import mktimefrom feedparser import _parse_date as parse_dateimport timeimport sysimport getoptimport ConfigParserargs = sys.argv[1:]optlist, args = getopt.getopt(args, 'c:')cmd_opt = {}for opt in optlist: cmd_opt[opt[0]] = opt[1]conf_file = cmd_opt['-c']config = ConfigParser.ConfigParser()config.read(conf_file)hostname = config.get("mongodb", "hostname")port_num = int(config.get("mongodb", "port_num"))db_name = config.get("mongodb", "db")connection = Connection(hostname, port_num)db = connection[db_name]courseTable = db.courselecTable = db.lecturetry: f = file("json1-14/14.json") s = json.load(f) courseData = s["results"]["course"] lecDataArr = s["results"]["lecture"] f.close print "get file content successfully!" #insert course courseId = courseTable.save(courseData) courseId = str(courseId) print "courseId: "+courseId print "lec length: "+str(len(lecDataArr)) #insert lecture lecIdArr = [] for lecData in lecDataArr: lecData["course_id"] = courseId lecId = lecTable.save(lecData) lecIdArr.append(str(lecId)) # update course courseTable.update({'_id':ObjectId(courseId)}, {"$set":{"lectures.lecture_id_list":lecIdArr}}, upsert=True, multi=True); print 'insert successfully!'except Exception, e: print e
I hope this article will help you with Python programming.