def dropTable(self, tableName): cursor = self.conn.cursor() sqlSentence = 'DROP TABLE %s' %tableName try: cursor.execute(sqlSentence) except mdb.Error, e: exceptMessage = 'Error %d: %s' %(e.args[0], e.args[1]) operateLog.writeLog(exceptMessage) cursor.close() return -1
def queryData(self, SQL): cursor = self.conn.cursor() try: cursor.execute(SQL) rows = cursor.fetchall() return rows except mdb.Error, e: exceptMessage = 'Error %d: %s' %(e.args[0], e.args[1]) operateLog.writeLog(exceptMessage) #print 'Error %d: %s' %(e.args[0], e.args[1]) cursor.close()
def __init__(self, host, userName, passwd, dbName): self.host = host self.userName = userName self.passwd = passwd self.dbName = dbName 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]) operateLog.writeLog(exceptMessage) #print 'Error %d: %s' %(e.args[0], e.args[1]) sys.exit(1)
def createTable(self): cursor = self.conn.cursor() try: cursor.execute("CREATE TABLE IF NOT EXISTS filelist( \ Id INT PRIMARY KEY AUTO_INCREMENT, \ fileName VARCHAR(200), \ Path VARCHAR(400), \ lastTimeModified VARCHAR(25)\ )") self.conn.commit() except mdb.Error, e: exceptMessage = 'Error %d: %s' %(e.args[0], e.args[1]) operateLog.writeLog(exceptMessage) #print 'Error %d: %s' %(e.args[0], e.args[1]) cursor.close()
def addData(self, fileName, Path, lastTimeModified): #print fileName cursor = self.conn.cursor() SQL = 'INSERT INTO filelist (fileName, Path, lastTimeModified) VALUES("%s", "%s", "%s")' %(fileName, Path, lastTimeModified) #print SQL #operateLog.writeLog('Insert %s' %fileName) try: cursor.execute(SQL) self.conn.commit() except mdb.Error, e: exceptMessage = 'Error %d: %s' %(e.args[0], e.args[1]) operateLog.writeLog(exceptMessage) #print 'Error %d: %s' %(e.args[0], e.args[1]) cursor.close() return -1
for root, dirs, files in os.walk(directory): for fi in files: filePath = root + "/" + fi filePath = filePath.replace("//", "/") fileInfo = os.stat(filePath) if chroot1 in filePath: filePath = filePath.replace(chroot1, url) else: filePath = filePath.replace(chroot2, url) timeInlist = list(time.localtime(fileInfo.st_ctime)[:6]) lenOfTimeList = len(timeInlist) for index in range(lenOfTimeList): timeInlist[index] = str(timeInlist[index]) fileTime = "-".join(timeInlist) operateMySQL.addData(fi, filePath, fileTime) operateMySQL.closeLink() if __name__ == "__main__": beginMessage = "***** Begin list FTP directory at : " + time.ctime() + " *****\n" operateLog.writeLog(beginMessage) listFileInThisDir("/var/ftp/") endMessage = "##### End list FTP directory at: " + time.ctime() + " #####\n" operateLog.writeLog(endMessage)