- 论坛徽章:
- 0
|
本帖最后由 hucuibai 于 2014-08-19 17:39 编辑
{'sername': u'测试1服', u'old': 28.0, u'name': u'hucuibai'}
{'sername': u'测试1服', u'old': 22.0, u'name': u'\u80e1\u7fe0\u67cf'}
{'sername': u'测试1服', u'name': u'xiaobai'}
{'sername': u'测试1服', u'old': 99.0, u'name': u'xiaobaicat', u'sex': 1.0}
{'sername': u'测试1服', u'old': 28.0, u'name': u'hucuibai'}
{'sername': u'测试2服', u'old': 22.0, u'name': u'\u80e1\u7fe0\u67cf'}
{'sername': u'测试2服', u'name': u'xiaobai'}
{'sername': u'测试2服', u'old': 99.0, u'name': u'xiaobaicat', u'sex': 1.0}
我现在想做一个批量mongodb查询的工具,查询到的数据内容如上,怎么把这个内容显示到一个列表里面呢,这个列的数目不确定是多少列(这个又点麻烦),新手求教,还望高手指教指教,这个资料实在是不好找,我想用listtrl做但是做了一天都没做出来,还有个问题就是我想要批量查询,怎么才能在一个列表里面往列表后面追加呢,还有怎么能吧列表里面的内容导出,问题有点多,希望有人指导一下,谢谢,下面是我自己写的- class result_Frame(wx.Frame):
- def __init__(self):
- wx.Frame.__init__(self,None,-1)
- self.panel=wx.Panel(self)
-
- user='admin'
- password='newbie'
- db='test'
- col='test'
- f=open('ser_list.txt','r')
- for line in choice_list:
- result_dic=[]
- sername=line[0]
- ipaddr=line[1]
- client=mongo_con(ipaddr,user,password)
- max_len=0
- for i in client.exec_db(db,col,"find({},{'_id':False})"):
- i['sername']=sername
- result_dic.append(i)
- if len(i)>max_len:
- max_len=len(i)
- keys=i.keys()
- self.list=wx.ListCtrl(self.panel, -1, (15, 50), (500, 250), style=wx.LC_REPORT | wx.LC_HRULES | wx.LC_VRULES)
- for i in range(max_len):
- self.list.InsertColumn(i,keys[i])
- row=0
- for line in result_dic:
- print line
- self.list.InsertStringItem(row,sername)
- #self.list.SetStringItem(row,1,str(line['old']))
- if line['name']:
- self.list.SetStringItem(row,2,line['name'])
- row+=1
-
-
-
- f.close()
复制代码- import pymongo
- class mongo_con():
- def __init__(self,host,user,passwd):
- self.host=host
- self.port=27017
- self.user=user
- self.password=passwd
- self.client=pymongo.MongoClient(self.host,self.port)
- db=self.client['admin']
- db.authenticate(self.user,self.password)
- def exec_db(self,dbname,collection,query):
- list=[]
- db=self.client[dbname]
- col=db[collection]
- exec 'a=col.'+query
- return a
-
复制代码 |
|