Desivdo | 1
const Database = require('better-sqlite3'); const db = new Database('./db/database.sqlite'); db.exec(fs.readFileSync('./db/schema.sql','utf8'));
const createItem = (title, description) => const stmt = db.prepare('INSERT INTO items (title, description) VALUES (?, ?)'); const info = stmt.run(title, description); return getItemById(info.lastInsertRowid); ; Create an Express app with routes under /api/items. desivdo 1
router.post('/', (req,res) => !title.trim()) return res.status(400).json(error: 'Title required'); const item = createItem(title.trim(), description ); Static single-page interface using vanilla JS. const Database = require('better-sqlite3'); const db = new
async function fetchItems() const res = await fetch('/api/items'); const items = await res.json(); render(items); const Database = require('better-sqlite3')
const request = require('supertest'); const app = require('../index'); // express app