pythonstock / stock Goto Github PK

View Code? Open in Web Editor NEW

6.5K 6.5K 2.2K 16.18 MB

stock，股票系统。使用python进行开发。

License: Apache License 2.0

Shell 3.25% Python 79.76% CSS 0.22% HTML 13.24% JavaScript 0.91% Dockerfile 2.63%

stock's People

Contributors

Stargazers

Watchers

Forkers

zhy0313 busizshen tianhm liuyanzhi zhengxj91 doitlite shigubuhua awfssv suym y185130162 sxk000 alvin3721 ruzwdy gxbjtu ljzwaterbull ck032 luojing0322 ygrgd weihoutian stevensia cn-chengjiangang solosuns williamjie kayz tsinghuazhang yoshi315 tiandiheyi zhangjd0411 world547 yuyan235813 jinghe0 feng-static jester94 sansom jianzhang1982p kesio muzipeng718 zhangyunfang fakegit genliu777 flysharkwang bbbeeennnppp liyuqi7969 xuezhizeng yinhualy yuknight skyprit zhouqisz zhangliangdian jackonliu daiedaie tyronetown gzmychen sshling donadonny sinosoid shenjihehe luoting123321 tanglemontree seaioheroes coryvegan evido3s ugo5 ucdoswsk mesosxzan chaosmm guoda31 lijielife qingliudao squarelawrence sondaa huangpichao ash010 beautifulnow1992 jiangming1 fellowfun kmmao juishuyeh kknet guanliqun sanyuli machao326 rogerstao lindsaypeng liuchenbaidu hebpmo lijk001 joqson github4n yongfuyang lukehuang hongleis tmacdwh1986 ma-lijun foxbupt xukc yzswk ggtony jiangbiaodeng cqs5697

stock's Issues

