M
SSMSSM
M
CC
/query/batch endpoint exists for the worker because it calls the .batch method through the Workers API. All of the endpoints in the worker are just ways to access the Workers API bindingsSSCS
PS
I
MS
U
D1_DUMP_ERROR: Status + 404 when I call that endpointU
SSPM
MMSSCSSC
KSSKCP
Y
. I need help accessing tables in databases. I have created a database and binded it to my worker through workers.toml file. But when I make a search in a particular table, it gives "no such table" error. Here is an image of tables in my database, "Customers" is just for test purposes.
Y
app.get('/posts/:lang/:slug/comments', async c => {
const { results } = await c.env.comDB.prepare();
return c.text(results, 200);
}Y
YC
—local flag
ICIIY
/query/batch.batchMaximum arguments per SQL function 32D1_DUMP_ERROR: Status + 404INSERT INTO 'tablename' ('column1', 'column2') VALUES
('data1', 'data2'),
('data3', 'data4'),
('data5', 'data6'),
('data7', 'data8');`app.get('/posts/:lang/:slug/comments', async c => {
const { results } = await c.env.comDB.prepare();
return c.text(results, 200);
}—localINSERT INTO table (channel, title, start_time, end_time, description) VALUES (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?);INSERT INTO table (channel, title, start_time, end_time, description) VALUES (?, ?, ?, ?, ?);
INSERT INTO table (channel, title, start_time, end_time, description) VALUES (?, ?, ?, ?, ?);
INSERT INTO table (channel, title, start_time, end_time, description) VALUES (?, ?, ?, ?, ?); --data '{
"params": [
"a",
"b",
"c",
"d",
"e",
"a2",
"b2",
"c2",
"d2",
"e2"
],
"sql": "INSERT INTO myTable (f1, f2, f3, f4, f5) VALUES (?, ?, ?, ?, ?), (?, ?, ?, ?, ?);"
}'const dump = await c.env.DB.dump();
return new Response(dump, {
status: 200,
headers: {
'Content-Type': 'application/octet-stream',
'Content-Disposition': 'attachment; filename="sqlite.db"',
}
});