R
M
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.* * * * *. 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
undefinednullvalue || null for each field. For example, the description throw an error when undefinedundefinednull|| operator works on falsy/truthy. nullNaN0"" and undefinednull"" or "0" null
description is optional fields, so I need to insert null"0" is not "no value"V|| on string type fields only_"0" == false, therefore "0" || null is nullcampaign.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
森
campaign.description ?? null work the same but more concise and easy to read?postgres=# INSERT INTO foo VALUES ('bar');
INSERT 0 1
postgres=# INSERT INTO foo VALUES ('bar') RETURNING *;
bar
-----
bar
(1 row)
INSERT 0 1.csv* * * * *value || null await env.DB.prepare(
`UPDATE Campaigns SET name = ?, description = ? WHERE campaign_id = ?`
)
.bind(
campaign.name,
campaign.description || null,
campaign.campaign_id
)
.run();||||"""""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 KEYScampaign.description ?? nullimport { 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
}