mini-sql-db/ |--- lib/ | |--- storage.js # Creating JSON files to store data and run read/write operations | |--- schema.js # Table schema management and validation ...
CREATE PROCEDURE add_new_sale(@products) BEGIN INSERT INTO sales (time) VALUES (datetime('now')); SET @sale_id = last_insert_rowid(); FOREACH @prod_id, @qty, @price ...