Metadata-Version: 2.4
Name: ibspot_order_assistant
Version: 0.0.158
Summary: IBSPOT order assistant
Requires-Python: >=3.8
Description-Content-Type: text/markdown
Requires-Dist: click~=8.1.7
Requires-Dist: SQLAlchemy~=2.0.25
Requires-Dist: pyyaml~=6.0.1
Requires-Dist: gspread~=6.0.2
Requires-Dist: mysqlclient~=2.2.4
Requires-Dist: wrapt~=1.16
Requires-Dist: python-dateutil~=2.8
Requires-Dist: tzdata
Requires-Dist: PyDispatcher~=2.0
Requires-Dist: cmutils
Requires-Dist: sqlalchemy-utils~=0.41
Requires-Dist: shipengine
Requires-Dist: tracking_api
Requires-Dist: psycopg2-binary
Requires-Dist: python-telegram-bot~=21.0
Requires-Dist: gmail-api-wrapper
Requires-Dist: tenacity
Requires-Dist: gmail-api-wrapper
Requires-Dist: pytest
Requires-Dist: pytz
Requires-Dist: Jinja2
Requires-Dist: us
Project-URL: Documentation, https://github.com/FG-IT/ibspot_order_assistant/blob/main/README.md
Project-URL: Repository, https://github.com/FG-IT/ibspot_order_assistant

# ibspot_order_assistant

googlesheet订单同步

1. sheet有，db没有，直接插入
2. sheet有，db有：
   a. sheet有一条订单记录，db有一条，且在同一sheet，对比差异，更新
   b. sheet有一条订单记录，db有一条，但是在不同sheet，订单迁移，sheet标记delete，插入sheet的新记录
   c. sheet和db，一对多，多对多，或者多对一，均将db订单删除，插入sheet订单
3. 如果订单显示已经fulfill，无论什么情况下均不删除
4. 每次同步事件需要至少30天否则可能会有漏掉情况
