"apply:preview": "npx is-ci && npx wrangler d1 migrations apply db --preview"
"apply:preview": "npx is-ci && npx wrangler d1 migrations apply db --preview"
J
Mnpx wrangler d1 execute job-hunt-db --local --persist-to /tmp/job-hunt-tmp-data --command="SELECT * FROM TargetRoleAnalysis"MMWRANGLER_LOG=debug npx wrangler d1 migrations apply db --preview and DM me the result? npx is-ci && shouldn't be necessary in GH Actions
E
HE
EJM
--persist-to in every command you use if you customise it
T
U
ITUT
A
D
number[]s in line 227-230I
TSELECT * FROM TABLE_NAME returns an empty array, whereas I can see the actual data (not empty) on my CF dashboard, and I can query the records correctly using npx wrangler d1 execute site-db --command="SELECT * FROM TABLE_NAME"
Tnpx @cloudflare/next-on-pagesTT They weren't joking when they said cf discord was incredibly active and helpful
Rwrangler commands to use a D1 binding in a next-on-pages application if calling setupDevPlatform in nextConfig?R
BBB
CM
M
FIM
O
MD
CREATE TABLE query: https://developers.cloudflare.com/api/operations/cloudflare-d1-query-databaseWU
UWWWMMW
JJ
Enpx wrangler d1 execute job-hunt-db --local --persist-to /tmp/job-hunt-tmp-data --command="SELECT * FROM TargetRoleAnalysis"WRANGLER_LOG=debug npx wrangler d1 migrations apply db --previewnpx is-ci &&--persist-tonumber[]// This code lives inside a route.tsx file running locally with:
// npm run pages:preview -- --d1 DB=xxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxxx
// console.log(await env.DB.prepare(`pragma table_info(TABLE_NAME)`).all());
{
success: true,
meta: {
served_by: 'miniflare.db',
// ...
},
results: [
{
cid: 0,
name: 'id',
type: 'INT AUTO_INCREMENT',
notnull: 0,
dflt_value: null,
pk: 1
},
{
cid: 1,
name: 'url',
type: 'VARCHAR(2048)',
notnull: 1,
dflt_value: null,
pk: 0
},
// ...
// ...SELECT * FROM TABLE_NAMEnpx wrangler d1 execute site-db --command="SELECT * FROM TABLE_NAME"[[d1_databases]]
binding = "DB" # i.e. available in your Worker on env.DB
database_name = "site-db"
database_id = "xxxxxxxxxx-xxxx-xxxx-xxxxxxxxxxx"
preview_database_id = "DB"npm run pages:build && wrangler pages dev .vercel/output/static --compatibility-date=2024-01-17 --compatibility-flag=nodejs_compat --d1 DB=xxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxnpx @cloudflare/next-on-pageswranglersetupDevPlatformnextConfig createdAt: integer("created_at").notNull().default(sql`CURRENT_TIMESTAMP`),CREATE TABLE createdAt: integer("created_at", { mode: "timestamp" })
.notNull()
.default(sql`(unixepoch())`),