def __init__(self, host, userName, passwd, dbName): self.host = host self.userName = userName self.passwd = passwd self.dbName = dbName self.logger = operateLog.initLog() try: self.conn = mdb.connect(self.host, self.userName, self.passwd, self.dbName) #cursor = self.conn.cursor() except mdb.Error, e: exceptMessage = 'Error %d: %s' %(e.args[0], e.args[1]) self.logger.error(exceptMessage) #operateLog.writeLog(exceptMessage) #print 'Error %d: %s' %(e.args[0], e.args[1]) sys.exit(1)
def __init__(self, host, userName, passwd, dbName): self.host = host self.userName = userName self.passwd = passwd self.dbName = dbName self.logger = operateLog.initLog() try: self.conn = mdb.connect(self.host, self.userName, self.passwd, self.dbName) #cursor = self.conn.cursor() except mdb.Error, e: exceptMessage = 'Error %d: %s' % (e.args[0], e.args[1]) self.logger.error(exceptMessage) #operateLog.writeLog(exceptMessage) #print 'Error %d: %s' %(e.args[0], e.args[1]) sys.exit(1)
fileTime = '-'.join(timeInlist) #dataFromQuery = operateMySQL.queryData('SELECT * FROM filelist WHERE Path = "%s"' %filePath) #if dataFromQuery != None: # lenOfRows = len(dataFromQuery) #fileHandler.write(fi+' '+filePath+' '+fileTime+'\n') #if dataFromQuery == None or lenOfRows == 0: print "add one file" operateMySQL.addData(fi, filePath, fileTime) #for row in operateMySQL.queryData("SELECT * FROM filelist"): # print row[0], row[1], row[2], row[3] operateMySQL.closeLink() if __name__ == '__main__': logger = operateLog.initLog() #beginMessage = '***** Begin list FTP directory at : ' + time.ctime() + ' *****\n' #operateLog.writeLog(beginMessage) beginMessage = 'Begin list FTP directory.' logger.info(beginMessage) listFileInThisDir('/var/ftp/project/+WSN/') #endMessage = '##### End list FTP directory at: ' + time.ctime() + ' #####\n' #operateLog.writeLog(endMessage) endMessage = 'End list FTP directory' logger.info(endmessage)