M
M
M
.all() instead of .raw() M/query endpoint - maybe using .all is the fix?M
DM
idWHERE CenterId IN (‘1,2,3') MMexception caught in D1 core errors are due to the nature of the D1 alpha unfortunately
FFFF
M+(new Date())) into the db and get them back out
GM
npm i mongodb-data-api. There are 2 other projects in the npm registry using mongodb-data-api.
G
MGM
A
W
B
CREATE TABLE customers_data (
customer_id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT,
email TEXT,
phone TEXT,
gender TEXT CHECK(gender IN ('male', 'female'))
);
CREATE TABLE payments_data (
customer_id INTEGER,
transaction_date DATE,
payment_mode TEXT CHECK(payment_mode IN ('online', 'offline')),
payment_month DATE,
FOREIGN KEY (customer_id) REFERENCES customers_data(customer_id)
);M
S
USU
B
BB
.all().raw()/query.allWHERE CenterId IN (‘1,2,3')exception caught in D1 core+(new Date())npm i mongodb-data-apiCREATE TABLE customers_data (
customer_id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT,
email TEXT,
phone TEXT,
gender TEXT CHECK(gender IN ('male', 'female'))
);
CREATE TABLE payments_data (
customer_id INTEGER,
transaction_date DATE,
payment_mode TEXT CHECK(payment_mode IN ('online', 'offline')),
payment_month DATE,
FOREIGN KEY (customer_id) REFERENCES customers_data(customer_id)
);