def tick_insert(data):
logging.debug("tick_data_rows: %d", len(data))
dtypes = { k: VARCHAR(32) for k, v in data.dtypes.items() if v.name == 'object'}
dtypes['time'] = DATETIME
with db_buffer.connect() as conn:
data.to_sql('tick_data', conn, if_exists="append", index=False, dtype=dtypes, chunksize=None)
评论列表
文章目录