scripts/vas/get_all_order_ids.py

15 lines
286 B
Python
Raw Permalink Normal View History

2024-02-19 20:04:33 +08:00
from lib.mysql import *
from lib.util import *
from lib.csv import *
2024-02-19 20:03:04 +08:00
sql = '''
select id from vas_order where order_status>0;
'''
csv_ = Csv("all_order_ids.csv", ["id"])
2024-02-19 20:45:10 +08:00
docs = get_mysql_db_vas().query(sql)
2024-02-19 20:03:04 +08:00
for doc in docs:
_id = safe_get_str(doc, "id")
csv_.append([[_id]])