libiya2000 wrote:
我用楼主的代码加载tick数据到mysql的时候，500毫秒级的数据就存不到mysql, 就被忽略了，楼主的代码我用的没问题，但是感觉python 在处理mysql数据的datetime的时候，吧毫秒级别的处理没了。
mysql5.6 和 mysql8.0 我都试验过，都是这样的结果。这块儿怎么改。有遇到过的吗？
按照您的修改了，tick的毫秒出现啦，牛
libiya2000 wrote:
我用楼主的代码加载tick数据到mysql的时候，500毫秒级的数据就存不到mysql, 就被忽略了，楼主的代码我用的没问题，但是感觉python 在处理mysql数据的datetime的时候，吧毫秒级别的处理没了。
mysql5.6 和 mysql8.0 我都试验过，都是这样的结果。这块儿怎么改。有遇到过的吗？
按照您的修改了，tick的毫秒出现啦，牛
好帖子，后悔没有早点看到
Traceback (most recent call last):
File "C:\veighna_studio\lib\site-packages\vnpy_datamanager\ui\widget.py", line 226, in import_data
start, end, count = self.engine.import_data_from_csv(
File "C:\veighna_studio\lib\site-packages\vnpy_datamanager\engine.py", line 59, in import_data_from_csv
dt: datetime = datetime.strptime(item[datetime_head], datetime_format)
File "C:\veighna_studio\lib_strptime.py", line 568, in _strptime_datetime
tt, fraction, gmtoff_fraction = _strptime(data_string, format)
File "C:\veighna_studio\lib_strptime.py", line 349, in _strptime
raise ValueError("time data %r does not match format %r" %
ValueError: time data '9:00:00' does not match format '%Y-%m-%d %H:%M:%S'
纯纯的小白 这个错误是指我的时间戳不对吗？
时间格式要设置成年-月-日 时：分：秒
七月雪 wrote:
时间格式要设置成年-月-日 时：
有了有了 谢谢谢谢
七月雪 wrote:
时间格式要设置成年-月-日 时：分：秒
那个 我把回测弄崩溃了
Traceback (most recent call last):
File "C:\veighna_studio\lib\site-packages\vnpy\trader\ui\mainwindow.py", line 276, in open_widget
widget = widget_class(self.main_engine, self.event_engine)
File "C:\veighna_studio\lib\site-packages\vnpy_ctastrategy\ui\widget.py", line 41, in init
self.cta_engine.init_engine()
File "C:\veighna_studio\lib\site-packages\vnpy_ctastrategy\engine.py", line 115, in init_engine
self.init_datafeed()
File "C:\veighna_studio\lib\site-packages\vnpy_ctastrategy\engine.py", line 137, in init_datafeed
result: bool = self.datafeed.init()
File "C:\veighna_studio\lib\site-packages\vnpy_rqdata\rqdata_datafeed.py", line 123, in init
df: DataFrame = all_instruments()
File "C:\veighna_studio\lib\site-packages\rqdatac\decorators.py", line 150, in wrap
return func(args, **kwargs)
File "C:\veighna_studio\lib\site-packages\rqdatac\services\basic.py", line 385, in all_instruments
ins_ret = filter(cond, get_instrument_list(market))
File "C:\veighna_studio\lib\site-packages\rqdatac\decorators.py", line 129, in wrapper
value = user_function(args, kwargs)
File "C:\veighna_studio\lib\site-packages\rqdatac\services\basic.py", line 139, in _all_cached_instruments_list
return _all_instruments_list(market)
File "C:\veighna_studio\lib\site-packages\rqdatac\services\basic.py", line 116, in _all_instruments_list
ins = [Instrument(i) for i in get_client().execute("all_instruments", market=market)]
File "C:\veighna_studio\lib\site-packages\rqdatac\decorators.py", line 67, in wrap
return func(*args, kwargs)
File "C:\veighna_studio\lib\site-packages\rqdatac\connection_pool.py", line 27, in execute
return conn.execute(method, *args, **kwargs)
File "rqdatac\connection.py", line 117, in rqdatac.connection.Connection.execute
File "rqdatac\connection.py", line 87, in rqdatac.connection.Connection._read_one_packet
rqdatac.share.errors.QuotaExceeded: Quota exceeded
米筐登录设备超过三台或者试用账号当日下载数据超过50mb就会报这个错
把tick的数据导入到数据库里，还要在”行情记录“里再添加一下tick的记录才能使用数据吧？
