def Host_item_list(self): self.HostListWindow.tableWidget.clear() hosts = db().upda("select * from ssh_host") host_g = db().upda("select * from ssh_group") self.HostListWindow.tableWidget.setRowCount(len(host_g[0] + hosts[0])) for _id, item in enumerate(host_g[0] + hosts[0]): if len(item) == 2: items = HostItemWidget(item[1], self.Dir_Pixmap, '分组', item) else: items = HostItemWidget(item[1], self.Re_Pixmap, item[2], item) items.Send_edit.connect(self.Updata_host) # items.Left_QPush.clicked.connect(lambda:self.Add_host(True,True,item)) # items.Left_QPush.clicked.connect(lambda:) items.Send_env.connect(self.Items_host) self.HostListWindow.tableWidget.setCellWidget(_id, 0, items)
def Items_host(self, ItemsList): self.HostList.tableWidget.clear() if len(ItemsList) == 2: host = db().upda("select * from ssh_host where hgroup='%s'" % ItemsList[1]) # if host[0]and len(ItemsList[0])==2: self.HostList.tableWidget.setRowCount(host[1]) for _id, item in enumerate(host[0]): items = HostItemWidget(item[1], self.Re_Pixmap, item[2], item) items.Send_edit.connect(self.Updata_host) # items.Left_QPush.clicked.connect(lambda:self.Add_host(True,True,item)) items.Send_env.connect(self.return_hosts) self.HostList.tableWidget.setCellWidget(_id, 0, items) else: self.return_hosts(ItemsList) return self.HostListWindow_Out.setStartValue( QRect(0, 0, self.width(), self.height())) self.HostListWindow_Out.setEndValue( QRect(0 - self.width(), 0, self.width(), self.height())) self.HostList_Out.setStartValue( QtCore.QRect(self.width(), 0, self.width(), self.height())) self.HostList_Out.setEndValue(QRect(0, 0, self.width(), self.height())) self.HostListWindow_Out.start() self.HostList_Out.start()
def get_ip_address_and_port(self): from DB import db default_value = "localhost:%r" % self.default_port return db(self.ip_address_and_port_db, default_value)
import pandas from DB import db from Preprocessing import preprocess count = 0 db = db() allTweets = db.getAll() hashtagDatetimes = [] for tweet in allTweets: # Hashtags list terms_hash = [ term for term in preprocess(tweet['text'].lower()) if term.startswith('#') ] if '#kathygriffin' in terms_hash: hashtagDatetimes.append(tweet['created_at']) # if count == 60000: # break count += 1 print("\rLive number of processed tweets: " + str(count), end="") print("\n") print("length of occurence array : " + str(len(hashtagDatetimes))) # a list of "1" to count the hashtags ones = [1] * len(hashtagDatetimes) # the index of the series idx = pandas.DatetimeIndex(hashtagDatetimes)
def addhost(self): if not self.lineEdit.text() or not self.lineEdit_2.text( ) or not self.lineEdit_3.text(): return if not re.match( r"^(?:(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.){3}(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$", self.lineEdit_2.text()): print('IP地址格式不正确') return if self.sender().text() == '更新': self.pushButton.setText("添加") db().upda("update ssh_host set name='%s',host='%s',port='%s',user='******',passwd='%s',cer='%s',hgroup='%s',cmd='%s' where id='%s'"%\ (self.lineEdit.text(),self.lineEdit_2.text(),self.lineEdit_3.text(),self.lineEdit_4.text(),\ self.lineEdit_5.text(),self.lineEdit_6.text(),self.lineEdit_7.text(),self.lineEdit_8.text(),self.host_id)) elif self.sender().text() == '删除': db().upda("delete from ssh_host where id='%s'" % self.host_id) else: # 判断是否有重复IP if db().upda("select * from ssh_host where name ='%s'" % self.lineEdit.text())[0]: print('名称重复') return if db().upda("select * from ssh_host where host ='%s'" % self.lineEdit_2.text())[0]: print('IP重复') return db().upda("insert into ssh_host values (null,'%s','%s','%s','%s','%s','%s','%s','%s') " % \ (self.lineEdit.text(),self.lineEdit_2.text(),self.lineEdit_3.text(),self.lineEdit_4.text(),\ self.lineEdit_5.text(),self.lineEdit_6.text(),self.lineEdit_7.text(),self.lineEdit_8.text())) if not db().upda( "select * from ssh_group where hgroup ='%s'" % self.lineEdit_7.text())[0] and self.lineEdit_7.text() != '': db().upda("insert into ssh_group values(null,'%s')" % self.lineEdit_7.text()) for item in db().upda("select * from ssh_group")[0]: if item: if not db().upda("select * from ssh_host where hgroup='%s'" % item[1])[0]: db().upda("delete from ssh_group where id='%s'" % item[0]) self.Send_clos.emit() self.clear_text()
def configuration_names(cls): from DB import db return db("configuration.names",[])
def __getitem__(self,row): from DB import db if type(row) == slice: value = [x for x in self] else: value = db(self.db_key(row),self.default_value) return value
wx.App.__init__(self) frame=View.mainFrame.myFrame(None,-1,"Stock Wizard") ctrl = Controller(db, frame) frame.gridPanel.setStyle() frame.Show() frame.Raise() if __name__ == '__main__': print "App Start" dbFile='stockDB.db' print path.realpath(dbFile) DB=db(dbFile) #DB=db("%s/%s" % (sys.path[0],dbFile)) for tbl in DB.tables: if tbl.shouldUpdate==False:continue try: tbl.update() except Exception as ex: print "error : %s" % (ex,) app = myApp(DB) app.MainLoop() DB.closeCursor() print "App End"