python实践——批量统计mongodb数据库的集合大小

#!/usr/bin/env python
import os,sys
list = []
for i in range(3,50):
    l = os.popen("/bin/echo 'show collections'| /usr/local/mongodb/mongodb/bin/mongo 127.0.0.1:27103/数据库名|sed -n '%sp'" %i)      #获取数据库的集合列表
    l = l.read()
    if l != "":
        list.append(l)
    else:
        print "the collections is %s" %i
        del list[i-4]
        break
for i in list:
        i = i.strip("
")
        os.popen("/bin/echo 'db.%s.stats()'| /usr/local/mongodb/mongodb/bin/mongo 127.0.0.1:27103/数据库名|sed -n '4p;6p;8p'>>mongodb_size_count.txt" %i)   #统计集合的大小并把结果写入mongodb_size_count.txt文件中