优化

bwcxyk · bwcxyk · commit 95ec6d9e6dd9 · 2023-03-27T10:00:57.000+08:00
diff --git a/2022/get_picture_url/.gitignore b/2022/get_picture_url/.gitignore
@@ -1,6 +1,7 @@
 .vscode/*
 .idea
 run_config.py
+*.xlsx
 query.sql
 
 # Byte-compiled / optimized / DLL files
diff --git a/2022/get_picture_url/get_picture_url2.py b/2022/get_picture_url/get_picture_url2.py
@@ -22,6 +22,7 @@
 
 def oracle_connect(connect_string: str):
     """连接 oracle"""
+    global conn, cursor
     conn = cx_Oracle.connect(connect_string)
     cursor = conn.cursor()
     return conn, cursor
@@ -39,9 +40,9 @@ def get_data():
     # 遍历获取所有运单id
     for item in sheet.rows:
         # 取表格第三列值
-        tid = ([item[2].value])
+        tid = ([item[1].value])
         # 转换为字符串
-        if item[2].value is not None:
+        if tid is not None:
             keyword = ''.join(tid)
         else:
             continue 
diff --git a/2022/get_picture_url/query_template.sql b/2022/get_picture_url/query_template.sql
@@ -1,3 +1,3 @@
 SELECT ROWNUM ROWNUM1, name, age
 FROM user
-WHERE = :query
+WHERE name = :query
