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

const r = await Miaoguo.RunSql([658],
    'SELECT ID,CreateTime,DayNumber,CardTask,IsShare,HardworkingNumber,MilestoneDayNumber,AphorismID FROM MiaoguoTask where UserID=658 and ID>384493 order by ID;');
console.log('UserID=658, ID>384493 共', r.length, '条:');
for (const x of r)
    console.log([x.ID, x.CreateTime, 'Day=' + x.DayNumber, 'Card=' + x.CardTask, 'Share=' + x.IsShare, 'HW=' + x.HardworkingNumber, 'Mil=' + x.MilestoneDayNumber, 'Aph=' + x.AphorismID].join(' | '));

const g = await Miaoguo.RunSql([658],
    '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=658;');
console.log('\n汇总:', JSON.stringify(g[0]));

const dup = await Miaoguo.RunSql([658],
    "SELECT DATE(CreateTime) d, COUNT(*) c FROM MiaoguoTask WHERE CardTask>0 AND UserID=658 GROUP BY DATE(CreateTime) HAVING c>1 ORDER BY d DESC LIMIT 20;");
console.log('同一天多条:', JSON.stringify(dup));
process.exit(0);