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 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110
| #构造一些测试数据 use tanhua
db.recommend_user.insert({"userId":2,"toUserId":1,"score":31,"date":"2019/1/1"}) db.recommend_user.insert({"userId":3,"toUserId":1,"score":54,"date":"2019/1/1"}) db.recommend_user.insert({"userId":4,"toUserId":1,"score":78,"date":"2019/1/1"}) db.recommend_user.insert({"userId":5,"toUserId":1,"score":57,"date":"2019/1/1"}) db.recommend_user.insert({"userId":6,"toUserId":1,"score":79,"date":"2019/1/1"}) db.recommend_user.insert({"userId":7,"toUserId":1,"score":31,"date":"2019/1/1"}) db.recommend_user.insert({"userId":8,"toUserId":1,"score":39,"date":"2019/1/1"}) db.recommend_user.insert({"userId":9,"toUserId":1,"score":68,"date":"2019/1/1"}) db.recommend_user.insert({"userId":10,"toUserId":1,"score":58,"date":"2019/1/1"}) db.recommend_user.insert({"userId":11,"toUserId":1,"score":47,"date":"2019/1/1"}) db.recommend_user.insert({"userId":12,"toUserId":1,"score":91,"date":"2019/1/1"}) db.recommend_user.insert({"userId":13,"toUserId":1,"score":47,"date":"2019/1/1"}) db.recommend_user.insert({"userId":14,"toUserId":1,"score":83,"date":"2019/1/1"}) db.recommend_user.insert({"userId":15,"toUserId":1,"score":81,"date":"2019/1/1"}) db.recommend_user.insert({"userId":16,"toUserId":1,"score":96,"date":"2019/1/1"}) db.recommend_user.insert({"userId":17,"toUserId":1,"score":38,"date":"2019/1/1"}) db.recommend_user.insert({"userId":18,"toUserId":1,"score":91,"date":"2019/1/1"}) db.recommend_user.insert({"userId":19,"toUserId":1,"score":39,"date":"2019/1/1"}) db.recommend_user.insert({"userId":20,"toUserId":1,"score":35,"date":"2019/1/1"}) db.recommend_user.insert({"userId":21,"toUserId":1,"score":74,"date":"2019/1/1"}) db.recommend_user.insert({"userId":22,"toUserId":1,"score":33,"date":"2019/1/1"}) db.recommend_user.insert({"userId":23,"toUserId":1,"score":77,"date":"2019/1/1"}) db.recommend_user.insert({"userId":24,"toUserId":1,"score":74,"date":"2019/1/1"}) db.recommend_user.insert({"userId":25,"toUserId":1,"score":49,"date":"2019/1/1"}) db.recommend_user.insert({"userId":26,"toUserId":1,"score":63,"date":"2019/1/1"}) db.recommend_user.insert({"userId":27,"toUserId":1,"score":63,"date":"2019/1/1"}) db.recommend_user.insert({"userId":28,"toUserId":1,"score":33,"date":"2019/1/1"}) db.recommend_user.insert({"userId":29,"toUserId":1,"score":32,"date":"2019/1/1"}) db.recommend_user.insert({"userId":30,"toUserId":1,"score":65,"date":"2019/1/1"}) db.recommend_user.insert({"userId":31,"toUserId":1,"score":73,"date":"2019/1/1"}) db.recommend_user.insert({"userId":32,"toUserId":1,"score":78,"date":"2019/1/1"}) db.recommend_user.insert({"userId":33,"toUserId":1,"score":78,"date":"2019/1/1"}) db.recommend_user.insert({"userId":34,"toUserId":1,"score":98,"date":"2019/1/1"}) db.recommend_user.insert({"userId":35,"toUserId":1,"score":65,"date":"2019/1/1"}) db.recommend_user.insert({"userId":36,"toUserId":1,"score":64,"date":"2019/1/1"}) db.recommend_user.insert({"userId":37,"toUserId":1,"score":79,"date":"2019/1/1"}) db.recommend_user.insert({"userId":38,"toUserId":1,"score":85,"date":"2019/1/1"}) db.recommend_user.insert({"userId":39,"toUserId":1,"score":97,"date":"2019/1/1"}) db.recommend_user.insert({"userId":40,"toUserId":1,"score":79,"date":"2019/1/1"}) db.recommend_user.insert({"userId":41,"toUserId":1,"score":62,"date":"2019/1/1"}) db.recommend_user.insert({"userId":42,"toUserId":1,"score":38,"date":"2019/1/1"}) db.recommend_user.insert({"userId":43,"toUserId":1,"score":56,"date":"2019/1/1"}) db.recommend_user.insert({"userId":44,"toUserId":1,"score":82,"date":"2019/1/1"}) db.recommend_user.insert({"userId":45,"toUserId":1,"score":36,"date":"2019/1/1"}) db.recommend_user.insert({"userId":46,"toUserId":1,"score":82,"date":"2019/1/1"}) db.recommend_user.insert({"userId":47,"toUserId":1,"score":58,"date":"2019/1/1"}) db.recommend_user.insert({"userId":48,"toUserId":1,"score":53,"date":"2019/1/1"}) db.recommend_user.insert({"userId":49,"toUserId":1,"score":53,"date":"2019/1/1"}) db.recommend_user.insert({"userId":50,"toUserId":1,"score":90,"date":"2019/1/1"}) db.recommend_user.insert({"userId":51,"toUserId":1,"score":79,"date":"2019/1/1"}) db.recommend_user.insert({"userId":52,"toUserId":1,"score":40,"date":"2019/1/1"}) db.recommend_user.insert({"userId":53,"toUserId":1,"score":36,"date":"2019/1/1"}) db.recommend_user.insert({"userId":54,"toUserId":1,"score":32,"date":"2019/1/1"}) db.recommend_user.insert({"userId":55,"toUserId":1,"score":54,"date":"2019/1/1"}) db.recommend_user.insert({"userId":56,"toUserId":1,"score":31,"date":"2019/1/1"}) db.recommend_user.insert({"userId":57,"toUserId":1,"score":92,"date":"2019/1/1"}) db.recommend_user.insert({"userId":58,"toUserId":1,"score":58,"date":"2019/1/1"}) db.recommend_user.insert({"userId":59,"toUserId":1,"score":70,"date":"2019/1/1"}) db.recommend_user.insert({"userId":60,"toUserId":1,"score":53,"date":"2019/1/1"}) db.recommend_user.insert({"userId":61,"toUserId":1,"score":97,"date":"2019/1/1"}) db.recommend_user.insert({"userId":62,"toUserId":1,"score":89,"date":"2019/1/1"}) db.recommend_user.insert({"userId":63,"toUserId":1,"score":63,"date":"2019/1/1"}) db.recommend_user.insert({"userId":64,"toUserId":1,"score":51,"date":"2019/1/1"}) db.recommend_user.insert({"userId":65,"toUserId":1,"score":43,"date":"2019/1/1"}) db.recommend_user.insert({"userId":66,"toUserId":1,"score":65,"date":"2019/1/1"}) db.recommend_user.insert({"userId":67,"toUserId":1,"score":45,"date":"2019/1/1"}) db.recommend_user.insert({"userId":68,"toUserId":1,"score":31,"date":"2019/1/1"}) db.recommend_user.insert({"userId":69,"toUserId":1,"score":40,"date":"2019/1/1"}) db.recommend_user.insert({"userId":70,"toUserId":1,"score":37,"date":"2019/1/1"}) db.recommend_user.insert({"userId":71,"toUserId":1,"score":42,"date":"2019/1/1"}) db.recommend_user.insert({"userId":72,"toUserId":1,"score":56,"date":"2019/1/1"}) db.recommend_user.insert({"userId":73,"toUserId":1,"score":59,"date":"2019/1/1"}) db.recommend_user.insert({"userId":74,"toUserId":1,"score":39,"date":"2019/1/1"}) db.recommend_user.insert({"userId":75,"toUserId":1,"score":81,"date":"2019/1/1"}) db.recommend_user.insert({"userId":76,"toUserId":1,"score":85,"date":"2019/1/1"}) db.recommend_user.insert({"userId":77,"toUserId":1,"score":59,"date":"2019/1/1"}) db.recommend_user.insert({"userId":78,"toUserId":1,"score":41,"date":"2019/1/1"}) db.recommend_user.insert({"userId":79,"toUserId":1,"score":39,"date":"2019/1/1"}) db.recommend_user.insert({"userId":80,"toUserId":1,"score":96,"date":"2019/1/1"}) db.recommend_user.insert({"userId":81,"toUserId":1,"score":65,"date":"2019/1/1"}) db.recommend_user.insert({"userId":82,"toUserId":1,"score":58,"date":"2019/1/1"}) db.recommend_user.insert({"userId":83,"toUserId":1,"score":37,"date":"2019/1/1"}) db.recommend_user.insert({"userId":84,"toUserId":1,"score":72,"date":"2019/1/1"}) db.recommend_user.insert({"userId":85,"toUserId":1,"score":48,"date":"2019/1/1"}) db.recommend_user.insert({"userId":86,"toUserId":1,"score":50,"date":"2019/1/1"}) db.recommend_user.insert({"userId":87,"toUserId":1,"score":77,"date":"2019/1/1"}) db.recommend_user.insert({"userId":88,"toUserId":1,"score":32,"date":"2019/1/1"}) db.recommend_user.insert({"userId":89,"toUserId":1,"score":45,"date":"2019/1/1"}) db.recommend_user.insert({"userId":90,"toUserId":1,"score":88,"date":"2019/1/1"}) db.recommend_user.insert({"userId":91,"toUserId":1,"score":59,"date":"2019/1/1"}) db.recommend_user.insert({"userId":92,"toUserId":1,"score":45,"date":"2019/1/1"}) db.recommend_user.insert({"userId":93,"toUserId":1,"score":80,"date":"2019/1/1"}) db.recommend_user.insert({"userId":94,"toUserId":1,"score":31,"date":"2019/1/1"}) db.recommend_user.insert({"userId":95,"toUserId":1,"score":61,"date":"2019/1/1"}) db.recommend_user.insert({"userId":96,"toUserId":1,"score":87,"date":"2019/1/1"}) db.recommend_user.insert({"userId":97,"toUserId":1,"score":80,"date":"2019/1/1"}) db.recommend_user.insert({"userId":98,"toUserId":1,"score":59,"date":"2019/1/1"}) db.recommend_user.insert({"userId":99,"toUserId":1,"score":49,"date":"2019/1/1"})
#无条件查询,看数据是否写入去了 > show tables recommend_user > db.recommend_user.find({})
#创建索引,toUserId:正序,score:倒序 db.recommend_user.createIndex({'toUserId':1,'score':-1})
|