# -*- coding: utf-8 -*-
"""导出 yoshop_store_setting 内容"""
import re
import pymysql
from _root import ROOT

YML = str(ROOT / "yoshop-java/src/main/resources/application.yml")
pwd = re.findall(r"password:\s*(.+)", open(YML, encoding="utf-8").read())[0].strip().strip("\"'")

conn = pymysql.connect(host="192.168.1.177", port=3306, user="root", password=pwd, database="shop")
cur = conn.cursor()
cur.execute("SELECT `key`, `describe`, LEFT(`values`, 300) FROM yoshop_store_setting ORDER BY `key`")
for key, desc, values in cur.fetchall():
    print(f"-- {key} ({desc})\n{values}\n")
conn.close()