results = {} if len(sql_list) != 0: for sql in sql_list: try: # Only print select statment # if sql.strip().lower().startswith('select'): logger.debug('Execute SQL: %s' % sql) cursor.execute(sql) results[sql] = cursor.fetchall() except Exception, e: logger.error('Execute SQL "%s" failed! The rease is:\n%s' % (sql, str(e))) results[sql] = [] finally: cursor.close() else: logger.error('The SQL statment is None!') return results def mexec_sql(self, sql_list): '''Batch execute sql, which is none returns. Arguments: sql_list {list} -- The list of sql statments which will be executed ''' cursor = self.connection.cursor() if len(sql_list) != 0: for sql in sql_list:
target = '20190810.tar.gz' client = FtpClient(ip, port, user, passwd) while True: try: logger.info('Try to login ftp: {}:{} with {} / {}'.format( ip, port, user, passwd)) client.login() client.set_debug() logger.info('Ftp login success.') # client.list_files('*') client.set_pasv(True) logger.info( 'Starting download file: {} using pasv mode.'.format(target)) client.download(target, os.path.join(os.getcwd(), target)) logger.info( 'Downloading file {} success using pasv mode.'.format(target)) client.set_pasv(False) logger.info( 'Starting download file: {} using port mode.'.format(target)) client.download(target, os.path.join(os.getcwd(), target)) logger.info( 'Downloading file {} success using port mode.'.format(target)) except Exception, e: logger.error('Error occourded: {}'.format(e)) finally: client.close() time.sleep(300)