def insert_data(parameter): db = MySQLUtils(user='******', passwd='1988', dbname='stock', source='stock') # print parameter for stock in parameter: data = mlab.csv2rec(stock, delimiter='\t') pattern = re.compile("[SH]*[SZ]*[0-9]{6}", re.IGNORECASE) m = pattern.findall(stock) if len(m) == 1: # print data db.insert_ohlc_data(data, m[0])