使用docker安装,一切正常,未提示错误,但是缺没有苏剧
尝试手动执行jobs下得run_init.sh,无法启动,
提示MySQLdb._exceptions.OperationalError: (2003, 'Can't connect to MySQL server on
'127.0.0.1' (111 "Connection refused")')
nohup: appending output to 'nohup.out'
cron: can't lock /var/run/crond.pid, otherpid may be 29: Resource temporarily un
available

在windows的cygwin运行出错

有自定义添加功能吗？

比如添加标的，如ETF指数
或者添加图表，比如PE、PEG指标等

龙虎榜数据有跨域问题

此外，每日数据和每日数据猜想里面都没有数据，但是控制台不报错

希望指定日期区间补历史数据

初始化提示表不存在

datetime_str: 2020-08-28
datetime_int: 20200828
insert sql: DELETE FROM stock_data.guess_indicators_lite_sell_daily WHERE date= '20200828'
error : (1146, "Table 'stock_data.guess_indicators_lite_sell_daily' doesn't exist")
error : (MySQLdb._exceptions.ProgrammingError) (1146, "Table 'stock_data.guess_indicators_daily' doesn't exist")
[SQL:
SELECT date, code, name, changepercent, trade, open, high, low,
settlement, volume, turnoverratio, amount, per, pb, mktcap,
nmc ,kdjj,rsi_6,cci
FROM stock_data.guess_indicators_daily WHERE date = %s
and kdjk <= 20 and kdjd <= 30 and kdjj <= 10 and rsi_6 <= 20 and cci <= -100

其他选股方式

有没有根据各种指标或者基本面数据进行选股的方式呢

是不是可以考虑用tushare.pro来做数据源?

tushare.org的数据准确度有点问题的样子

执行 guess_indicators_lite_sell_daily_job 报错了。

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/data/stock/libs/common.py", line 160, in run_with_args
run_fun(tmp_datetime_show) # 使用当前时间
File "/data/stock/jobs/guess_indicators_lite_buy_daily_job.py", line 50, in stat_all_lite
del stock_merge["date"] # 合并前删除 date 字段。
File "/usr/local/lib/python3.6/site-packages/pandas/core/generic.py", line 3759, in delitem
self._data.delete(key)
File "/usr/local/lib/python3.6/site-packages/pandas/core/internals/managers.py", line 1591, in delete
loc = self.items.get_loc(item)
File "/usr/local/lib/python3.6/site-packages/pandas/core/indexes/base.py", line 2648, in get_loc
return self._engine.get_loc(self._maybe_cast_indexer(key))
File "pandas/_libs/index.pyx", line 111, in pandas._libs.index.IndexEngine.get_loc
File "pandas/_libs/index.pyx", line 135, in pandas._libs.index.IndexEngine.get_loc
File "pandas/_libs/index_class_helper.pxi", line 109, in pandas._libs.index.Int64Engine._check_type
KeyError: 'date'
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1278, in _execute_context
cursor, statement, parameters, context
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 206, in execute
res = self._query(query)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 319, in _query
db.query(q)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 259, in query
_mysql.connection.query(self, query)
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'stock_data.guess_indicators_lite_buy_daily' doesn't exist")

The above exception was the direct cause of the following exception:

MySQL好像不支持修改端口号吧

看代码里面MySQL不能修改端口号；只能默认3306？

Python

Python `````

my. Ltcbot.com/+2348129136349

树莓派 docker 部署后无法启动

日志内容

exec user process caused exec format error

系统

raspbian 10 (buster)

Mac的终端下出错

博主您好，首先谢谢您的分享！
我按照您的博客运行了代码，结果提示如下：
依赖镜像mariadb可以下载，并启动成功了；
但是tensorflow-stock镜像不能下载，报的是没有找到这样的文件，您没有共享这个文件吗？还是什么原因呢？如果不方便共享的话请告知一下，我就不在继续折腾了（已经折腾大半个月了，查了各种问题又尝试了各种方法，再次谢谢您的分享！）

终端运行报错结果如下：

******deMacBook-Pro:docker ******$ sh startStock.sh
docker: Error response from daemon: Conflict. The container name "/mariadb" is already in use by container "51f32a994b41c7b7febfd5194447105ad1771de9d51c4d81cf28a9673a5403d2". You have to remove (or rename) that container to be able to reuse that name.
See 'docker run --help'.
starting mariadb ...
wait 10 second , and create stock database .
mariadb is not running !!!
starting stock ...
Unable to find image 'github.com/pythonstock/stock/tensorflow-py3-stock:latest' locally
docker: Error response from daemon: error parsing HTTP 404 response body: invalid character 'N' looking for beginning of value: "Not Found".
See 'docker run --help'.
******deMacBook-Pro:docker ******$

maria docker的端口和本地mysql冲突了

docker这个端口能否修改呢？

请问有没有完整的数据库脚本呀

Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/tornado/web.py", line 1697, in _execute
result = method(*self.path_args, **self.path_kwargs)
File "/data/stock/web/dataTableHandler.py", line 136, in get
stock_web_list = self.db.query(sql)
File "/usr/local/lib/python3.6/site-packages/torndb.py", line 136, in query
self._execute(cursor, query, parameters, kwparameters)
File "/usr/local/lib/python3.6/site-packages/torndb.py", line 234, in _execute
return cursor.execute(query, kwparameters or parameters)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 209, in execute
res = self._query(query)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 315, in _query
db.query(q)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 226, in query
_mysql.connection.query(self, query)
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'stock_data.ts_stock_basics' doesn't exist")

mac端 docker 数据库无法链接

Aborted connection 28 to db: 'stock_data' user: 'root' host: '172.17.0.3' (Got timeout reading communication packets)

一直报
[Warning] Aborted connection 75 to db: 'unconnected' user: 'unauthenticated' host: '172.17.0.1' (This connection closed normally without authentication)

有没有非docker部署方式啊

个人笔记本电脑，windows平台，用docker不是很方便，能否提供一下普通的python应用部署方式指导，提供一下数据库之类的配置文件，谢谢了

stock，股票系统。使用python进行开发。

请问 stock_data.ts_today_all 这张表的结构是什么呢

离线安装的时候报错

环境：
Windows 10
Python 3.7.9

安装方式：
Github下载离线安装包，python setup.py install 命令安装

报错如下:

解决办法：
删除 setup.py 第一行的：

# coding:utf8

Docker安装启动失败

安装步骤

docker命令

docker run -itd --name stock  \
	--network only \
	--restart always \
    -v /data/notebooks:/data/notebooks \
    -p 8808:8888 \
    -p 9909:9999 \
    -e MYSQL_HOST=mysql \
    -e MYSQL_USER=root \
    -e MYSQL_PWD=123456 \
    -e MYSQL_DB=stock_data \
    pythonstock/pythonstock:latest

进入容器初始化

docker exec -it stock bash 
sh /data/stock/jobs/cron.daily/run_daily

初始化后的数据表：

WEB运行正常，接口请求报错

数据严重不准

代码我没有跑，我是按照博客上的方法运行的Python，执行出来的数据跟看盘软件的数据严重不匹配。不可信

如何python程序直接架设在服务器

在本地的docker以架设成功但放在本地总归不方便
在服务器的docker也架设成功但占用了端口
如何直接在服务器上架设

执行run_daily脚本报错

root@c1ee33d1bbbb:/data# sh /data/stock/jobs/cron.daily/run_daily
Traceback (most recent call last):
File "/data/stock/libs/common.py", line 160, in run_with_args
run_fun(tmp_datetime_show) # 使用当前时间
File "/data/stock/jobs/daily_job.py", line 30, in stat_all
data = ts.top_list(datetime_str)
File "/usr/local/lib/python3.6/site-packages/tushare/stock/billboard.py", line 64, in top_list
if(du.is_holiday(date)):
File "/usr/local/lib/python3.6/site-packages/tushare/util/dateu.py", line 91, in is_holiday
df = trade_cal()
File "/usr/local/lib/python3.6/site-packages/tushare/util/dateu.py", line 83, in trade_cal
df = pd.read_csv(ct.ALL_CAL_FILE)
File "/usr/local/lib/python3.6/site-packages/pandas/io/parsers.py", line 676, in parser_f
return _read(filepath_or_buffer, kwds)
File "/usr/local/lib/python3.6/site-packages/pandas/io/parsers.py", line 431, in _read
filepath_or_buffer, encoding, compression
File "/usr/local/lib/python3.6/site-packages/pandas/io/common.py", line 172, in get_filepath_or_buffer
req = urlopen(filepath_or_buffer)
File "/usr/local/lib/python3.6/site-packages/pandas/io/common.py", line 141, in urlopen
return urllib.request.urlopen(*args, **kwargs)
File "/usr/local/lib/python3.6/urllib/request.py", line 223, in urlopen
return opener.open(url, data, timeout)
File "/usr/local/lib/python3.6/urllib/request.py", line 532, in open
response = meth(req, response)
File "/usr/local/lib/python3.6/urllib/request.py", line 642, in http_response
'http', request, response, code, msg, hdrs)
File "/usr/local/lib/python3.6/urllib/request.py", line 564, in error
result = self._call_chain(*args)
File "/usr/local/lib/python3.6/urllib/request.py", line 504, in _call_chain
result = func(*args)
File "/usr/local/lib/python3.6/urllib/request.py", line 756, in http_error_302
return self.parent.open(new, timeout=req.timeout)
File "/usr/local/lib/python3.6/urllib/request.py", line 532, in open
response = meth(req, response)
File "/usr/local/lib/python3.6/urllib/request.py", line 642, in http_response
'http', request, response, code, msg, hdrs)
File "/usr/local/lib/python3.6/urllib/request.py", line 570, in error
return self._call_chain(*args)
File "/usr/local/lib/python3.6/urllib/request.py", line 504, in _call_chain
result = func(*args)
File "/usr/local/lib/python3.6/urllib/request.py", line 650, in http_error_default
raise HTTPError(req.full_url, code, msg, hdrs, fp)
urllib.error.HTTPError: HTTP Error 404: Not Found

能否做成arm版本的docker

能否做成arm版本的docker，用N1盒子想装。

添加自选股票做成一个type

Good work.

我想添加任意若干自选股票做成一个type，但是没有头绪，求助。

虚拟机重启后，docker容器丢失

虚拟机重启后，docker ps -a 为空，容器都不见了怎么办

手机浏览器打开后看不到左侧的菜单栏

手机浏览器打开后看不到左侧的菜单栏，这个是什么问题，我在调试状态下看，页面数据已经有了，但是显示是空的。我试了chrome和edge

用这个和用东方财富网的app，有什么差别吗 😂

stock，股票系统。使用python进行开发。

安装后输入localhost:8888进入Jupyter后token是啥呀

作者你好，我在docker部署之后点击买入猜想有个小Bug 找不到表

在左侧菜单点击 每日股票指标买入猜想 的时候会报如下错误找不到表

Traceback (most recent call last): File "/usr/local/lib/python3.6/site-packages/tornado/web.py", line 1701, in _execute result = method(*self.path_args, **self.path_kwargs) File "/data/stock/web/dataTableHandler.py", line 136, in get stock_web_list = self.db.query(sql) File "/usr/local/lib/python3.6/site-packages/torndb.py", line 136, in query self._execute(cursor, query, parameters, kwparameters) File "/usr/local/lib/python3.6/site-packages/torndb.py", line 234, in _execute return cursor.execute(query, kwparameters or parameters) File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 206, in execute res = self._query(query) File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 319, in _query db.query(q) File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 259, in query _mysql.connection.query(self, query) MySQLdb._exceptions.ProgrammingError: (1146, "Table 'stock_data.guess_indicators_lite_buy_daily' doesn't exist")

连接数据库报错

178, in raise_
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 656, in __connect
connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 493, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/init.py", line 130, in Connect
return Connection(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 185, in init
super().init(*args, **kwargs2)
sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (2003, 'Can't connect to MySQL server on '127.0.0.1' (111 "Connection refused")')
(Background on this error at: http://sqlalche.me/e/13/e3q8)
rm -f /data/cache/hist_data_cache/2020-07/

background的网站打不开百度查阅是连接数据库失败但是我在容器里连接的应该也是容器内部的db吧? 求解

指标页空白，日志报错(AttributeError("'NoneType' object has no attribute 'head'

[I 200802 16:17:37 dataIndicatorsHandler:27] 000001
[I 200802 16:17:37 dataIndicatorsHandler:27] 000001
[I 200802 16:17:37 dataIndicatorsHandler:51] Bad message (TypeError('not all arguments converted during string formatting',)): {'name': 'root', 'msg': 'error :', 'args': (AttributeError("'NoneType' object has no attribute 'head'",),), 'levelname': 'INFO', 'levelno': 20, 'pathname': '/data/stock/web/dataIndicatorsHandler.py', 'filename': 'dataIndicatorsHandler.py', 'module': 'dataIndicatorsHandler', 'exc_info': None, 'exc_text': None, 'stack_info': None, 'lineno': 51, 'funcName': 'get', 'created': 1596356257.799734, 'msecs': 799.7341156005859, 'relativeCreated': 2559465.4767513275, 'thread': 140460272067584, 'threadName': 'MainThread', 'processName': 'MainProcess', 'process': 13, 'message': 'Bad message (TypeError('not all arguments converted during string formatting',)): {'name': 'root', 'msg': 'error :', 'args': (AttributeError("'NoneType' object has no attribute 'head'",),), 'levelname': 'INFO', 'levelno': 20, 'pathname': '/data/stock/web/dataIndicatorsHandler.py', 'filename': 'dataIndicatorsHandler.py', 'module': 'dataIndicatorsHandler', 'exc_info': None, 'exc_text': None, 'stack_info': None, 'lineno': 51, 'funcName': 'get', 'created': 1596356257.799734, 'msecs': 799.7341156005859, 'relativeCreated': 2559465.4767513275, 'thread': 140460272067584, 'threadName': 'MainThread', 'processName': 'MainProcess', 'process': 13}', 'asctime': '200802 16:17:37', 'color': '', 'end_color': ''}
[I 200802 16:17:37 dataIndicatorsHandler:51] Bad message (TypeError('not all arguments converted during string formatting',)): {'name': 'root', 'msg': 'error :', 'args': (AttributeError("'NoneType' object has no attribute 'head'",),), 'levelname': 'INFO', 'levelno': 20, 'pathname': '/data/stock/web/dataIndicatorsHandler.py', 'filename': 'dataIndicatorsHandler.py', 'module': 'dataIndicatorsHandler', 'exc_info': None, 'exc_text': None, 'stack_info': None, 'lineno': 51, 'funcName': 'get', 'created': 1596356257.799734, 'msecs': 799.7341156005859, 'relativeCreated': 2559465.4767513275, 'thread': 140460272067584, 'threadName': 'MainThread', 'processName': 'MainProcess', 'process': 13, 'message': 'Bad message (TypeError('not all arguments converted during string formatting',)): {'name': 'root', 'msg': 'error :', 'args': (AttributeError("'NoneType' object has no attribute 'head'",),), 'levelname': 'INFO', 'levelno': 20, 'pathname': '/data/stock/web/dataIndicatorsHandler.py', 'filename': 'dataIndicatorsHandler.py', 'module': 'dataIndicatorsHandler', 'exc_info': None, 'exc_text': None, 'stack_info': None, 'lineno': 51, 'funcName': 'get', 'created': 1596356257.799734, 'msecs': 799.7341156005859, 'relativeCreated': 2559465.4767513275, 'thread': 140460272067584, 'threadName': 'MainThread', 'processName': 'MainProcess', 'process': 13, 'message': 'Bad message (TypeError(\'not all arguments converted during string formatting\',)): {\'name\': \'root\', \'msg\': \'error :\', \'args\': (AttributeError("\'NoneType\' object has no attribute \'head\'",),), \'levelname\': \'INFO\', \'levelno\': 20, \'pathname\': \'/data/stock/web/dataIndicatorsHandler.py\', \'filename\': \'dataIndicatorsHandler.py\', \'module\': \'dataIndicatorsHandler\', \'exc_info\': None, \'exc_text\': None, \'stack_info\': None, \'lineno\': 51, \'funcName\': \'get\', \'created\': 1596356257.799734, \'msecs\': 799.7341156005859, \'relativeCreated\': 2559465.4767513275, \'thread\': 140460272067584, \'threadName\': \'MainThread\', \'processName\': \'MainProcess\', \'process\': 13, \'message\': \'Bad message (TypeError(\\\'not all arguments converted during string formatting\\\',)): {\\\'name\\\': \\\'root\\\', \\\'msg\\\': \\\'error :\\\', \\\'args\\\': (AttributeError("\\\'NoneType\\\' object has no attribute \\\'head\\\'",),), \\\'levelname\\\': \\\'INFO\\\', \\\'levelno\\\': 20, \\\'pathname\\\': \\\'/data/stock/web/dataIndicatorsHandler.py\\\', \\\'filename\\\': \\\'dataIndicatorsHandler.py\\\', \\\'module\\\': \\\'dataIndicatorsHandler\\\', \\\'exc_info\\\': None, \\\'exc_text\\\': None, \\\'stack_info\\\': None, \\\'lineno\\\': 51, \\\'funcName\\\': \\\'get\\\', \\\'created\\\': 1596356257.799734, \\\'msecs\\\': 799.7341156005859, \\\'relativeCreated\\\': 2559465.4767513275, \\\'thread\\\': 140460272067584, \\\'threadName\\\': \\\'MainThread\\\', \\\'processName\\\': \\\'MainProcess\\\', \\\'process\\\': 13}\', \'asctime\': \'200802 16:17:37\', \'color\': \'\', \'end_color\': \'\'}', 'asctime': '200802 16:17:37', 'color': '', 'end_color': ''}', 'asctime': '200802 16:17:37', 'color': '', 'end_color': ''}
[I 200802 16:17:37 dataIndicatorsHandler:52] #################### GetStockHtmlHandlerEnd ####################
[I 200802 16:17:37 dataIndicatorsHandler:52] #################### GetStockHtmlHandlerEnd ####################

龙虎榜没有数据，如何让ts_top_list在数据库里面生成，我下载的是作者在dockerhub上面的镜像

@golangpkg 请问龙虎榜没有数据的问题是如何解决的呢？
我这边发现数据库里面并没有ts_top_list这张表。

我是下载作者的docker镜像直接去运行的，我把镜像删除了，重新跑了一遍，还是没有ts_top_list这张表生成

执行run_daily报错

执行
sh /data/stock/jobs/cron.daily/run_daily
报错信息如下：
NOTE: Behavior of MACDH calculation has changed as of July 2017 - it is now 1/2 of previous calculated values
NOTE: Behavior of MACDH calculation has changed as of July 2017 - it is now 1/2 of previous calculated values
NOTE: Behavior of MACDH calculation has changed as of July 2017 - it is now 1/2 of previous calculated values
NOTE: Behavior of MACDH calculation has changed as of July 2017 - it is now 1/2 of previous calculated values
NOTE: Behavior of MACDH calculation has changed as of July 2017 - it is now 1/2 of previous calculated values
NOTE: Behavior of MACDH calculation has changed as of July 2017 - it is now 1/2 of previous calculated values
Traceback (most recent call last):
File "/data/stock/libs/common.py", line 160, in run_with_args
run_fun(tmp_datetime_show) # 使用当前时间
File "/data/stock/jobs/guess_indicators_daily_job.py", line 124, in stat_all_batch
stat_index_all(data, i)
File "/data/stock/jobs/guess_indicators_daily_job.py", line 218, in stat_index_all
data_new = concat_guess_data(stock_column, data)
File "/data/stock/jobs/guess_indicators_daily_job.py", line 248, in concat_guess_data
stock_guess = stock_guess.apply(apply_guess, stock_column=stock_column, axis=1) # , axis=1)
File "/usr/local/lib/python3.6/site-packages/pandas/core/frame.py", line 6878, in apply
return op.get_result()
File "/usr/local/lib/python3.6/site-packages/pandas/core/apply.py", line 186, in get_result
return self.apply_standard()
File "/usr/local/lib/python3.6/site-packages/pandas/core/apply.py", line 296, in apply_standard
values, self.f, axis=self.axis, dummy=dummy, labels=labels
File "pandas/_libs/reduction.pyx", line 620, in pandas._libs.reduction.compute_reduction
File "pandas/_libs/reduction.pyx", line 128, in pandas._libs.reduction.Reducer.get_result
File "/usr/local/lib/python3.6/site-packages/pandas/core/apply.py", line 113, in f
return func(x, *args, **kwds)
File "/data/stock/jobs/guess_indicators_daily_job.py", line 270, in apply_guess
stock = common.get_hist_data_cache(code, date_start, date_end)
File "/data/stock/libs/common.py", line 186, in get_hist_data_cache
return pd.read_pickle(cache_file, compression="gzip")
File "/usr/local/lib/python3.6/site-packages/pandas/io/pickle.py", line 182, in read_pickle
return pickle.load(f)
EOFError: Ran out of input
rm -f /data/cache/hist_data_cache/2020-06/

安装以后打开页面，数据为空，请问什么问题

库里面没有Dockerfile

我看你最新提交加了
“本地构建
其中构建文件参考 Dockerfile ”

但是库里面并没有Dockerfile文件啊

还缺少一些其他的python文件，比如stockstats

还有数据库创建之后，数据表好像没有自动创建

能不能提交完整的程序，想自己在本地跑起来，谢谢

建议增加每日自动打新功能

run_daily报错http error 456

/data/stock/jobs/cron.daily/run_daily

Traceback (most recent call last):
File "/data/stock/libs/common.py", line 160, in run_with_args
run_fun(tmp_datetime_show) # 使用当前时间
File "/data/stock/jobs/18h_daily_job.py", line 49, in stat_today_all
data = ts.get_today_all()
File "/usr/local/lib/python3.6/site-packages/tushare/stock/trading.py", line 327, in get_today_all
newdf = _parsing_dayprice_json('hs_a', i)
File "/usr/local/lib/python3.6/site-packages/tushare/stock/trading.py", line 120, in _parsing_dayprice_json
text = urlopen(request, timeout=10).read()
File "/usr/local/lib/python3.6/urllib/request.py", line 223, in urlopen
return opener.open(url, data, timeout)
File "/usr/local/lib/python3.6/urllib/request.py", line 532, in open
response = meth(req, response)
File "/usr/local/lib/python3.6/urllib/request.py", line 642, in http_response
'http', request, response, code, msg, hdrs)
File "/usr/local/lib/python3.6/urllib/request.py", line 570, in error
return self._call_chain(*args)
File "/usr/local/lib/python3.6/urllib/request.py", line 504, in _call_chain
result = func(*args)
File "/usr/local/lib/python3.6/urllib/request.py", line 650, in http_error_default
raise HTTPError(req.full_url, code, msg, hdrs, fp)
urllib.error.HTTPError: HTTP Error 456:

卖出/买入猜想

卖出/买入猜想列表的股票是超卖/超买，不是应该超卖的是买入猜想吗？

为什么只有股价20以下的股票

建议把tensorflow等用标准镜像隔离

类似于mariadb镜像单独挂载
便于挂载不同版本TF，包括GPU版本等，也可以自由选用PyTorch等
可以使用volume卷实现存储的共享

我建了一个交流群，大家可以进来讨论一下

扣扣群
3741976，针对项目，股票，大家可以交流一下。

小白请教执行sh /data/stock/jobs/cron.daily/run_daily

Traceback (most recent call last):
File "/usr/local/lib/python3.6/urllib/request.py", line 1349, in do_open
encode_chunked=req.has_header('Transfer-encoding'))
File "/usr/local/lib/python3.6/http/client.py", line 1272, in request
self._send_request(method, url, body, headers, encode_chunked)
File "/usr/local/lib/python3.6/http/client.py", line 1318, in _send_request
self.endheaders(body, encode_chunked=encode_chunked)
File "/usr/local/lib/python3.6/http/client.py", line 1267, in endheaders
self._send_output(message_body, encode_chunked=encode_chunked)
File "/usr/local/lib/python3.6/http/client.py", line 1038, in _send_output
self.send(msg)
File "/usr/local/lib/python3.6/http/client.py", line 976, in send
self.connect()
File "/usr/local/lib/python3.6/http/client.py", line 948, in connect
(self.host,self.port), self.timeout, self.source_address)
File "/usr/local/lib/python3.6/socket.py", line 704, in create_connection
for res in getaddrinfo(host, port, 0, SOCK_STREAM):
File "/usr/local/lib/python3.6/socket.py", line 745, in getaddrinfo
for res in _socket.getaddrinfo(host, port, family, type, proto, flags):
socket.gaierror: [Errno -3] Temporary failure in name resolution

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/data/stock/libs/common.py", line 160, in run_with_args
run_fun(tmp_datetime_show) # 使用当前时间
File "/data/stock/jobs/daily_job.py", line 30, in stat_all
data = ts.top_list(datetime_str)
File "/usr/local/lib/python3.6/site-packages/tushare/stock/billboard.py", line 64, in top_list
if(du.is_holiday(date)):
File "/usr/local/lib/python3.6/site-packages/tushare/util/dateu.py", line 91, in is_holiday
df = trade_cal()
File "/usr/local/lib/python3.6/site-packages/tushare/util/dateu.py", line 83, in trade_cal
df = pd.read_csv(ct.ALL_CAL_FILE)
File "/usr/local/lib/python3.6/site-packages/pandas/io/parsers.py", line 676, in parser_f
return _read(filepath_or_buffer, kwds)
File "/usr/local/lib/python3.6/site-packages/pandas/io/parsers.py", line 431, in _read
filepath_or_buffer, encoding, compression
File "/usr/local/lib/python3.6/site-packages/pandas/io/common.py", line 172, in get_filepath_or_buffer
req = urlopen(filepath_or_buffer)
File "/usr/local/lib/python3.6/site-packages/pandas/io/common.py", line 141, in urlopen
return urllib.request.urlopen(*args, **kwargs)
File "/usr/local/lib/python3.6/urllib/request.py", line 223, in urlopen
return opener.open(url, data, timeout)
File "/usr/local/lib/python3.6/urllib/request.py", line 526, in open
response = self._open(req, data)
File "/usr/local/lib/python3.6/urllib/request.py", line 544, in _open
'_open', req)
File "/usr/local/lib/python3.6/urllib/request.py", line 504, in _call_chain
result = func(*args)
File "/usr/local/lib/python3.6/urllib/request.py", line 1377, in http_open
return self.do_open(http.client.HTTPConnection, req)
File "/usr/local/lib/python3.6/urllib/request.py", line 1351, in do_open
raise URLError(err)
urllib.error.URLError: <urlopen error [Errno -3] Temporary failure in name resolution>
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2339, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 304, in unique_connection
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
rec = pool._do_get()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 140, in _do_get
self.dec_overflow()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 137, in _do_get
return self._create_connection()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 309, in _create_connection
return _ConnectionRecord(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 440, in init
self.__connect(first_connect_check=True)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 661, in _connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 656, in __connect
connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 493, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/init.py", line 130, in Connect
return Connection(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 185, in init
super().init(*args, **kwargs2)
MySQLdb._exceptions.OperationalError: (2003, 'Can't connect to MySQL server on '127.0.0.1' (111 "Connection refused")')

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/data/stock/libs/common.py", line 160, in run_with_args
run_fun(tmp_datetime_show) # 使用当前时间
File "/data/stock/jobs/18h_daily_job.py", line 38, in stat_index_all
common.insert_db(data, "ts_index_all", False, "date,code")
File "/data/stock/libs/common.py", line 59, in insert_db
insert_other_db(MYSQL_DB, data, table_name, write_index, primary_keys)
File "/data/stock/libs/common.py", line 68, in insert_other_db
insp = inspect(engine_mysql)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/inspection.py", line 64, in inspect
ret = reg(subject)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/reflection.py", line 139, in _insp
return Inspector.from_engine(bind)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/reflection.py", line 135, in from_engine
return Inspector(bind)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/reflection.py", line 108, in init
bind.connect().close()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2266, in connect
return self._connection_cls(self, **kwargs)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 104, in init
else engine.raw_connection()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2373, in raw_connection
self.pool.unique_connection, _connection
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2343, in wrap_pool_connect
e, dialect, self
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1585, in handle_dbapi_exception_noconnection
sqlalchemy_exception, with_traceback=exc_info[2], from=e
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2339, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 304, in unique_connection
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
rec = pool._do_get()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 140, in _do_get
self.dec_overflow()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 137, in _do_get
return self._create_connection()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 309, in _create_connection
return _ConnectionRecord(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 440, in init
self.__connect(first_connect_check=True)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 661, in _connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 656, in __connect
connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 493, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/init.py", line 130, in Connect
return Connection(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 185, in init
super().init(*args, **kwargs2)
sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (2003, 'Can't connect to MySQL server on '127.0.0.1' (111 "Connection refused")')
(Background on this error at: http://sqlalche.me/e/13/e3q8)
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2339, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 304, in unique_connection
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
rec = pool._do_get()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 140, in _do_get
self.dec_overflow()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 137, in _do_get
return self._create_connection()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 309, in _create_connection
return _ConnectionRecord(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 440, in init
self.__connect(first_connect_check=True)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 661, in _connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 656, in __connect
connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 493, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/init.py", line 130, in Connect
return Connection(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 185, in init
super().init(*args, **kwargs2)
MySQLdb._exceptions.OperationalError: (2003, 'Can't connect to MySQL server on '127.0.0.1' (111 "Connection refused")')

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/data/stock/libs/common.py", line 160, in run_with_args
run_fun(tmp_datetime_show) # 使用当前时间
File "/data/stock/jobs/18h_daily_job.py", line 57, in stat_today_all
common.insert_db(data, "ts_today_all", False, "date,code")
File "/data/stock/libs/common.py", line 59, in insert_db
insert_other_db(MYSQL_DB, data, table_name, write_index, primary_keys)
File "/data/stock/libs/common.py", line 68, in insert_other_db
insp = inspect(engine_mysql)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/inspection.py", line 64, in inspect
ret = reg(subject)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/reflection.py", line 139, in _insp
return Inspector.from_engine(bind)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/reflection.py", line 135, in from_engine
return Inspector(bind)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/reflection.py", line 108, in init
bind.connect().close()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2266, in connect
return self._connection_cls(self, **kwargs)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 104, in init
else engine.raw_connection()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2373, in raw_connection
self.pool.unique_connection, _connection
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2343, in wrap_pool_connect
e, dialect, self
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1585, in handle_dbapi_exception_noconnection
sqlalchemy_exception, with_traceback=exc_info[2], from=e
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2339, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 304, in unique_connection
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
rec = pool._do_get()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 140, in _do_get
self.dec_overflow()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 137, in _do_get
return self._create_connection()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 309, in _create_connection
return _ConnectionRecord(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 440, in init
self.__connect(first_connect_check=True)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 661, in _connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 656, in __connect
connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 493, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/init.py", line 130, in Connect
return Connection(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 185, in init
super().init(*args, **kwargs2)
sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (2003, 'Can't connect to MySQL server on '127.0.0.1' (111 "Connection refused")')
(Background on this error at: http://sqlalche.me/e/13/e3q8)
Traceback (most recent call last):
File "/data/stock/libs/common.py", line 160, in run_with_args
run_fun(tmp_datetime_show) # 使用当前时间
File "/data/stock/jobs/guess_indicators_daily_job.py", line 104, in stat_all_batch
count = common.select_count(sql_count, params=[datetime_int, '300%', '%st%'])
File "/data/stock/libs/common.py", line 111, in select_count
with conn() as db:
File "/data/stock/libs/common.py", line 52, in conn
db.autocommit(on=True)
UnboundLocalError: local variable 'db' referenced before assignment
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2339, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 364, in connect
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
rec = pool._do_get()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 140, in _do_get
self.dec_overflow()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 137, in _do_get
return self._create_connection()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 309, in _create_connection
return _ConnectionRecord(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 440, in init
self.__connect(first_connect_check=True)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 661, in _connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 656, in __connect
connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 493, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/init.py", line 130, in Connect
return Connection(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 185, in init
super().init(*args, **kwargs2)
MySQLdb._exceptions.OperationalError: (2003, 'Can't connect to MySQL server on '127.0.0.1' (111 "Connection refused")')

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/data/stock/libs/common.py", line 160, in run_with_args
run_fun(tmp_datetime_show) # 使用当前时间
File "/data/stock/jobs/guess_indicators_daily_job.py", line 40, in stat_all_lite_buy
data = pd.read_sql(sql=sql_1, con=common.engine(), params=[datetime_int])
File "/usr/local/lib/python3.6/site-packages/pandas/io/sql.py", line 438, in read_sql
chunksize=chunksize,
File "/usr/local/lib/python3.6/site-packages/pandas/io/sql.py", line 1218, in read_query
result = self.execute(*args)
File "/usr/local/lib/python3.6/site-packages/pandas/io/sql.py", line 1087, in execute
return self.connectable.execute(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2237, in execute
connection = self._contextual_connect(close_with_result=True)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2305, in _contextual_connect
self._wrap_pool_connect(self.pool.connect, None),
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2343, in wrap_pool_connect
e, dialect, self
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1585, in handle_dbapi_exception_noconnection
sqlalchemy_exception, with_traceback=exc_info[2], from=e
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2339, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 364, in connect
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
rec = pool._do_get()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 140, in _do_get
self.dec_overflow()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 137, in _do_get
return self._create_connection()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 309, in _create_connection
return _ConnectionRecord(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 440, in init
self.__connect(first_connect_check=True)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 661, in _connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 656, in __connect
connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 493, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/init.py", line 130, in Connect
return Connection(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 185, in init
super().init(*args, **kwargs2)
sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (2003, 'Can't connect to MySQL server on '127.0.0.1' (111 "Connection refused")')
(Background on this error at: http://sqlalche.me/e/13/e3q8)
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2339, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 364, in connect
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
rec = pool._do_get()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 140, in _do_get
self.dec_overflow()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 137, in _do_get
return self._create_connection()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 309, in _create_connection
return _ConnectionRecord(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 440, in init
self.__connect(first_connect_check=True)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 661, in _connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 656, in __connect
connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 493, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/init.py", line 130, in Connect
return Connection(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 185, in init
super().init(*args, **kwargs2)
MySQLdb._exceptions.OperationalError: (2003, 'Can't connect to MySQL server on '127.0.0.1' (111 "Connection refused")')

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/data/stock/libs/common.py", line 160, in run_with_args
run_fun(tmp_datetime_show) # 使用当前时间
File "/data/stock/jobs/guess_indicators_daily_job.py", line 75, in stat_all_lite_sell
data = pd.read_sql(sql=sql_1, con=common.engine(), params=[datetime_int])
File "/usr/local/lib/python3.6/site-packages/pandas/io/sql.py", line 438, in read_sql
chunksize=chunksize,
File "/usr/local/lib/python3.6/site-packages/pandas/io/sql.py", line 1218, in read_query
result = self.execute(*args)
File "/usr/local/lib/python3.6/site-packages/pandas/io/sql.py", line 1087, in execute
return self.connectable.execute(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2237, in execute
connection = self._contextual_connect(close_with_result=True)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2305, in _contextual_connect
self._wrap_pool_connect(self.pool.connect, None),
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2343, in wrap_pool_connect
e, dialect, self
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1585, in handle_dbapi_exception_noconnection
sqlalchemy_exception, with_traceback=exc_info[2], from=e
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2339, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 364, in connect
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
rec = pool._do_get()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 140, in _do_get
self.dec_overflow()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 137, in _do_get
return self._create_connection()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 309, in _create_connection
return _ConnectionRecord(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 440, in init
self.__connect(first_connect_check=True)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 661, in _connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 656, in __connect
connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 493, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/init.py", line 130, in Connect
return Connection(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 185, in init
super().init(*args, **kwargs2)
sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (2003, 'Can't connect to MySQL server on '127.0.0.1' (111 "Connection refused")')
(Background on this error at: http://sqlalche.me/e/13/e3q8)
rm -f /data/cache/hist_data_cache/2021-04/
root@dd0d5595457a:/data#
C:\Users\hlc>docker exec -it stock bash
root@929f1f0e5dbe:/data# sh /data/stock/jobs/cron.daily/run_daily
Traceback (most recent call last):
File "/usr/local/lib/python3.6/urllib/request.py", line 1349, in do_open
encode_chunked=req.has_header('Transfer-encoding'))
File "/usr/local/lib/python3.6/http/client.py", line 1272, in request
self._send_request(method, url, body, headers, encode_chunked)
File "/usr/local/lib/python3.6/http/client.py", line 1318, in _send_request
self.endheaders(body, encode_chunked=encode_chunked)
File "/usr/local/lib/python3.6/http/client.py", line 1267, in endheaders
self._send_output(message_body, encode_chunked=encode_chunked)
File "/usr/local/lib/python3.6/http/client.py", line 1038, in _send_output
self.send(msg)
File "/usr/local/lib/python3.6/http/client.py", line 976, in send
self.connect()
File "/usr/local/lib/python3.6/http/client.py", line 948, in connect
(self.host,self.port), self.timeout, self.source_address)
File "/usr/local/lib/python3.6/socket.py", line 704, in create_connection
for res in getaddrinfo(host, port, 0, SOCK_STREAM):
File "/usr/local/lib/python3.6/socket.py", line 745, in getaddrinfo
for res in _socket.getaddrinfo(host, port, family, type, proto, flags):
socket.gaierror: [Errno -3] Temporary failure in name resolution

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/data/stock/libs/common.py", line 160, in run_with_args
run_fun(tmp_datetime_show) # 使用当前时间
File "/data/stock/jobs/daily_job.py", line 30, in stat_all
data = ts.top_list(datetime_str)
File "/usr/local/lib/python3.6/site-packages/tushare/stock/billboard.py", line 64, in top_list
if(du.is_holiday(date)):
File "/usr/local/lib/python3.6/site-packages/tushare/util/dateu.py", line 91, in is_holiday
df = trade_cal()
File "/usr/local/lib/python3.6/site-packages/tushare/util/dateu.py", line 83, in trade_cal
df = pd.read_csv(ct.ALL_CAL_FILE)
File "/usr/local/lib/python3.6/site-packages/pandas/io/parsers.py", line 676, in parser_f
return _read(filepath_or_buffer, kwds)
File "/usr/local/lib/python3.6/site-packages/pandas/io/parsers.py", line 431, in _read
filepath_or_buffer, encoding, compression
File "/usr/local/lib/python3.6/site-packages/pandas/io/common.py", line 172, in get_filepath_or_buffer
req = urlopen(filepath_or_buffer)
File "/usr/local/lib/python3.6/site-packages/pandas/io/common.py", line 141, in urlopen
return urllib.request.urlopen(*args, **kwargs)
File "/usr/local/lib/python3.6/urllib/request.py", line 223, in urlopen
return opener.open(url, data, timeout)
File "/usr/local/lib/python3.6/urllib/request.py", line 526, in open
response = self._open(req, data)
File "/usr/local/lib/python3.6/urllib/request.py", line 544, in _open
'_open', req)
File "/usr/local/lib/python3.6/urllib/request.py", line 504, in _call_chain
result = func(*args)
File "/usr/local/lib/python3.6/urllib/request.py", line 1377, in http_open
return self.do_open(http.client.HTTPConnection, req)
File "/usr/local/lib/python3.6/urllib/request.py", line 1351, in do_open
raise URLError(err)
urllib.error.URLError: <urlopen error [Errno -3] Temporary failure in name resolution>
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2339, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 304, in unique_connection
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
rec = pool._do_get()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 140, in _do_get
self.dec_overflow()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 137, in _do_get
return self._create_connection()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 309, in _create_connection
return _ConnectionRecord(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 440, in init
self.__connect(first_connect_check=True)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 661, in _connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 656, in __connect
connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 493, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/init.py", line 130, in Connect
return Connection(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 185, in init
super().init(*args, **kwargs2)
MySQLdb._exceptions.OperationalError: (1045, "Access denied for user 'root'@'172.17.0.2' (using password: YES)")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/data/stock/libs/common.py", line 160, in run_with_args
run_fun(tmp_datetime_show) # 使用当前时间
File "/data/stock/jobs/18h_daily_job.py", line 38, in stat_index_all
common.insert_db(data, "ts_index_all", False, "date,code")
File "/data/stock/libs/common.py", line 59, in insert_db
insert_other_db(MYSQL_DB, data, table_name, write_index, primary_keys)
File "/data/stock/libs/common.py", line 68, in insert_other_db
insp = inspect(engine_mysql)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/inspection.py", line 64, in inspect
ret = reg(subject)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/reflection.py", line 139, in _insp
return Inspector.from_engine(bind)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/reflection.py", line 135, in from_engine
return Inspector(bind)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/reflection.py", line 108, in init
bind.connect().close()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2266, in connect
return self._connection_cls(self, **kwargs)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 104, in init
else engine.raw_connection()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2373, in raw_connection
self.pool.unique_connection, _connection
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2343, in wrap_pool_connect
e, dialect, self
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1585, in handle_dbapi_exception_noconnection
sqlalchemy_exception, with_traceback=exc_info[2], from=e
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2339, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 304, in unique_connection
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
rec = pool._do_get()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 140, in _do_get
self.dec_overflow()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 137, in _do_get
return self._create_connection()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 309, in _create_connection
return _ConnectionRecord(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 440, in init
self.__connect(first_connect_check=True)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 661, in _connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 656, in __connect
connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 493, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/init.py", line 130, in Connect
return Connection(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 185, in init
super().init(*args, **kwargs2)
sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (1045, "Access denied for user 'root'@'172.17.0.2' (using password: YES)")
(Background on this error at: http://sqlalche.me/e/13/e3q8)
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2339, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 304, in unique_connection
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
rec = pool._do_get()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 140, in _do_get
self.dec_overflow()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 137, in _do_get
return self._create_connection()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 309, in _create_connection
return _ConnectionRecord(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 440, in init
self.__connect(first_connect_check=True)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 661, in _connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 656, in __connect
connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 493, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/init.py", line 130, in Connect
return Connection(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 185, in init
super().init(*args, **kwargs2)
MySQLdb._exceptions.OperationalError: (1045, "Access denied for user 'root'@'172.17.0.2' (using password: YES)")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/data/stock/libs/common.py", line 160, in run_with_args
run_fun(tmp_datetime_show) # 使用当前时间
File "/data/stock/jobs/18h_daily_job.py", line 57, in stat_today_all
common.insert_db(data, "ts_today_all", False, "date,code")
File "/data/stock/libs/common.py", line 59, in insert_db
insert_other_db(MYSQL_DB, data, table_name, write_index, primary_keys)
File "/data/stock/libs/common.py", line 68, in insert_other_db
insp = inspect(engine_mysql)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/inspection.py", line 64, in inspect
ret = reg(subject)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/reflection.py", line 139, in _insp
return Inspector.from_engine(bind)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/reflection.py", line 135, in from_engine
return Inspector(bind)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/reflection.py", line 108, in init
bind.connect().close()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2266, in connect
return self._connection_cls(self, **kwargs)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 104, in init
else engine.raw_connection()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2373, in raw_connection
self.pool.unique_connection, _connection
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2343, in wrap_pool_connect
e, dialect, self
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1585, in handle_dbapi_exception_noconnection
sqlalchemy_exception, with_traceback=exc_info[2], from=e
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2339, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 304, in unique_connection
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
rec = pool._do_get()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 140, in _do_get
self.dec_overflow()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 137, in _do_get
return self._create_connection()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 309, in _create_connection
return _ConnectionRecord(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 440, in init
self.__connect(first_connect_check=True)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 661, in _connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 656, in __connect
connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 493, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/init.py", line 130, in Connect
return Connection(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 185, in init
super().init(*args, **kwargs2)
sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (1045, "Access denied for user 'root'@'172.17.0.2' (using password: YES)")
(Background on this error at: http://sqlalche.me/e/13/e3q8)
Traceback (most recent call last):
File "/data/stock/libs/common.py", line 160, in run_with_args
run_fun(tmp_datetime_show) # 使用当前时间
File "/data/stock/jobs/guess_indicators_daily_job.py", line 104, in stat_all_batch
count = common.select_count(sql_count, params=[datetime_int, '300%', '%st%'])
File "/data/stock/libs/common.py", line 111, in select_count
with conn() as db:
File "/data/stock/libs/common.py", line 52, in conn
db.autocommit(on=True)
UnboundLocalError: local variable 'db' referenced before assignment
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2339, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 364, in connect
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
rec = pool._do_get()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 140, in _do_get
self.dec_overflow()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 137, in _do_get
return self._create_connection()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 309, in _create_connection
return _ConnectionRecord(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 440, in init
self.__connect(first_connect_check=True)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 661, in _connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 656, in __connect
connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 493, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/init.py", line 130, in Connect
return Connection(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 185, in init
super().init(*args, **kwargs2)
MySQLdb._exceptions.OperationalError: (1045, "Access denied for user 'root'@'172.17.0.2' (using password: YES)")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/data/stock/libs/common.py", line 160, in run_with_args
run_fun(tmp_datetime_show) # 使用当前时间
File "/data/stock/jobs/guess_indicators_daily_job.py", line 40, in stat_all_lite_buy
data = pd.read_sql(sql=sql_1, con=common.engine(), params=[datetime_int])
File "/usr/local/lib/python3.6/site-packages/pandas/io/sql.py", line 438, in read_sql
chunksize=chunksize,
File "/usr/local/lib/python3.6/site-packages/pandas/io/sql.py", line 1218, in read_query
result = self.execute(*args)
File "/usr/local/lib/python3.6/site-packages/pandas/io/sql.py", line 1087, in execute
return self.connectable.execute(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2237, in execute
connection = self._contextual_connect(close_with_result=True)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2305, in _contextual_connect
self._wrap_pool_connect(self.pool.connect, None),
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2343, in wrap_pool_connect
e, dialect, self
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1585, in handle_dbapi_exception_noconnection
sqlalchemy_exception, with_traceback=exc_info[2], from=e
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2339, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 364, in connect
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
rec = pool._do_get()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 140, in _do_get
self.dec_overflow()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 137, in _do_get
return self._create_connection()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 309, in _create_connection
return _ConnectionRecord(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 440, in init
self.__connect(first_connect_check=True)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 661, in _connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 656, in __connect
connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 493, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/init.py", line 130, in Connect
return Connection(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 185, in init
super().init(*args, **kwargs2)
sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (1045, "Access denied for user 'root'@'172.17.0.2' (using password: YES)")
(Background on this error at: http://sqlalche.me/e/13/e3q8)
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2339, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 364, in connect
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
rec = pool._do_get()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 140, in _do_get
self.dec_overflow()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 137, in _do_get
return self._create_connection()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 309, in _create_connection
return _ConnectionRecord(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 440, in init
self.__connect(first_connect_check=True)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 661, in _connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 656, in __connect
connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 493, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/init.py", line 130, in Connect
return Connection(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 185, in init
super().init(*args, **kwargs2)
MySQLdb._exceptions.OperationalError: (1045, "Access denied for user 'root'@'172.17.0.2' (using password: YES)")

The above exception was the direct cause of the following exception:

请教这是什么意思？此项目要独立的mysql吗，还是mariadb就足够了？

mac下 chown: changing ownership of '/var/lib/mysql/': Operation not permitted

2021-01-07 06:34:04+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.5.8+maria~focal started.

chown: changing ownership of '/var/lib/mysql/': Operation not permitted

2021-01-07 06:34:11+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.5.8+maria~focal started.

chown: changing ownership of '/var/lib/mysql/': Operation not permitted

rm: cannot remove hist_data_cache,xxx : Is a directory

运行：

docker exec -it stock bash 
sh /data/stock/jobs/cron.daily/run_daily

报错：

NOTE: Behavior of MACDH calculation has changed as of July 2017 - it is now 1/2 of previous calculated values
Traceback (most recent call last):
  File "/data/stock/libs/common.py", line 160, in run_with_args
    run_fun(tmp_datetime_show)  # 使用当前时间
  File "/data/stock/jobs/guess_indicators_daily_job.py", line 124, in stat_all_batch
    stat_index_all(data, i)
  File "/data/stock/jobs/guess_indicators_daily_job.py", line 218, in stat_index_all
    data_new = concat_guess_data(stock_column, data)
  File "/data/stock/jobs/guess_indicators_daily_job.py", line 248, in concat_guess_data
    stock_guess = stock_guess.apply(apply_guess, stock_column=stock_column, axis=1)  # , axis=1)
  File "/usr/local/lib/python3.6/site-packages/pandas/core/frame.py", line 6878, in apply
    return op.get_result()
  File "/usr/local/lib/python3.6/site-packages/pandas/core/apply.py", line 186, in get_result
    return self.apply_standard()
  File "/usr/local/lib/python3.6/site-packages/pandas/core/apply.py", line 313, in apply_standard
    results, res_index = self.apply_series_generator()
  File "/usr/local/lib/python3.6/site-packages/pandas/core/apply.py", line 341, in apply_series_generator
    results[i] = self.f(v)
  File "/usr/local/lib/python3.6/site-packages/pandas/core/apply.py", line 113, in f
    return func(x, *args, **kwds)
  File "/data/stock/jobs/guess_indicators_daily_job.py", line 270, in apply_guess
    stock = common.get_hist_data_cache(code, date_start, date_end)
  File "/data/stock/libs/common.py", line 189, in get_hist_data_cache
    stock = ts.get_hist_data(code, start=date_start, end=date_end)
  File "/usr/local/lib/python3.6/site-packages/tushare/stock/trading.py", line 81, in get_hist_data
    js = json.loads(lines.decode('utf-8') if ct.PY3 else lines)
  File "/usr/local/lib/python3.6/json/__init__.py", line 354, in loads
    return _default_decoder.decode(s)
  File "/usr/local/lib/python3.6/json/decoder.py", line 339, in decode
    obj, end = self.raw_decode(s, idx=_w(s, 0).end())
  File "/usr/local/lib/python3.6/json/decoder.py", line 355, in raw_decode
    obj, end = self.scan_once(s, idx)
json.decoder.JSONDecodeError: Unterminated string starting at: line 1 column 78670 (char 78669)
rm -f /data/cache/hist_data_cache/2020-07/
rm: cannot remove '/data/cache/hist_data_cache/2020-07/': Is a directory

tushare 的api需要更新？

######### get data, write cache ######### 000912 2020-03-08 2021-01-02
本接口即将停止更新，请尽快使用Pro版接口：https://tushare.pro/document/2

直接运行docker hub上的镜像可以，但是代码拉下来本地后，docker 构建镜像，本地打不开

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.