f19f4e90-2514-4f2f-9d09-13ece5212673 is down. I really need it back for my presentation at uni tomorrow. Is there a time frame? or should I make another?
_QUEUE?.send(payload) done right after the query that changes the game based on user location. Do queues have locations too?sqlite3 mydb.sqlite .dump > db.sql and then import with wrangler d1 execute podcast-stats-prod --file=db.sql but I get not authorized [code: 7500] error. not authorized gets thrown by the runtime when an sql command we haven't allow-listed gets used - look for things like pragma statementsPRAGMA foreign_keys=OFF; is the first lineBEGIN TRANSACTION; and the end of it, we're already running in a transaction for you (i'll also update the docs to mention that)COMMIT;const D1URL = 'https://api.cloudflare.com/client/v4/accounts/4f6d1970bc967b2c2a90b643bbb5ac94/d1/database/0e35121-f3cc-4e24-b5c1-4d758860a69d/query';
const insertStatement = `INSERT INTO table (c1, c2, c3) VALUES (v1, v2, v3)`;
const options = {
method: 'POST',
headers: {
'Content-Type': 'application/json',
Authorization: 'Bearer GAQjclxUayPOaHhn5Nx1CGdyN2Pt08COkmFTFBjm'
},
body: JSON.stringify({
sql: insertStatement
})
}
fetch(D1URL, options)
.then( res => res.json())
.then( data => console.log(data))f19f4e90-2514-4f2f-9d09-13ece5212673"result": {
"success": true,
"meta": {
"served_by": "v3-prod",
"duration": 0.1743,
"changes": 0,
"last_row_id": 0,
"changed_db": false,
"size_after": 25100288,
"rows_read": 1804,
"rows_written": 0
},
"results": [
{
"COUNT(*)": 1804
}
]_QUEUE?.send(payload)sqlite3 mydb.sqlite .dump > db.sqlwrangler d1 execute podcast-stats-prod --file=db.sqlnot authorized [code: 7500]not authorizedpragmaPRAGMA foreign_keys=OFF;BEGIN TRANSACTION;COMMIT;BEGIN TRANSACTION;
CREATE TABLE _cf_KV (
key TEXT PRIMARY KEY,
value BLOB
) WITHOUT ROWID;