If you're developing locally, keep in mind that the data remotely (what you see in the cf dash) like
If you're developing locally, keep in mind that the data remotely (what you see in the cf dash) likely isn't what you have locally.
wrangler pages dev .svelte-kit/cloudflare --remote no support for --remote argswrangler d1 export i believewrangler d1 export YOUR_DB_NAME --output db.sql --remote && wrangler d1 execute YOUR_DB_BINDING_NAME --local --file db.sql
integer('id', { mode: 'timestamp' }) behaves in a similar way{"error":"Unauthorized, missing DB in environment"}
Error: D1_ERROR: Wrong number of parameter bindings for SQL query.date()--remote or --local with a recent version of wrangler?const timestamp = customType<
{ data: Date; driverData: string; }
>({
dataType() {
return 'text';
},
fromDriver(value: string): Date {
return new Date(value);
},
toDriver(value: Date): string {
try {
return value.toISOString();
} catch (e) {
console.log(`failed to covert ${JSON.stringify(value)} to iso string`)
throw e;
}
},
});select "id", "mem_type", "name", "email", "tickets_used", "tickets_remaining", "end_date" from "members" where
"members"."end_date" < date('now', '+? days')
AND "members"."end_date" > date('now', '+? days')
AND NOT EXISTS (
SELECT 1
FROM "emails"
WHERE "members"."id" = "emails"."mem_id"
AND "emails"."time_sent" < date('now', '-? days')
)
-- params: [7, 1, 7]