import json
import logging
from datetime import datetime
from utils.sql_utils import SQLUtils

class GcDao:
    """检验项目配置和数据访问对象"""
    
    def __init__(self):
        """初始化数据访问对象"""
        self.db = SQLUtils('sqlite', database='db/jtDB.db')
    
    def __del__(self):
        """析构函数，确保数据库连接关闭"""
        if hasattr(self, 'db'):
            self.db.close()
    
    def get_gc_info_by_id(self, id):
        """根据id获取GC信息"""
        try:
            sql = """
                SELECT * FROM wsbz_gc_info WHERE id = ?
            """
            self.db.cursor.execute(sql, (id,))
            return self.db.cursor.fetchone()
        except Exception as e:
            logging.error(f"获取GC信息失败: {str(e)}")
            return None