Python MySQLUtils.insert_ohlc_data примеры использования

Пример #1

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])

Пример #2

Файл: fast_insert.py Проект: minghui/lquant

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])