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

async function runScript(){
    try {
        var data = fs.readFileSync('data2.txt', 'utf8');
        let arr=data.split("\n")
        for(var i=0;i<arr.length;i++){
            var item=arr[i].split("|");
            if (item[1]){
                let obj={};
                obj.Word=stringUtils.Trim(item[1]);
                obj.Word=stringUtils.ReplaceAllString(obj.Word,"'","ˈ");
                obj.Translate=stringUtils.Trim(item[2]);
                obj.Translate=stringUtils.ReplaceAllString(obj.Translate,"'","ˈ");
                obj.BookID=206;
                obj.LessonID=stringUtils.Trim(item[3].replace("Unit",""));
                console.log(JSON.stringify(obj));

                const sql = "INSERT INTO Words SET ?";
                await commonModel.RunSql(obj,sql);
                
            }
        }
        console.log("完成");
        process.exit(1);
    } catch (error) {
        console.error('Error executing script:', error);
        process.exit(1);
    }
}

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