M
RM
AAAAMMM
V
HV
HH
.csv exports from D1 database and Worker is running "out of resources" while trying to process that data (expected). So my current plan is to make node server that will dump it without any limitations and provide final csv file.
PD1_ERROR: Network connection lost.. The cron executes every minute. * * * * *. Is it expected to get those errors from time to time? I wasn't really monitoring that worker before so I don't know how long it's been happening, in the last 24 hours it only happened 5 times so it's not a big deal for me either (since the worker execute every minute). Just wondering if there may be something I'm doing wrong that's causing these errors.
KKKK
_
大
V
undefined as null I think, otherwise we have to use value || null for each field. For example, the description throw an error when undefined_undefined would have any relation to null. You would need to handle these specifically yourself.|| operator works on falsy/truthy. null, NaN, 0, "" and undefined would all end as null in your example above._"" or "0" null.V
description is optional fields, so I need to insert null if no value provided._"0" is not "no value"V|| on string type fields only_"0" == false, therefore "0" || null is nullVcampaign.is_enabled ? 1 : 0_
V__campaign.description === undefined ? null : campaign.descriptionfunction bindWrap( ...args)V
L
_L_
A
H
wrangler d1 export, the SQL file cannot be imported again using wrangler d1 execute --file ..., because in the sql the tables are being created in the wrong order. That results in logs of no such table error messages because CONSTRAINT FOREIGN KEYS come before the respective CREATE TABLE...H
postgres=# INSERT INTO foo VALUES ('bar');
INSERT 0 1
postgres=# INSERT INTO foo VALUES ('bar') RETURNING *;
bar
-----
bar
(1 row)
INSERT 0 1.csvD1_ERROR: Network connection lost.* * * * *undefinedundefinedundefinedundefinednullnullnullnullnullnullnullvalue || null await env.DB.prepare(
`UPDATE Campaigns SET name = ?, description = ? WHERE campaign_id = ?`
)
.bind(
campaign.name,
campaign.description || null,
campaign.campaign_id
)
.run();||||NaN0"""""0""0"description"0" == false"0" || nullcampaign.is_enabled ? 1 : 0campaign.description === undefined ? null : campaign.descriptionfunction bindWrap( ...args)wrangler d1 exportwrangler d1 execute --file ...no such tableCONSTRAINT FOREIGN KEYSCREATE TABLEimport { Miniflare } from 'miniflare'
import { PrismaD1 } from '@prisma/adapter-d1'
import { PrismaClient } from '@prisma/client'
export async function seedDatabase() {
const mf = new Miniflare({
modules: true,
script: '',
d1Databases: ['DB'],
})
let DB = await mf.getD1Database('DB')
const adapter = new PrismaD1(DB)
const prisma = new PrismaClient({ adapter })
// ... fill database with seed data procedurally
}