请问vnpy3.94 sqlite回测数据源的字段格式，我想用本地数据Traceback (most recent call last):
File "C:\veighna_studio\lib\site-packages\peewee.py", line 3251, in execute_sql
cursor.execute(sql, params or ())
sqlite3.OperationalError: no such column: t1.turnover

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "C:\veighna_studio\lib\threading.py", line 1016, in _bootstrap_inner
self.run()
File "C:\veighna_studio\lib\threading.py", line 953, in run
self._target(self._args, **self._kwargs)
File "C:\veighna_studio\lib\site-packages\vnpy_ctabacktester\engine.py", line 188, in run_backtesting
engine.load_data()
File "C:\veighna_studio\lib\site-packages\vnpy_ctastrategy\backtesting.py", line 192, in load_data
data: List[BarData] = load_bar_data(
File "C:\veighna_studio\lib\site-packages\vnpy_ctastrategy\backtesting.py", line 1088, in load_bar_data
return database.load_bar_data(
File "C:\veighna_studio\lib\site-packages\vnpy_sqlite\sqlite_database.py", line 285, in load_bar_data
for db_bar in s:
File "C:\veighna_studio\lib\site-packages\peewee.py", line 7126, in iter
self.execute()
File "C:\veighna_studio\lib\site-packages\peewee.py", line 1971, in inner
return method(self, database, args, *kwargs)
File "C:\veighna_studio\lib\site-packages\peewee.py", line 2042, in execute
return self._execute(database)
File "C:\veighna_studio\lib\site-packages\peewee.py", line 2215, in _execute
cursor = database.execute(self)
File "C:\veighna_studio\lib\site-packages\peewee.py", line 3259, in execute
return self.execute_sql(sql, params)
File "C:\veighna_studio\lib\site-packages\peewee.py", line 3249, in execute_sql
with exception_wrapper:
File "C:\veighna_studio\lib\site-packages\peewee.py", line 3019, in exit
reraise(new_type, new_type(exc_value, exc_args), traceback)
File "C:\veighna_studio\lib\site-packages\peewee.py", line 192, in reraise
raise value.with_traceback(tb)
File "C:\veighna_studio\lib\site-packages\peewee.py", line 3251, in execute_sql
cursor.execute(sql, params or ())
peewee.OperationalError: no such column: t1.turnover

raceback (most recent call last):
File "C:\veighna_studio\lib\runpy.py", line 196, in _run_module_as_main
return _run_code(code, main_globals, None,
File "C:\veighna_studio\lib\runpy.py", line 86, in _run_code
exec(code, run_globals)
File "build\bdist.win-amd64\egg\veighna_station\trader.py", line 39, in <module>
File "build\bdist.win-amd64\egg\veighna_station\trader.py", line 30, in run_trader
File "C:\veighna_studio\lib\site-packages\vnpy\trader\engine.py", line 103, in add_app
engine: BaseEngine = self.add_engine(app.engine_class)
File "C:\veighna_studio\lib\site-packages\vnpy\trader\engine.py", line 74, in add_engine
engine: BaseEngine = engine_class(self, self.event_engine)
File "C:\veighna_studio\lib\site-packages\vnpy_ctastrategy\engine.py", line 97, in init
self.database: BaseDatabase = get_database()
File "C:\veighna_studio\lib\site-packages\vnpy\trader\database.py", line 159, in get_database
2025-03-20 18:26:48 database = module.Database()
File "C:\veighna_studio\lib\site-packages\vnpy_sqlite\sqlite_database.py", line 150, in init
self.db.create_tables([DbBarData, DbTickData, DbBarOverview, DbTickOverview])
File "C:\veighna_studio\lib\site-packages\peewee.py", line 3440, in create_tables
model.create_table(options)
File "C:\veighna_studio\lib\site-packages\peewee.py", line 6924, in create_table
2025-03-20 18:26:48 cls._schema.create_all(safe, options)
File "C:\veighna_studio\lib\site-packages\peewee.py", line 6027, in create_all
self.create_indexes(safe=safe)
File "C:\veighna_studio\lib\site-packages\peewee.py", line 5941, in create_indexes
self.database.execute(query)
File "C:\veighna_studio\lib\site-packages\peewee.py", line 3259, in execute
return self.execute_sql(sql, params)
File "C:\veighna_studio\lib\site-packages\peewee.py", line 3249, in execute_sql
with exception_wrapper:
File "C:\veighna_studio\lib\site-packages\peewee.py", line 3019, in exit
reraise(new_type, new_type(exc_value, *exc_args), traceback)
File "C:\veighna_studio\lib\site-packages\peewee.py", line 192, in reraise
raise value.with_traceback(tb)
File "C:\veighna_studio\lib\site-packages\peewee.py", line 3251, in execute_sql
cursor.execute(sql, params or ())
peewee.IntegrityError: UNIQUE constraint failed: dbbardata.symbol, dbbardata.exchange, dbbardata.interval, dbbardata.datetime

糖鱼 wrote:

请问vnpy3.94 sqlite回测数据源的字段格式，我想用本地数据Traceback (most recent call last):
File "C:\veighna_studio\lib\site-packages\peewee.py", line 3251, in execute_sql
cursor.execute(sql, params or ())
sqlite3.OperationalError: no such column: t1.turnover

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "C:\veighna_studio\lib\threading.py", line 1016, in _bootstrap_inner
self.run()
File "C:\veighna_studio\lib\threading.py", line 953, in run
self._target(self._args, **self._kwargs)
File "C:\veighna_studio\lib\site-packages\vnpy_ctabacktester\engine.py", line 188, in run_backtesting
engine.load_data()
File "C:\veighna_studio\lib\site-packages\vnpy_ctastrategy\backtesting.py", line 192, in load_data
data: List[BarData] = load_bar_data(
File "C:\veighna_studio\lib\site-packages\vnpy_ctastrategy\backtesting.py", line 1088, in load_bar_data
return database.load_bar_data(
File "C:\veighna_studio\lib\site-packages\vnpy_sqlite\sqlite_database.py", line 285, in load_bar_data
for db_bar in s:
File "C:\veighna_studio\lib\site-packages\peewee.py", line 7126, in iter
self.execute()
File "C:\veighna_studio\lib\site-packages\peewee.py", line 1971, in inner
return method(self, database, args, *kwargs)
File "C:\veighna_studio\lib\site-packages\peewee.py", line 2042, in execute
return self._execute(database)
File "C:\veighna_studio\lib\site-packages\peewee.py", line 2215, in _execute
cursor = database.execute(self)
File "C:\veighna_studio\lib\site-packages\peewee.py", line 3259, in execute
return self.execute_sql(sql, params)
File "C:\veighna_studio\lib\site-packages\peewee.py", line 3249, in execute_sql
with exception_wrapper:
File "C:\veighna_studio\lib\site-packages\peewee.py", line 3019, in exit
reraise(new_type, new_type(exc_value, exc_args), traceback)
File "C:\veighna_studio\lib\site-packages\peewee.py", line 192, in reraise
raise value.with_traceback(tb)
File "C:\veighna_studio\lib\site-packages\peewee.py", line 3251, in execute_sql
cursor.execute(sql, params or ())
peewee.OperationalError: no such column: t1.turnover
2.5版本对数据库字段进行了更新，删除用户名下.vntrader下的database.db就可以了，如果有需要可以把数据库数据先导出来