requirements.txt文件里面缺少cryptography依赖包 #19
Description
部署完运行会报错，finhack collector run --vendor=tushare ：
^CTraceback (most recent call last): File "/home/dennis/miniconda3/envs/finhack/lib/python3.9/site-packages/finhack/library/monitor.py", line 15, in wrapper res=self.func(*args,**kwargs) File "/home/dennis/miniconda3/envs/finhack/lib/python3.9/site-packages/finhack/collector/tushare/astockbasic.py", line 87, in trade_cal tsSHelper.getDataAndReplace(pro,'trade_cal','astock_trade_cal',db) File "/home/dennis/miniconda3/envs/finhack/lib/python3.9/site-packages/finhack/collector/tushare/helper.py", line 109, in getDataAndReplace DB.to_sql(data, f"{table}_tmp", db, 'replace') File "/home/dennis/miniconda3/envs/finhack/lib/python3.9/site-packages/finhack/library/db.py", line 83, in to_sql return mydb.toSql(df, table_name, connection) File "/home/dennis/miniconda3/envs/finhack/lib/python3.9/site-packages/finhack/library/mydb.py", line 88, in toSql res = df.to_sql(table, engine, index=False, if_exists='append', chunksize=5000) File "/home/dennis/miniconda3/envs/finhack/lib/python3.9/site-packages/pandas/util/_decorators.py", line 333, in wrapper return func(*args, **kwargs) File "/home/dennis/miniconda3/envs/finhack/lib/python3.9/site-packages/pandas/core/generic.py", line 3087, in to_sql return sql.to_sql( File "/home/dennis/miniconda3/envs/finhack/lib/python3.9/site-packages/pandas/io/sql.py", line 841, in to_sql with pandasSQL_builder(con, schema=schema, need_transaction=True) as pandas_sql: File "/home/dennis/miniconda3/envs/finhack/lib/python3.9/site-packages/pandas/io/sql.py", line 906, in pandasSQL_builder return SQLDatabase(con, schema, need_transaction) File "/home/dennis/miniconda3/envs/finhack/lib/python3.9/site-packages/pandas/io/sql.py", line 1636, in __init__ con = self.exit_stack.enter_context(con.connect()) File "/home/dennis/miniconda3/envs/finhack/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 3274, in connect return self._connection_cls(self) File "/home/dennis/miniconda3/envs/finhack/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 146, in __init__ self._dbapi_connection = engine.raw_connection() File "/home/dennis/miniconda3/envs/finhack/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 3298, in raw_connection return self.pool.connect() File "/home/dennis/miniconda3/envs/finhack/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 449, in connect return _ConnectionFairy._checkout(self) File "/home/dennis/miniconda3/envs/finhack/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 1263, in _checkout fairy = _ConnectionRecord.checkout(pool) File "/home/dennis/miniconda3/envs/finhack/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 712, in checkout rec = pool._do_get() File "/home/dennis/miniconda3/envs/finhack/lib/python3.9/site-packages/sqlalchemy/pool/impl.py", line 180, in _do_get self._dec_overflow() File "/home/dennis/miniconda3/envs/finhack/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__ raise exc_value.with_traceback(exc_tb) File "/home/dennis/miniconda3/envs/finhack/lib/python3.9/site-packages/sqlalchemy/pool/impl.py", line 177, in _do_get return self._create_connection() File "/home/dennis/miniconda3/envs/finhack/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 390, in _create_connection return _ConnectionRecord(self) File "/home/dennis/miniconda3/envs/finhack/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 674, in __init__ self.__connect() File "/home/dennis/miniconda3/envs/finhack/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 901, in __connect pool.logger.debug("Error on connect(): %s", e) File "/home/dennis/miniconda3/envs/finhack/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__ raise exc_value.with_traceback(exc_tb) File "/home/dennis/miniconda3/envs/finhack/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 896, in __connect self.dbapi_connection = connection = pool._invoke_creator(self) File "/home/dennis/miniconda3/envs/finhack/lib/python3.9/site-packages/sqlalchemy/engine/create.py", line 646, in connect return dialect.connect(*cargs, **cparams) File "/home/dennis/miniconda3/envs/finhack/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 622, in connect return self.loaded_dbapi.connect(*cargs, **cparams) File "/home/dennis/miniconda3/envs/finhack/lib/python3.9/site-packages/pymysql/connections.py", line 361, in __init__ self.connect() File "/home/dennis/miniconda3/envs/finhack/lib/python3.9/site-packages/pymysql/connections.py", line 669, in connect self._request_authentication() File "/home/dennis/miniconda3/envs/finhack/lib/python3.9/site-packages/pymysql/connections.py", line 979, in _request_authentication auth_packet = _auth.caching_sha2_password_auth(self, auth_packet) File "/home/dennis/miniconda3/envs/finhack/lib/python3.9/site-packages/pymysql/_auth.py", line 267, in caching_sha2_password_auth data = sha2_rsa_encrypt(conn.password, conn.salt, conn.server_public_key) File "/home/dennis/miniconda3/envs/finhack/lib/python3.9/site-packages/pymysql/_auth.py", line 144, in sha2_rsa_encrypt raise RuntimeError( RuntimeError: 'cryptography' package is required for sha256_password or caching_sha2_password auth methods
是因为requirements.txt文件里面缺少cryptography依赖包。可以添加上去，以后一起安装了。