{"id":3326,"date":"2024-11-11T15:22:15","date_gmt":"2024-11-11T07:22:15","guid":{"rendered":"http:\/\/www.jiayus.com\/?p=3326"},"modified":"2024-11-11T15:22:15","modified_gmt":"2024-11-11T07:22:15","slug":"%e5%a6%82%e4%bd%95%e7%94%a8api%e6%8e%a5%e5%8f%a3%e8%b0%83%e7%94%a8%e7%94%b2%e9%b1%bc%e8%88%86%e6%83%85%e7%9b%91%e6%b5%8b%e8%bd%af%e4%bb%b6%e9%87%87%e9%9b%86%e5%88%b0%e7%9a%84%e5%85%a8%e7%bd%91","status":"publish","type":"post","link":"http:\/\/www.jiayus.com\/?p=3326","title":{"rendered":"\u5982\u4f55\u7528API\u63a5\u53e3\u8c03\u7528\u7532\u9c7c\u8206\u60c5\u76d1\u6d4b\u8f6f\u4ef6\u91c7\u96c6\u5230\u7684\u5168\u7f51\u5386\u53f210\u5e74\u516c\u5f00\u8d44\u8baf\u6587\u672c\u7c7b\u6570\u636e"},"content":{"rendered":"\n

\u8ba1\u7b97\u673a\u8bed\u97f3\uff1aSQLite\u6570\u636e\u5e93\u3001python<\/p>\n\n\n\n

\u516c\u5f00\u8d44\u8baf\u6587\u672c\u6570\u636e\u4e3b\u8981\u5e73\u53f0\uff1a\u6296\u97f3\u3001\u767e\u5ea6\u3001\u5c0f\u7ea2\u4e66\u3001\u4eca\u65e5\u5934\u6761\u3001\u65b0\u6d6a\u5fae\u535a\u3001\u5fae\u4fe1\u516c\u4f17\u53f7\u3001\u77e5\u4e4e\u3001B\u7ad9\u3001\u8c46\u74e3\u3001\u65b0\u534e\u7f51\u3001\u4eba\u6c11\u7f51\u3001\u6c7d\u8f66\u4e4b\u5bb6\u3001\u65b0\u95fb\u7f51\u7ad9\u3001\u8bba\u575b\u3001APP\u3001\u8bc4\u8bba\u7b49\u6570\u636e<\/p>\n\n\n\n

\u9700\u6c421\uff1a\u901a\u8fc7API\u63a5\u53e3\u8c03\u7528\u67d0\u4e2a\u5173\u952e\u8bcd\u6216\u8005\u67d0\u4e2a\u903b\u8f91\u7b97\u6cd5\u5728\u4e92\u8054\u7f51\u5386\u53f210\u5e74\u5168\u7f51\u516c\u5f00\u8d44\u8baf\u6587\u672c\u7c7b\u6570\u636e\uff1b<\/p>\n\n\n\n

\u9700\u6c422\uff1a\u901a\u8fc7AP\u63a5\u53e3\u8c03\u7528\u67d0\u4e2a\u7f51\u7ad9\u6216\u8005\u67d0\u4e2a\u81ea\u5a92\u4f53\u8d26\u53f7\u5728\u4e92\u8054\u7f51\u5386\u53f210\u5e74\u5168\u7f51\u516c\u5f00\u8d44\u8baf\u6587\u672c\u7c7b\u6570\u636e\uff1b<\/p>\n\n\n\n

\u5b9e\u73b0\u9700\u6c42\u7684\u8ba1\u7b97\u673a\u8bed\u8a00\u4ee3\u7801\u5982\u4e0b\uff08\u524d\u63d0\u662f\u63d0\u4f9b\u6570\u636e\u65b9\u5f00\u901aAPI\u63a5\u53e3\u6743\u9650\uff09\uff1a<\/p>\n\n\n\n

import requests
import sqlite3
import datetime<\/p>\n\n\n\n

# \u6570\u636e\u5e93\u521d\u59cb\u5316
def init_db():
conn = sqlite3.connect(‘api_call_history.db’)
c = conn.cursor()
c.execute(”’CREATE TABLE IF NOT EXISTS api_calls
(id INTEGER PRIMARY KEY AUTOINCREMENT,
endpoint TEXT,
response_status INTEGER,
response_body TEXT,
timestamp DATETIME DEFAULT CURRENT_TIMESTAMP)”’)
conn.commit()
conn.close()<\/p>\n\n\n\n

# \u8bb0\u5f55API\u8c03\u7528
def record_api_call(endpoint, response):
conn = sqlite3.connect(‘api_call_history.db’)
c = conn.cursor()
c.execute(“INSERT INTO api_calls (endpoint, response_status, response_body) VALUES (?, ?, ?)”,
(endpoint, response.status_code, response.text))
conn.commit()
conn.close()<\/p>\n\n\n\n

# \u8c03\u7528API
def call_api(endpoint):
try:
response = requests.get(endpoint)
record_api_call(endpoint, response)
return response
except requests.RequestException as e:
print(f”Error calling API: {e}”)
return None<\/p>\n\n\n\n

# \u67e5\u8be2API\u8c03\u7528\u5386\u53f2
def query_api_calls():
conn = sqlite3.connect(‘api_call_history.db’)
c = conn.cursor()
c.execute(“SELECT * FROM api_calls ORDER BY timestamp DESC”)
rows = c.fetchall()
for row in rows:
print(row)
conn.close()<\/p>\n\n\n\n

# \u4e3b\u7a0b\u5e8f
if __name__ == “__main__”:
init_db() # \u521d\u59cb\u5316\u6570\u636e\u5e93

# \u793a\u4f8bAPI\u8c03\u7528
endpoint = “https:\/\/jsonplaceholder.typicode.com\/posts\/1”
response = call_api(endpoint)

if response:
print(f”API Call Successful: {response.status_code}”)
print(response.json())

# \u67e5\u8be2API\u8c03\u7528\u5386\u53f2
query_api_calls()<\/p>\n","protected":false},"excerpt":{"rendered":"