• MongoDB使用python脚本写入数据


    批量写:

     1 from pymongo import MongoClient
     2 from pymongo import InsertOne
     3 import time
     4 
     5 def insert():
     6     #连接数据库
     7     conn = MongoClient("XXX.XXX.XXX.XXX:XXXX",maxPoolSize=None)
     8     my_db = conn['test']
     9     my_collection = my_db['test_1']
    10 
    11     # 批量写
    12     i = 0
    13     t0 = time.time()
    14     data =[]
    15     while True:
    16         #'_id'为主键,循环时递增,全部添加到data列表内
    17         data.append(InsertOne({"_id":i,"insert_time": int(time.time() * 1000)}))
    18         i+=1
    19         #判断列表长度,达到10000执行插入,后继续循环
    20         if len(data) == 10000:
    21             my_collection.bulk_write(data)
    22             res = []
    23             i += 1
    24             continue
    25       #判断i等于1亿时停止循环
    26       elif i == 100000000:
    27              break
    28 
    29 if __name__ == '__main__':
    30     insert()

    逐条写:

    1 def test_insert():
    2     conn = MongoClient("xxx.xxx.xxx.xxx:xxxx",maxPoolSize=None)
    3     my_db = conn['test']
    5     # 逐条写
    6     t0 = time.time()
    7     for i in range(0,10000000):
    8         my_db['test_1'].insert_one({"_id":i, "insert_time": int(time.time() * 1000)})
    9     print (time.time() - t0)

      

  • 相关阅读:
    面相对象2016/4/19
    2016/4/19
    ajax2016/4/15 post与get
    iframe2016/4/12
    Hibernate报错解决Error parsing JNDI name [],Need to specify class name
    vue-router 源码解析最简版
    vue数据响应式原理
    3-箭头函数与普通函数
    2.1.7 html的处理与打包
    2.1.6 css的编译与处理 -2
  • 原文地址:https://www.cnblogs.com/wuhl-89/p/10141918.html
Copyright © 2020-2023  润新知