mongodb 数据生成Insert 语句的示例代码

时间:2021-12-19 21:22:53

执行: 

?
1
2
3
db.getcollection('cap.published').find({}).foreach(function(item){
    print( 'db.getcollection("cap.published").insert(' + tojson(item) + ');' );
});

返回结果:

mongodb 数据生成Insert 语句的示例代码

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
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"
});

到此这篇关于mongodb 数据生成insert 语句的示例代码的文章就介绍到这了,更多相关mongodb生成insert 语句内容请搜索服务器之家以前的文章或继续浏览下面的相关文章希望大家以后多多支持服务器之家!

原文链接:https://blog.csdn.net/xiaoxionglove/article/details/114991566