import Miaoguo from '../src/model/miaoguo.js';

const r = await Miaoguo.RunSql([42792],
    'SELECT ID,CreateTime,DayNumber,IsShare,HardworkingNumber,MilestoneDayNumber FROM MiaoguoTask where UserID=? order by CreateTime desc limit 8;');
console.log('42792 末 8 条:');
for (const x of r)
    console.log([x.ID, x.CreateTime, 'Day=' + x.DayNumber, 'Share=' + x.IsShare, 'HW=' + x.HardworkingNumber, 'Mil=' + x.MilestoneDayNumber].join(' | '));

const g = await Miaoguo.RunSql([42792],
    'SELECT COUNT(*) as rows, COUNT(DISTINCT DATE(CreateTime)) as days, MAX(DayNumber) as maxDay, MIN(DayNumber) as minDay FROM MiaoguoTask where CardTask>0 and UserID=?;');
console.log('\n汇总:', JSON.stringify(g[0]));
console.log(g[0].maxDay === g[0].days && g[0].minDay === 1 ? '=> DayNumber 连续且无膨胀 ✅' : '=> 仍有异常 ❌');
process.exit(0);