import {test} from 'node:test'; import assert from 'node:assert/strict'; import {DatabaseSync} from 'node:sqlite'; import {mkdtempSync,rmSync} from 'node:fs'; import {tmpdir} from 'node:os'; import {join} from 'node:path'; import {createApp} from './server.mjs'; import {applyShoppingOverrides} from '../src/shopping.ts'; test('upgrade old database preserves recipes and plans, edits and weekly products survive restart',async()=>{ const dir=mkdtempSync(join(tmpdir(),'amesa-upgrade-')); const old=new DatabaseSync(join(dir,'amesa.sqlite')); old.exec(`CREATE TABLE recipes(id TEXT PRIMARY KEY,name TEXT NOT NULL,image TEXT NOT NULL,ingredients TEXT NOT NULL,preparation TEXT NOT NULL); CREATE TABLE entries(id TEXT PRIMARY KEY,slot TEXT NOT NULL,recipeId TEXT NOT NULL REFERENCES recipes(id)); CREATE TABLE metadata(key TEXT PRIMARY KEY,value TEXT NOT NULL);INSERT INTO metadata VALUES('seeded','1');`); const r={id:'mine',name:'Receita guardada',image:'https://example.com/image.jpg',ingredients:'100 g de arroz',preparation:'Cozer.'}; old.prepare('INSERT INTO recipes VALUES(?,?,?,?,?)').run(...Object.values(r)); old.prepare('INSERT INTO entries VALUES(?,?,?)').run('planned','2026-9-7:1','mine');old.close(); let app,url; const start=async()=>{app=createApp({dataDir:dir});await new Promise(r=>app.listen(0,'127.0.0.1',r));url=`http://127.0.0.1:${app.address().port}/api/`;}; const stop=()=>new Promise(r=>app.close(r)); const call=async(path,method='GET',data)=>{const response=await fetch(url+path,{method,headers:{'Content-Type':'application/json'},body:data?JSON.stringify(data):undefined});return {status:response.status,data:await response.json()};}; try{ await start();let state=(await call('state')).data; assert.deepEqual(state.recipes,[r]);assert.equal(state.entries[0].recipeId,'mine'); const changed={...r,name:'Receita editada',ingredients:'200 g de arroz'}; assert.equal((await call('recipes/mine','PUT',{...changed,previous:r})).status,200); assert.equal((await call('recipes/mine','PUT',{...r,previous:r})).status,409); assert.equal((await call('recipes/mine','PUT',{...changed,name:'',previous:changed})).status,400); const product={week:'2026-9-7',key:'arroz|g',name:'arroz',quantity:300,unit:'g',removed:false}; const manual={...product,key:'manual:milk',name:'leite',unit:'l',quantity:2}; assert.equal((await call('shopping','PUT',product)).status,200); assert.equal((await call('shopping','PUT',manual)).status,200); assert.equal((await call('shopping','PUT',{...product,quantity:-2})).status,400); assert.equal((await call('shopping','PUT',{...product,week:'2026-9-8'})).status,400); await call('shopping','PUT',{...product,week:'2026-9-14',removed:true}); await stop();await start();state=(await call('state')).data; assert.deepEqual(state.recipes,[changed]);assert.equal(state.entries.length,1);assert.equal(state.shoppingOverrides.length,3); const base=[{key:'arroz|g',name:'arroz',unit:'g',quantity:200,occurrences:1,recipes:['Receita editada']}]; const rows=applyShoppingOverrides(base,state.shoppingOverrides,'2026-9-7'); assert.equal(rows.find(r=>r.name==='arroz').quantity,300);assert.equal(rows.find(r=>r.name==='leite').quantity,2); assert.deepEqual(applyShoppingOverrides(base,state.shoppingOverrides,'2026-9-14'),[]); assert.equal((await call('shopping','DELETE',product)).status,200); state=(await call('state')).data; assert.equal(applyShoppingOverrides(base,state.shoppingOverrides,'2026-9-7').find(r=>r.name==='arroz').quantity,200); }finally{if(app?.listening)await stop();rmSync(dir,{recursive:true,force:true});} });