mogo操作

1.insert
db.person.inert({"name":"jack","age":20})

2.find
db.person.find({"name":joe})

3.update
db.person.update({"name":"joe"},{"name":"joe","age":30})

4.remove
db.person.remove({"name":"joe"})

5.有条件的查询
db.org_statistics.find({orgCode:'600087'},{_id:0,createTime:1}).sort({ statDate:1 }).limit(5)
查询orgCode为600087的数据，仅返回createTime,按照statDate的升序排列，-1为降序排列，限制5条

db.driver_statistics.find({driverName:'LFC'})

db.truck_statistics.find({})
db.truck_statistics.find({truckNum:'389B60DB65114708BA271AAC5F41DB628E'})
db.truck_statistics.find({truckNum:'387DA01286730A1602A092DDA14029453F',periodType:'YEAR'})
db.truck_statistics.find({truckNum:'387DA01286730A1602A092DDA14029453F',periodType:'MONTH'})
db.truck_statistics.find({truckNum:'387DA01286730A1602A092DDA14029453F',periodType:'WEEK'})
db.truck_statistics.find({truckNum:'387DA01286730A1602A092DDA14029453F',periodType:'DAY'})
db.truck_statistics.find({truckNum:'387DA01286730A1602A092DDA14029453F',periodType:'DAY',statDate:ISODate("2016-07-18T16:00:00.000Z")})
特定时间段
db.truck_statistics.aggregate([{"$match": {"truckNum":'387DA01286730A1602A092DDA14029453F',periodType:'DAY',statDate : {$gte : ISODate("2016-07-15T16:00:00.000Z"),$lte : ISODate("2016-07-19T16:00:00.000Z")}}},{$group:{_id:"truckNum",count:{$sum:"$totalFuel"}}}])

1、cat_truck里面的truck_driver中 查看司机名字，找司机的id

2、DSP的数据库：
     cw_cnn_status中
        （1）表driver_info 中用司机的id查找，然后更改司机的姓名
        （2）表driver_sign 中用司机的id查找，然后更改司机的姓名
     
     ext_device中该表trip的司机名字

3、在芒果数据库中更新名字

nosql 学习链接
http://www.runoob.com/mongodb/mongodb-operators.html

单个司机统计，insert
db.getCollection("driver_statistics").update({_id:ObjectId("578b33aaa69e7c680ef6a283")},{$set:{
    "driverNO" : "12A99179586869A90CAC775068690C55",
    "orgCode" : "2002UR",
    "periodType" : "DAY",
    "statDate" : ISODate("2016-07-11T16:00:00.000Z"),
    "createTime" : "",
    "updateTime" : ISODate("2016-07-08T08:55:01.223Z"),
    "totalFuel" : 10,
    "driverTime" : NumberLong("3600"),
    "dTUpdateTIme" : ISODate("2016-07-12T02:05:03.736Z"),
    "totalMileage" : NumberLong("10000000"),
    "driverName" : "黄宇"
}})
单个司机统计查询 db.driver_statistics.find({"driverNO":"CEEAC3C2DE2E3E585F81556C83BAB07C", "periodType":"DAY"})

DAY
db.getCollection("driver_statistics").insert([{
    "driverNO" : "12A99179586869A90CAC775068690C55",
    "orgCode" : "2002UR",
    "periodType" : "DAY",
    "statDate" : ISODate("2016-06-30T16:00:00.000Z"),
    "createTime" : "",
    "updateTime" : ISODate("2016-07-08T08:55:01.223Z"),
    "totalFuel" : 19,
    "driverTime" : NumberLong("36000"),
    "dTUpdateTIme" : ISODate("2016-07-12T02:05:03.736Z"),
    "totalMileage" : NumberLong("999999"),
    "driverName" : "黄宇"
},
{
    "driverNO" : "12A99179586869A90CAC775068690C55",
    "orgCode" : "2002UR",
    "periodType" : "DAY",
    "statDate" : ISODate("2016-07-01T16:00:00.000Z"),
    "createTime" : "",
    "updateTime" : ISODate("2016-07-08T08:55:01.223Z"),
    "totalFuel" : 10,
    "driverTime" : NumberLong("3600"),
    "dTUpdateTIme" : ISODate("2016-07-12T02:05:03.736Z"),
    "totalMileage" : NumberLong("10000000"),
    "driverName" : "黄宇"
}])

MONTH
db.getCollection("driver_statistics").insert([{
    "driverNO" : "12A99179586869A90CAC775068690C55",
    "orgCode" : "2002UR",
    "periodType" : "MONTH",
    "statDate" : ISODate("2016-05-31T16:00:00.000Z"),
    "createTime" : ISODate("2015-05-30T08:55:01.223Z"),
    "updateTime" : ISODate("2015-05-30T08:55:01.223Z"),
    "totalFuel" : 19,
    "driverTime" : NumberLong("36000"),
    "dTUpdateTIme" : ISODate("2015-05-30T02:05:03.736Z"),
    "totalMileage" : NumberLong("999999"),
    "driverName" : "黄宇"
},
{
    "driverNO" : "12A99179586869A90CAC775068690C55",
    "orgCode" : "2002UR",
    "periodType" : "MONTH",
    "statDate" : ISODate("2016-05-31T16:00:00.000Z"),
    "createTime" : ISODate("2016-05-31T08:55:01.223Z"),
    "updateTime" : ISODate("2016-05-31T08:55:01.223Z"),
    "totalFuel" : 10,
    "driverTime" : NumberLong("3600"),
    "dTUpdateTIme" : ISODate("2016-05-31T02:05:03.736Z"),
    "totalMileage" : NumberLong("10000000"),
    "driverName" : "黄宇"
}])