Hexo 博客
carl2016 / finance Goto Github PK
View Code? Open in Web Editor NEW这是一个python股票数据收集和分析系统,我们使用tushare开源接口,定时的是爬取数据保存到数据库中,然后我们拿数据库中的数据用来分析策略。 http://a.carlcc.com
这是一个python股票数据收集和分析系统,我们使用tushare开源接口,定时的是爬取数据保存到数据库中,然后我们拿数据库中的数据用来分析策略。 http://a.carlcc.com
Traceback (most recent call last):
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/flask/app.py", line 2314, in wsgi_app
response = self.handle_exception(e)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/flask/app.py", line 1760, in handle_exception
reraise(exc_type, exc_value, tb)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/flask/_compat.py", line 36, in reraise
raise value
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/flask/app.py", line 2311, in wsgi_app
response = self.full_dispatch_request()
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/flask/app.py", line 1834, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/flask/app.py", line 1737, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/flask/_compat.py", line 36, in reraise
raise value
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/flask/app.py", line 1832, in full_dispatch_request
rv = self.dispatch_request()
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/flask/app.py", line 1818, in dispatch_request
return self.view_functionsrule.endpoint
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/manager.py", line 144, in register
db.session.commit()
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/orm/scoping.py", line 162, in do
return getattr(self.registry(), name)(*args, **kwargs)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 1027, in commit
self.transaction.commit()
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 494, in commit
self._prepare_impl()
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 473, in _prepare_impl
self.session.flush()
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2459, in flush
self._flush(objects)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2597, in _flush
transaction.rollback(_capture_exception=True)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 68, in exit
compat.reraise(exc_type, exc_value, exc_tb)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 154, in reraise
raise value
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2557, in _flush
flush_context.execute()
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/orm/unitofwork.py", line 422, in execute
rec.execute(self)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/orm/unitofwork.py", line 589, in execute
uow,
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/orm/persistence.py", line 245, in save_obj
insert,
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/orm/persistence.py", line 1138, in _emit_insert_statements
statement, params
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 988, in execute
return meth(self, multiparams, params)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1107, in _execute_clauseelement
distilled_params,
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1248, in _execute_context
e, statement, parameters, cursor, context
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1466, in _handle_dbapi_exception
util.raise_from_cause(sqlalchemy_exception, exc_info)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 399, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 153, in reraise
raise value.with_traceback(tb)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1244, in _execute_context
cursor, statement, parameters, context
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 550, in do_execute
cursor.execute(statement, parameters)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/pymysql/cursors.py", line 170, in execute
result = self._query(query)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/pymysql/cursors.py", line 328, in _query
conn.query(q)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/pymysql/connections.py", line 517, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/pymysql/connections.py", line 732, in _read_query_result
result.read()
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/pymysql/connections.py", line 1075, in read
first_packet = self.connection._read_packet()
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/pymysql/connections.py", line 684, in _read_packet
packet.check_error()
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/pymysql/protocol.py", line 220, in check_error
err.raise_mysql_exception(self._data)
File "/Users/sss/devprog/flask/股票数据收集分析系统/finance-master/fmvenv/lib/python3.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'finance.sys_user' doesn't exist")
[SQL: INSERT INTO sys_user (username, password_hash, email, phone, avatar, status, createBy
, updateBy
) VALUES (%(username)s, %(password_hash)s, %(email)s, %(phone)s, %(avatar)s, %(status)s, %(createBy)s, %(updateBy)s)]
[parameters: {'username': 'aaa', 'password_hash': 'pbkdf2:sha256:50000$TpmCD9aK$aa6f334f3a6852921b0bd1fad12f0c3ffa3ab9386dc1c09039a94da882e7824e', 'email': None, 'phone': None, 'avatar': None, 'status': 1, 'createBy': None, 'updateBy': None}]
(Background on this error at: http://sqlalche.me/e/f405)
请问这里该怎么处理? 能给个提示么?谢谢
the structure of table sys_user is not the same with the code
and the code is not completed
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.