Python中如何检测某个页面是否打开正常并记录到数据库，请看看代码写对了吗？

:) 运行结果正确吗？

h691938207 2楼

import requests
from datetime import datetime
import sqlite3
import time

def check_website_status(url, timeout=10):
    """检查网站状态并返回结果字典"""
    try:
        response = requests.get(url, timeout=timeout)
        status_code = response.status_code
        is_success = 200 <= status_code < 400
        return {
            'url': url,
            'status_code': status_code,
            'is_success': is_success,
            'response_time': response.elapsed.total_seconds(),
            'timestamp': datetime.now(),
            'error_message': None
        }
    except requests.exceptions.RequestException as e:
        return {
            'url': url,
            'status_code': None,
            'is_success': False,
            'response_time': None,
            'timestamp': datetime.now(),
            'error_message': str(e)
        }

def init_database():
    """初始化SQLite数据库"""
    conn = sqlite3.connect('website_monitor.db')
    cursor = conn.cursor()
    cursor.execute('''
        CREATE TABLE IF NOT EXISTS website_checks (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            url TEXT NOT NULL,
            status_code INTEGER,
            is_success BOOLEAN,
            response_time REAL,
            timestamp DATETIME,
            error_message TEXT
        )
    ''')
    conn.commit()
    return conn

def save_to_database(conn, check_result):
    """将检查结果保存到数据库"""
    cursor = conn.cursor()
    cursor.execute('''
        INSERT INTO website_checks 
        (url, status_code, is_success, response_time, timestamp, error_message)
        VALUES (?, ?, ?, ?, ?, ?)
    ''', (
        check_result['url'],
        check_result['status_code'],
        check_result['is_success'],
        check_result['response_time'],
        check_result['timestamp'],
        check_result['error_message']
    ))
    conn.commit()

def monitor_website(url, interval=60):
    """持续监控网站状态"""
    conn = init_database()
    
    print(f"开始监控: {url}")
    print("按 Ctrl+C 停止监控\n")
    
    try:
        while True:
            result = check_website_status(url)
            
            # 保存到数据库
            save_to_database(conn, result)
            
            # 输出当前状态
            status = "✓ 正常" if result['is_success'] else "✗ 异常"
            print(f"[{result['timestamp'].strftime('%Y-%m-%d %H:%M:%S')}] {status} "
                  f"状态码: {result['status_code'] or 'N/A'} "
                  f"响应时间: {result['response_time'] or 'N/A':.3f}s")
            
            if result['error_message']:
                print(f"   错误信息: {result['error_message']}")
            
            time.sleep(interval)
            
    except KeyboardInterrupt:
        print("\n监控已停止")
    finally:
        conn.close()

# 使用示例
if __name__ == "__main__":
    # 监控单个网站
    monitor_website("https://www.example.com", interval=300)  # 每5分钟检查一次
    
    # 或者批量检查多个网站
    def batch_check(urls):
        conn = init_database()
        for url in urls:
            result = check_website_status(url)
            save_to_database(conn, result)
            print(f"{url}: {'正常' if result['is_success'] else '异常'}")
        conn.close()
    
    # batch_check(["https://www.google.com", "https://www.github.com"])

代码说明：