CC
A
S
SS
A
J
DA
BC
C
M
wrangler.tomlawait db.exec("PRAGMA table_list")
U[vars]d1_databases
- KV Namespaces:
....
- D1 Databases:
- MYDATABASE_DB: mydbinmydashboard (74244d9f-afa8-4ca2-ab7f-XXXXXX)
- Vars:
.....MCCCCMM
EMEMdb.batchUPSERTON CONFLICT
MEdb.batch console.log("we start the new DB");
try {
console.log("we start the new DB test 1");
await env.DBNAME_DB.prepare(`insert into messages (location_id,time_stamp,status,customer_dismiss) values (?,?,?,?)`).bind(restaurant_token_used, timestamp_index, 'new', 0).run()
console.log("we start the new DB test 2");
} catch (e) {
console.log("we start the new DB test 3");
console.log({
message: e.message,
cause: e.cause.message,
});
}
console.log("we end the new DB");d1_databases = [
{ binding = "name", ... }
]
[vars]
hello = "world"[vars]
hello = "world"
d1_databases = [
{ binding = "name", ... }
]var coolio200 = await env.MYDATABASE_DB.exec("PRAGMA table_list")
console.log("here is coolio100")
console.log("here is coolio200: " + JSON.stringify(coolio200))- KV Namespaces:
....
- D1 Databases:
- MYDATABASE_DB: mydbinmydashboard (74244d9f-afa8-4ca2-ab7f-XXXXXX)
- Vars:
.....export default {
async fetch(request, env, ctx) {
let res = await env.MYDATABASE.exec("PRAGMA table_list")
console.log(res)
return Response.json({res: res})
},
};