diff --git a/EastMoneyPy/venv/main/eastmoney/getGeGuBanKuai.py b/EastMoneyPy/venv/main/eastmoney/getGeGuBanKuai.py index 7e65344..13cca53 100644 --- a/EastMoneyPy/venv/main/eastmoney/getGeGuBanKuai.py +++ b/EastMoneyPy/venv/main/eastmoney/getGeGuBanKuai.py @@ -31,6 +31,9 @@ code = str(i['f12']) name = str(i['f14']) + sql = "REPLACE INTO t_bankuai SET `code` = '%s', `name` = '%s', cate = %s;" % (code, name, cate) + bkList.append(sql) + getGeGuBanKuai(cate, code, name) @@ -57,6 +60,7 @@ try: + bkList = [] sqlList = [] # 注释这行,用getCodeInfo.py获取 @@ -66,6 +70,7 @@ getBankuai('2') getBankuai('3') + dbConn.MY_SQL().save_bankuai_table(bkList) dbConn.MY_SQL().save_bankuai_table(sqlList) # print(len(sqlList)) print('=== get gegu bankuai success ===')