import commonModel from '../model/commonModel.js';
import fs from 'fs';
import { stringUtils } from '../util/stringClass.js';

async function runScript(){
    try {
        
        const sql="SELECT * FROM kylx365_db.Words;"
        let list = await commonModel.RunSql(null,sql);
        let count=list.length;
        //count=10;
        for(let i=0;i<count;i++){
            let item=list[i];

            let str=item.Translate;
            str=stringUtils.ReplaceAllString(str,",","，");
            if (str!=item.Translate){
                console.log(str);
                let sql2="update Words set Translate='"+str+"' where ID="+item.ID;
                await commonModel.RunSql(null,sql2);
            }
            console.log( i +"/"+ list.length);

        }
        
        
        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);
});