windows server 2008 R2 + 3.7环境下superset安装过程实战（环境/编译/发布/运行）

感谢以下博主贡献
https://www.jianshu.com/p/c751278996f8

https://blog.youkuaiyun.com/gz15126051420/article/details/78258620

https://blog.youkuaiyun.com/draven1122/article/details/78342228

https://www.cnblogs.com/Jonecmnn/p/7417498.html

安装过程:

#安装Microsoft Visual C++ Build Tools
https://pan.baidu.com/s/16jVqbrHALNyammOoGKuJjQ
提取码：u2v6
#安装MSVC v140 -VS 2015 C++ 生成工具(v14.00)

#下载源代码
git clone https://github.com/apache/incubator-superset.git

https://nodejs.org/en/download/(下载安装node.js)
https://yarnpkg.com/zh-Hans/docs/install (下载安装yarn,依赖node.js)

#安装环境
pip install -r C:\Users\Administrator\Desktop\request-list.txt -i https://pypi.tuna.tsinghua.edu.cn/simple/

#request-list.txt内容
virtualenv
backoff
bleach
click
celery
colorama
contextlib2
croniter
cryptography
flask
flask-appbuilder
flask-caching
flask-compress
flask-talisman
flask-wtf
flask-migrate
gunicorn
geohash
geopy
humanize
isodate
markdown
msgpack
polyline
prison
pandas
parsedatetime
pathlib2
pyarrow
pyyaml
python-geohash
python-dotenv
sasl
simplejson
urllib3
walk

#从https://www.lfd.uci.edu/~gohlke/pythonlibs/#lxml下载sasl-0.2.1-cp37-cp37m-win_amd64.whl
pip install "C:\Users\Administrator\Downloads\sasl-0.2.1-cp37-cp37m-win_amd64.whl"

cd  incubator-superset

#创建环境
virtualenv venv

venv\Scripts\activate  (ps:C:\Users\Administrator\incubator-superset\venv\Scripts\activate.bat)

cd superset/assets

将C:\Program Files (x86)\Yarn拷贝到C:\Users\Administrator\AppData\Local\Programs\Yarn\bin(安装后PATH的默认参数C:\Users\Administrator\AppData\Local\Yarn\bin,修改为C:\Users\Administrator\AppData\Local\Programs\Yarn\bin)

#编译
yarn

yarn run build

cd ../../

#编译(编译之后的效果同 pip install superset )
python setup.py install

#手动在"C:\\Users\\Administrator\\incubator-superset\\superset\\static\\assets\\"下创建空白文件version_info.json

flask fab create-admin

(venv) C:\Users\Administrator\incubator-superset>flask fab create-admin
Username [admin]: admin
User first name [admin]: ye
User last name [user]: yang
Email [admin@fab.org]: 81436962@qq.com
Password:111
Repeat for confirmation:111
INFO:root:logging was configured successfully
Recognized Database Authentications.
Admin User admin created.

flask fab create-permissions

(venv) C:\Users\Administrator\incubator-superset>flask fab create-permissions
INFO:root:logging was configured successfully
Created all permissions

flask fab create-db

(venv) C:\Users\Administrator\incubator-superset>flask fab create-db
INFO:root:logging was configured successfully
DB objects created

cd superset/bin

python superset db upgrade

python superset load_examples

python superset load_test_users

python superset init

flask run

(venv) C:\Users\Administrator\incubator-superset>flask run
 * Serving Flask app "superset.app:create_app()" (lazy loading)
 * Environment: development
 * Debug mode: on
 * Restarting with stat
INFO:root:logging was configured successfully
 * Debugger is active!
 * Debugger PIN: 167-347-427
 * Running on http://127.0.0.1:5000/ (Press CTRL+C to quit)
INFO:root:logging was configured successfully

#登陆进去首页空白

pip install superset

#默认安装到 Python\Lib\site-packages\superset\static
#拷贝 C:\Users\Administrator\AppData\Local\Programs\Python\Python37\Lib\site-packages\superset\static到C:\Users\Administrator\incubator-superset\superset\static

完成