DOMJudge竟然没有在前端提供一键导出比赛所有代码的功能，只能在数据库中导出。
以下是博主写的一段Python脚本，用于实现该功能。
该脚本也托管在Github上，仓库Yerosius/export_domjudge_code。
受限于博主水平，存在不可避免的疏忽之处，还望梅涵。
用法：
- 先安装本脚本用到的第三方库：
pip install mysql-connector-python tqdm pwinput
- 运行此脚本，输入数据库地址、账户、密码、数据库名、比赛ID，即可进行导出。导出后的目录结构为
语言(c/cpp/java/py3)/队伍ID/题目ID/提交ID.ext，并打包为zip文件：
#!/usr/bin/env python3
# -*- coding: utf-8 -*-import os
import sys
import tempfile
import zipfile
import shutil
import mysql.connector
from tqdm import tqdm
import pwinputLANG_EXT = {'c': 'c','cpp': 'cpp','java': 'java','python3': 'py'
}def connect_db():db_host = input("Enter database host (default: localhost): ").strip() or "localhost"db_user = input("Enter database username (default: root): ").strip() or "root"db_pass = pwinput.pwinput("Enter database password: ", mask="*")db_name = input("Enter database name (default: domjudge): ").strip() or "domjudge"contest_id = input("Enter contest ID: ").strip()try:conn = mysql.connector.connect(host=db_host,user=db_user,password=db_pass,database=db_name)except mysql.connector.Error as err:print(f"[ERROR] Could not connect to database: {err}")sys.exit(1)return conn, contest_iddef query_submissions(conn, contest_id):cursor = conn.cursor(dictionary=True)query = """SELECT s.submitid, s.teamid, s.probid, s.langid, f.sourcecode, f.filenameFROM submission sJOIN submission_file f ON s.submitid = f.submitidWHERE s.cid = %sORDER BY s.langid, s.teamid, s.probid, s.submitid"""cursor.execute(query, (contest_id,))rows = cursor.fetchall()cursor.close()return rowsdef export_submissions(rows, temp_dir):total_files = len(rows)if total_files == 0:print("[WARNING] No submissions found for this contest.")return 0for row in tqdm(rows, desc="Exporting submissions", unit="file"):lang = row['langid']team = row['teamid']problem = row['probid']submitid = row['submitid']filename = row['filename'] or "submission"name, ext = os.path.splitext(filename)if not ext:ext = f".{LANG_EXT.get(lang, 'txt')}"final_filename = f"{name}_{submitid}{ext}"dir_path = os.path.join(temp_dir, lang, f"team_{team}", f"problem_{problem}")os.makedirs(dir_path, exist_ok=True)file_path = os.path.join(dir_path, final_filename)with open(file_path, "wb") as f:f.write(row['sourcecode'])return total_filesdef create_zip(temp_dir, contest_id):archive_name = f"contest_{contest_id}_submissions.zip"with zipfile.ZipFile(archive_name, "w", zipfile.ZIP_DEFLATED) as zipf:for root, dirs, files in os.walk(temp_dir):for file in files:abs_path = os.path.join(root, file)arcname = os.path.relpath(abs_path, temp_dir)zipf.write(abs_path, arcname)print(f"[INFO] All submissions packaged into: {os.path.abspath(archive_name)}")return archive_namedef main():print("DOMJudge Contest Source Code Export Tool")conn, contest_id = connect_db()temp_dir = tempfile.mkdtemp(prefix=f"contest_{contest_id}_")rows = query_submissions(conn, contest_id)conn.close()total_files = export_submissions(rows, temp_dir)if total_files == 0:shutil.rmtree(temp_dir)returncreate_zip(temp_dir, contest_id)shutil.rmtree(temp_dir)if __name__ == "__main__":main()