import commonModel from '../model/commonModel.js';
import fs from 'fs';

async function runScript(){
    try {
        //const sql2="update kylx365_db.HanziWord set HanziUnitID=0 where Name='"+item[j]+"'";
        //await commonModel.RunSql(null,sql2
        console.log("SET SQL_SAFE_UPDATES = 0;");
        var data = fs.readFileSync('data.txt', 'utf8');
        let arr=data.split(");")
        var districtID=4;
        for(var i=0;i<arr.length;i++){
            var item=arr[i].split(",");
            if (item[0]){
                var item2=(Number(item[1])-50);
                item[0]=item[0].replace("(","");
                item[0]=item[0].replace("\n","");
                item[0]=item[0].replace("\r","");
                var sql="update MPS_Score set ScoreTotal="+item2+",Score1="+item[2]+",Score2="+item[3]+",Score3="+item[4]+",Score4="+item[5]+" where SchoolFullName="+item[0]+" and DistrictID="+districtID+" and ScoreYear=2025 and ScoreType='名额到区';";
                console.log(sql);
            }
        }
        

        // const sql="SELECT * FROM kylx365_db.HanziUnit where HanziBookID>=61 and HanziBookID<=72 order by HanziBookID,OrderID,ID;"
        // let list = await commonModel.RunSql(null,sql
        // for(let i=0;i<list.length;i++){
        //     let item=list[i].Example;
        //     for(let j=0;j<item.length;j++){
        //         const sql3="SELECT * FROM kylx365_db.HanziWord where Name='"+item[j]+"' and HanziUnitID<500 order by HanziUnitID,ID limit 1;";
        //         let list2=await commonModel.RunSql(null,sql3
        //         for(let k=0;k<list2.length;k++){
        //             const sql4="update kylx365_db.HanziWord set HanziUnitID="+list[i].ID+" where ID="+list2[k].ID+";";
        //             console.log(sql4
        //             await commonModel.RunSql(null,sql4
        //         }
        //     }
            
        //     //console.log(json
        //     //console.log(item.length
        // }
        // const sql2="update kylx365_db.HanziWord set HanziUnitID=0 where HanziUnitID<500";
        // await commonModel.RunSql(null,sql2
        
        //console.log("完成");
    } catch (error) {
        console.error('Error executing script:', error);
    }
}

////批量处理加资料的数据
// async function runScript(){
//     try {
//         const sql="select ID from MiaoguoLiteracy order by ID;"
//         let list = await commonModel.RunSql(null,sql);
//         for(let i=0;i<list.length;i++){
//             if (i % 1000 == 0)
//                 console.log("i:"+i+" ID:"+list[i].ID
//             let item =await commonModel.RunSql(null,"select * from MiaoguoLiteracy where ID="+list[i].ID+";"
//             let json;
//             try {
//                 json = JSON.parse(item[0].JSONString
//             } catch (parseError) {
//                 console.error('JSON Parse Error at ID:', list[i].ID);
//                 console.error('Error details:', parseError);
//                 continue;
//             }
//             if (json && json.CHN && json.CHN.BiShunArr && json.CHN.BiShunArr.length>0){
//                 console.log(i+" "+json.CHN.HanZi);
                
//                 delete json.CHN.BiShunArr;
//                 let obj={};
//                 obj.ID=list[i].ID;
//                 obj.JSONString=JSON.stringify(json);

//                 await commonModel.RunSql(obj,"update MiaoguoLiteracy set ? where ID="+list[i].ID+";"
//             }
//             //console.log(json);
//             //console.log(item.length);
//         }
//         console.log("完成"
//     } catch (error) {
//         console.error('Error executing script:', error);
//     }
// }

// 处理Promise并添加错误捕获
runScript().catch(error => {
    console.error('Error in runScript:', error);
});