CREATE TABLE IF NOT EXISTS bat_records (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    description TEXT NOT NULL,           -- 中文說(shuō)明
    python_file TEXT NOT NULL,           -- Python 文件路徑
    bat_file TEXT NOT NULL,              -- 生成的 BAT 文件路徑
    target_folder TEXT NOT NULL,         -- 目標(biāo)文件夾
    other_files TEXT,                    -- 其他附加文件
    create_time TEXT NOT NULL,           -- 創(chuàng)建時(shí)間
    status TEXT DEFAULT 'active'         -- 狀態(tài)標(biāo)識(shí)
);

# 主要區(qū)域劃分
main_sizer = wx.BoxSizer(wx.VERTICAL)

# 文件生成設(shè)置區(qū)域
top_sizer = wx.StaticBoxSizer(wx.VERTICAL, panel, "文件生成設(shè)置")

# 搜索功能區(qū)域  
search_sizer = wx.StaticBoxSizer(wx.HORIZONTAL, panel, "搜索")

# 記錄列表區(qū)域
list_sizer = wx.StaticBoxSizer(wx.VERTICAL, panel, "生成的BAT文件記錄")

def generate_bat_file(self, py_file, description, target_folder):
    # 創(chuàng)建帶時(shí)間戳的子文件夾
    timestamp = datetime.now().strftime("%Y%m%d_%H%M%S")
    py_name = os.path.splitext(os.path.basename(py_file))[0]
    sub_folder = os.path.join(target_folder, f"{py_name}_{timestamp}")
    
    # BAT 文件內(nèi)容模板
    bat_content = f"""@echo off
chcp 65001 > nul
cd /d "%~dp0"
echo 運(yùn)行: {description}
python "{py_file_name}"
pause"""

def copy_project_files(self, py_file, other_files, target_folder):
    # 復(fù)制主 Python 文件
    shutil.copy2(py_file, target_folder)
    
    # 復(fù)制其他依賴文件
    copied_files = []
    if other_files:
        for file_path in other_files.split(';'):
            if os.path.exists(file_path.strip()):
                shutil.copy2(file_path.strip(), target_folder)
                copied_files.append(os.path.basename(file_path.strip()))
    
    return copied_files

def load_records(self, search_term=""):
    if search_term:
        cursor.execute('''
            SELECT * FROM bat_records 
            WHERE description LIKE ? OR python_file LIKE ?
            ORDER BY create_time DESC
        ''', (f'%{search_term}%', f'%{search_term}%'))

def check_file_status(self, bat_file):
    return "存在" if os.path.exists(bat_file) else "丟失"

def open_folder(self, folder_path):
    if sys.platform == "win32":
        os.startfile(folder_path)
    elif sys.platform == "darwin":
        subprocess.call(["open", folder_path])
    else:
        subprocess.call(["xdg-open", folder_path])

self.search_text = wx.TextCtrl(panel, style=wx.TE_PROCESS_ENTER)

# 使用連接上下文管理器
def execute_db_operation(self, query, params=()):
    with sqlite3.connect(self.db_path) as conn:
        cursor = conn.cursor()
        cursor.execute(query, params)
        return cursor.fetchall()

try:
    # 文件操作
    shutil.copy2(source, destination)
except PermissionError:
    wx.MessageBox("權(quán)限不足，請(qǐng)以管理員身份運(yùn)行", "錯(cuò)誤")
except FileNotFoundError:
    wx.MessageBox("源文件不存在", "錯(cuò)誤")
except Exception as e:
    wx.MessageBox(f"操作失敗: {str(e)}", "錯(cuò)誤")

# 及時(shí)釋放數(shù)據(jù)庫(kù)連接
conn.close()

# 清理臨時(shí)變量
del large_data_structure