48 lines
3.5 KiB
JavaScript
48 lines
3.5 KiB
JavaScript
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});}
|
|
});
|