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)
