[PYTHON] 匯入台銀美元日圓歐元範例

import twder import datetime #from datetime import datetime import cx_Oracle tomorrow = datetime.date.today() + datetime.timedelta(days=1) currency = ["USD",'JPY','EUR'] #依需求編輯幣別 conn = cx_Oracle.connect("帳號", "密碼", "IP:PORT如1521/服務名稱如XXPROD") cur = conn.cursor() # 共用 for i in range(len(currency)): TYPE = currency[i] RATE = str((float(twder.past_six_month(TYPE)[0][3]) + float(twder.past_six_month(TYPE)[0][4])) / 2) if TYPE == "JPY": TYPE = 'YEN' SQL = "UPDATE AZK_FILE SET AZK041 = '" + RATE + "' WHERE AZK01 = '" SQL = SQL + TYPE + "' AND TO_CHAR(AZK02,'YYYY-MM-DD') = '" +str(tomorrow) + "'"; print(SQL) cur.execute(SQL) conn.commit() cur.close() conn.close()