mongodb 数据生成Insert 语句的示例代码
时间:2021-10-22 09:09:01|栏目:mongodb|点击: 次
执行:
db.getCollection('cap.published').find({}).forEach(function(item){ print( 'db.getCollection("cap.published").insert(' + tojson(item) + ');' ); });
返回结果:
db.getCollection("cap.published").insert({ "_id" : NumberLong("1102078858484363264"), "Name" : "order.rabbitmq.mongodb", "Content" : "{\"Id\":\"5c7b668a61ff69508c6804e4\",\"Timestamp\":\"2019-03-03T13:30:50.1988102+08:00\",\"Content\":\"2019/3/3 13:30:50\",\"CallbackName\":null}", "Added" : ISODate("2019-03-03T05:30:50.151Z"), "ExpiresAt" : null, "Retries" : 0, "StatusName" : "Scheduled", "Version" : "v1" }); db.getCollection("cap.published").insert({ "_id" : NumberLong("1102079247510253568"), "Name" : "order.rabbitmq.mongodb", "Content" : "{\"Id\":\"5c7b66e661ff69508c6804e7\",\"Timestamp\":\"2019-03-03T13:32:22.9051009+08:00\",\"Content\":\"2019/3/3 13:32:22\",\"CallbackName\":null}", "Added" : ISODate("2019-03-03T05:32:22.905Z"), "ExpiresAt" : null, "Retries" : 0, "StatusName" : "Scheduled", "Version" : "v1" }); db.getCollection("cap.published").insert({ "_id" : NumberLong("1102080584656740352"), "Name" : "order.rabbitmq.mongodb", "Content" : "{\"Id\":\"5c7b682561ff692e5cdee269\",\"Timestamp\":\"2019-03-03T13:37:41.9368025+08:00\",\"Content\":\"2019/3/3 13:37:41\",\"CallbackName\":null}", "Added" : ISODate("2019-03-03T05:37:41.699Z"), "ExpiresAt" : null, "Retries" : 0, "StatusName" : "Scheduled", "Version" : "v1" }); db.getCollection("cap.published").insert({ "_id" : NumberLong("1102081814329499648"), "Name" : "order.rabbitmq.mongodb", "Content" : "{\"Id\":\"5c7b694a61ff69321cd19bc4\",\"Timestamp\":\"2019-03-03T13:42:34.933565+08:00\",\"Content\":\"2019/3/3 13:42:34\",\"CallbackName\":null}", "Added" : ISODate("2019-03-03T05:42:34.879Z"), "ExpiresAt" : null, "Retries" : 0, "StatusName" : "Scheduled", "Version" : "v1" }); db.getCollection("cap.published").insert({ "_id" : NumberLong("1102082932053180416"), "Name" : "order.rabbitmq.mongodb", "Content" : "{\"Id\":\"5c7b6a5561ff692ef44a8c2b\",\"Timestamp\":\"2019-03-03T13:47:01.4290666+08:00\",\"Content\":\"2019/3/3 13:47:01\",\"CallbackName\":null}", "Added" : ISODate("2019-03-03T05:47:01.366Z"), "ExpiresAt" : null, "Retries" : 0, "StatusName" : "Scheduled", "Version" : "v1" });