---
# System prepended metadata

title: EUShop Intelligence Project

---

# EUShop Intelligence Project 

## Info

- http://3.120.148.151:10103/
- 账号：mes-ro
- 密码：myeu.shop@NL2019
- db name nle-mes
- http://nletech-eu-db.c1snnfqvbket.eu-central-1.rds.amazonaws.com/

## Knowledge/Skill Pool

- Python operate **MySQL**: 
  - [Python & MySQL Crash Course](https://youtu.be/BHwgnGEhYG8)
  - [Python and MySQL Database: A Practical Introduction](https://realpython.com/python-mysql/)

- Using python as service: build python **RestAPI(flask)** 
  - [Creating Web APIs with Python and Flask](https://programminghistorian.org/en/lessons/creating-apis-with-python-and-flask)
  - [Flask REST API Tutorial](https://pythonbasics.org/flask-rest-api/)


- **Better Coding: style** 
  - [PEP 8 – Style Guide for Python Code](https://peps.python.org/pep-0008/)

- **Better Coding: documentation** 
  - [In-code documentation](https://coderefinery.github.io/documentation/in-code-documentation/)

- **prophet** 
  - [Prophet模型预测商品销售量](https://blog.csdn.net/wong2016/article/details/86674043)
  - [Time Series Analysis with Facebook Prophet: How it works and How to use it](https://towardsdatascience.com/time-series-analysis-with-facebook-prophet-how-it-works-and-how-to-use-it-f15ecf2c0e3a)
  - https://facebook.github.io/prophet/docs/quick_start.html#python-api
  

- <font color="gray"> Better Coding: Test-Driven Development (**TDD**)</font>
  - [Modern Test-Driven Development in Python](https://testdriven.io/blog/modern-tdd/)
  - [Beginning Test-Driven Development in Python](https://code.tutsplus.com/tutorials/beginning-test-driven-development-in-python--net-30137)




## Github Repository
  https://github.com/BoringComputing/eushop-intelligence
 
[生成新 SSH 密钥并添加到 ssh-agent](https://docs.github.com/cn/authentication/connecting-to-github-with-ssh/generating-a-new-ssh-key-and-adding-it-to-the-ssh-agent)





## Notes
- utf-8 to chinese (not needed anymore, Python itslef can handle it )
```
"\u87ba\u9738\u738b\u87ba\u86f3\u7c89".encode('utf-8').decode('utf-8')
```
- 商品表t_mall_shop_product
- 商品规格表t_mall_shop_goods
- 订单表：t_mall_shop_order
- 订单商品表：t_mall_shop_order_item
