Comments (2)
执行examples\data_runner\finance_runner.py 碰到下面这错误貌似跟这个有关,请问怎么解决?
2022-01-09 13:54:08,861 INFO MainThread Adding job tentatively -- it will be properly scheduled when the scheduler starts
2022-01-09 13:54:08,861 INFO MainThread record data: Stock, entity_provider: None, data_provider: eastmoney
Stock registered recorders:{'joinquant': <class 'zvt.recorders.joinquant.meta.jq_stock_meta_recorder.JqChinaStockRecorder'>, 'exchange': <class 'zvt.recorders.exchange.exchange_stock_meta_recorder.ExchangeStockMetaRecorder'>, 'em': <class 'zvt.recorders.em.meta.em_stock_meta_recorder.EMStockRecorder'>, 'eastmoney': <class 'zvt.recorders.eastmoney.meta.eastmoney_stock_meta_recorder.EastmoneyStockRecorder'>}
2022-01-09 13:54:08,869 ERROR MainThread report error:(sqlite3.OperationalError) no such column: recoder_state.state_name
[SQL: SELECT recoder_state.id AS recoder_state_id, recoder_state.entity_id AS recoder_state_entity_id, recoder_state.timestamp AS recoder_state_timestamp, recoder_state.state_name AS recoder_state_state_name, recoder_state.state AS recoder_state_state
FROM recoder_state
WHERE recoder_state.id = ?]
[parameters: ('eastmoney_stock_recorder',)]
(Background on this error at: http://sqlalche.me/e/14/e3q8)
Traceback (most recent call last):
File "D:\MyDocument\myprogram\python\zvt\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1771, in _execute_context
cursor, statement, parameters, context
File "D:\MyDocument\myprogram\python\zvt\venv\lib\site-packages\sqlalchemy\engine\default.py", line 717, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: no such column: recoder_state.state_name
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "D:\MyDocument\myprogram\python\zvt\examples\recorder_utils.py", line 29, in run_data_recorder
entity_ids=entity_ids, provider=data_provider, sleeping_time=sleeping_time, **recorder_kv
File "D:\MyDocument\myprogram\python\zvt\venv\lib\site-packages\zvt\contract\schema.py", line 209, in record_data
r = recorder_class(**kw)
File "D:\MyDocument\myprogram\python\zvt\venv\lib\site-packages\zvt\contract\recorder.py", line 53, in init
super().init()
File "D:\MyDocument\myprogram\python\zvt\venv\lib\site-packages\zvt\contract\base.py", line 44, in init
self.state_domain = self.state_schema.get_one(id=self.name)
File "D:\MyDocument\myprogram\python\zvt\venv\lib\site-packages\zvt\contract\schema.py", line 83, in get_one
return get_one(data_schema=cls, id=id, provider=provider)
File "D:\MyDocument\myprogram\python\zvt\venv\lib\site-packages\zvt\contract\api.py", line 234, in get_one
return session.query(data_schema).get(id)
File "", line 2, in get
File "D:\MyDocument\myprogram\python\zvt\venv\lib\site-packages\sqlalchemy\util\deprecations.py", line 390, in warned
return fn(*args, **kwargs)
File "D:\MyDocument\myprogram\python\zvt\venv\lib\site-packages\sqlalchemy\orm\query.py", line 942, in get
return self._get_impl(ident, loading.load_on_pk_identity)
File "D:\MyDocument\myprogram\python\zvt\venv\lib\site-packages\sqlalchemy\orm\query.py", line 954, in _get_impl
execution_options=self._execution_options,
File "D:\MyDocument\myprogram\python\zvt\venv\lib\site-packages\sqlalchemy\orm\session.py", line 2843, in _get_impl
load_options=load_options,
File "D:\MyDocument\myprogram\python\zvt\venv\lib\site-packages\sqlalchemy\orm\loading.py", line 535, in load_on_pk_identity
bind_arguments=bind_arguments,
File "D:\MyDocument\myprogram\python\zvt\venv\lib\site-packages\sqlalchemy\orm\session.py", line 1689, in execute
result = conn._execute_20(statement, params or {}, execution_options)
File "D:\MyDocument\myprogram\python\zvt\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1582, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "D:\MyDocument\myprogram\python\zvt\venv\lib\site-packages\sqlalchemy\sql\elements.py", line 324, in _execute_on_connection
self, multiparams, params, execution_options
File "D:\MyDocument\myprogram\python\zvt\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1461, in _execute_clauseelement
cache_hit=cache_hit,
File "D:\MyDocument\myprogram\python\zvt\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1814, in execute_context
e, statement, parameters, cursor, context
File "D:\MyDocument\myprogram\python\zvt\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1995, in handle_dbapi_exception
sqlalchemy_exception, with_traceback=exc_info[2], from=e
File "D:\MyDocument\myprogram\python\zvt\venv\lib\site-packages\sqlalchemy\util\compat.py", line 207, in raise
raise exception
File "D:\MyDocument\myprogram\python\zvt\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1771, in _execute_context
cursor, statement, parameters, context
File "D:\MyDocument\myprogram\python\zvt\venv\lib\site-packages\sqlalchemy\engine\default.py", line 717, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: recoder_state.state_name
[SQL: SELECT recoder_state.id AS recoder_state_id, recoder_state.entity_id AS recoder_state_entity_id, recoder_state.timestamp AS recoder_state_timestamp, recoder_state.state_name AS recoder_state_state_name, recoder_state.state AS recoder_state_state
FROM recoder_state
WHERE recoder_state.id = ?]
[parameters: ('eastmoney_stock_recorder',)]
(Background on this error at: http://sqlalche.me/e/14/e3q8)
from zvt.
@awfssv
把$zvt-home/data目录里面的zvt_zvt_info.db删掉就好。
记录状态的结构(其实现在用不到)有些变化,我下个版本对目前的recorder去除掉这个依赖吧,省得已经在用的引起麻烦。
from zvt.
Related Issues (20)
- 更新到最新运行Stock1dKdata.record_data更新出错了 HOT 1
- 下载了历史数据替换后,更新数据报错 HOT 1
- ETF详细数据
- 所有的交易测试都会报一个数据为空的错误,examples和tests里的都是这样
- 东财的行情数据获取有bug HOT 1
- cannot start project
- 更新板块数据时会报错 HOT 4
- 可以更新几个trader的example吗 HOT 1
- NameError: name 'get_finance_factor' is not defined HOT 1
- 东财数据无法获取 HOT 4
- 请教一下如何自己更新数据? HOT 1
- ImportError: cannot import name 'get_current_traceback' from 'werkzeug.debug.tbtools' HOT 12
- 执行财务因子相关报错 HOT 1
- 有没有docker版本? HOT 1
- 请教 如何接入tushare的数据?
- QMT provider and Broker still can't work HOT 3
- ImportError: cannot import name 'html' from 'dash' HOT 1
- 哪位热心人士提供一份可以运行环境的PIP LIST? HOT 2
- MacBook Pro M3安装出错 HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from zvt.