package com.rongyichuang;

import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.test.context.ActiveProfiles;

@SpringBootTest
@ActiveProfiles("test")
public class SetupJudgeUserTest {

    @Autowired
    private JdbcTemplate jdbcTemplate;

    @Test
    public void setupJudgeUser() {
        // 为第一个评委设置user_id为1，以便测试评分功能
        String updateSql = "UPDATE t_judge SET user_id = 1 WHERE id = 21";
        int updatedRows = jdbcTemplate.update(updateSql);
        
        System.out.println("更新了 " + updatedRows + " 条评委记录");
        
        // 验证更新结果
        String verifySql = "SELECT id, name, user_id FROM t_judge WHERE user_id = 1";
        jdbcTemplate.queryForList(verifySql).forEach(row -> {
            System.out.println("评委ID: " + row.get("id") + 
                             ", 姓名: " + row.get("name") + 
                             ", 用户ID: " + row.get("user_id"));
        });
    }
}