mongo db常见操作

1.命令窗口操作

1.1连接本地数据库

zxl@zxl:~$ mongo 127.0.0.1
MongoDB shell version: 2.6.10
connecting to: 127.0.0.1/test
Server has startup warnings: 
2019-09-19T08:21:59.078+0800 I CONTROL  [initandlisten] ** WARNING: You are running this process as the root user, which is not recommended.
2019-09-19T08:21:59.078+0800 I CONTROL  [initandlisten] 

1.2查看数据库

> show databases
autotest     0.078GB
local        0.078GB
zxl_test_db  0.203GB

1.3切换数据库

> use zxl_test_db
switched to db zxl_test_db

1.4查看数据库中的表

> show tables
system.indexes
table_10102

1.5一次查询行数

DBQuery.shellBatchSize = 300

1.6普通查询

> db.table_10102.find()

1.7统计查询结果次数

> db.table_10102.find().count()
22835

1.8组合查询

> db.table_10102.aggregate([{"$group": {'_id': {'id': "$id", 'version': "$version", 'ptf': "$ptf"}, 'count': {'$sum': 1}}}])

2.python查询

#! /usr/bin/env python
# -*- coding: utf-8 -*-

import pymongo
from bson.son import SON

MONGO_SERVER = "127.0.0.1"
MONGO_PORT = 27017
conn = pymongo.MongoClient(MONGO_SERVER, MONGO_PORT)
db = conn["zxl_test_db"]
table_10102 = db['table_10102']

if __name__ == "__main__":
    pipeline = [
        # {'$match': {'id': "5"}},
        # {'$match': {'version': "2"}},
        # {'$match': {'province': "广东省"}},
        # {'$match': {'province': []}},

        # {"$group": {"_id": "$province", "count": {"$sum": 1}}},
        {"$group": {'_id': {'id': "$id", 'version': "$version", 'ptf': "$ptf"}, 'count': {'$sum': 1}}},
        # {"$group": {'_id': {'province': "$province", 'city': "$city"}, 'count': {'$sum': 1}}},
        # {"$group": {"_id": "$city", "count": {"$sum": 1}}},
        # {"$group": {"_id": "$ip", "count": {"$sum": 1}}},
        
        {"$sort": SON([("count", -1), ("_id", -1)])}
    ]

    for item in db.table_10102.aggregate(pipeline):
        print(item)