pipeline连接数据库

win+R打开cmd

C:\Users\lenovo>pip install sqlalchemy

C:\Users\lenovo>pip install sqlalchemy
Collecting sqlalchemy
  Downloading https://files.pythonhosted.org/packages/5e/a4/51fcedea62d430c310e77d4a70177af1fdf862a8edeb09e3519d68d7964f/SQLAlchemy-1.3.16-cp36-cp36m-win32.whl (1.2MB)
    100% |████████████████████████████████| 1.2MB 39kB/s
Installing collected packages: sqlalchemy
Successfully installed sqlalchemy-1.3.16
You are using pip version 9.0.1, however version 20.1 is available.
You should consider upgrading via the 'python -m pip install --upgrade pip' command.

这个我以前下载过了，过程参考其余两个
pip install pymysql

C:\Users\lenovo>pip install sqlacodegen

根据数据表快速生成数据模型

C:\Users\lenovo>pip install sqlacodegen
Collecting sqlacodegen
  Downloading https://files.pythonhosted.org/packages/37/e9/3af8a387ad640fa92e9916f5e0e9fa4c603b18de77e4f80671d1359159b4/sqlacodegen-2.1.0-py2.py3-none-any.whl
Requirement already satisfied: SQLAlchemy>=0.9.0 in d:\python\python3.6.4\lib\site-packages (from sqlacodegen)
Collecting inflect>=0.2.0 (from sqlacodegen)
  Downloading https://files.pythonhosted.org/packages/b3/27/15edd6e1519f4e489ff50def9367a62d138baa9c000a053c67ac38156519/inflect-4.1.0-py3-none-any.whl
Requirement already satisfied: importlib-metadata; python_version < "3.8" in d:\python\python3.6.4\lib\site-packages (from inflect>=0.2.0->sqlacodegen)
Requirement already satisfied: zipp>=0.5 in d:\python\python3.6.4\lib\site-packages (from importlib-metadata; python_version < "3.8"->inflect>=0.2.0->sqlacodegen)
Installing collected packages: inflect, sqlacodegen
Successfully installed inflect-4.1.0 sqlacodegen-2.1.0
You are using pip version 9.0.1, however version 20.1 is available.
You should consider upgrading via the 'python -m pip install --upgrade pip' command.

用法：路径+表名+输出文件名