scy on Nostr: create table status ( "timestamp" integer not null primary key default (unixepoch()), ...
create table status (
"timestamp" integer not null primary key default (unixepoch()),
"status" text not null
) strict, without rowid;
while sleep 60; do
curl --data-raw '{"zipCode":"12345"}' -H 'Content-Type: application/json' -H 'Accept: application/json' https:/
/wannkommt.rewe.de/api/delivery/B-BCD-8EF-6GH > rewe.json && sqlite3 rewe.sqlite "insert into status (status) values (json(readfile('rewe.json')));"
done
"timestamp" integer not null primary key default (unixepoch()),
"status" text not null
) strict, without rowid;
while sleep 60; do
curl --data-raw '{"zipCode":"12345"}' -H 'Content-Type: application/json' -H 'Accept: application/json' https:/
/wannkommt.rewe.de/api/delivery/B-BCD-8EF-6GH > rewe.json && sqlite3 rewe.sqlite "insert into status (status) values (json(readfile('rewe.json')));"
done