✘ [ERROR] FOREIGN KEY constraint failedPRAGMA foreign_keys = OFF;
DROP TABLE IF EXISTS Users;
DROP TABLE IF EXISTS Rooms;
DROP TABLE IF EXISTS Sessions;
PRAGMA foreign_keys = ON;
E
E
Anpx wrangler d1 migrations apply db due to which I can't apply migrations in my github actions workflow.Anpx wrangler d1 execute.A"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
T
U
ITUTA
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
RwranglersetupDevPlatform in nextConfig?R
BBB
CM
M
FIM
O
MD
CREATE TABLE query: https://developers.cloudflare.com/api/operations/cloudflare-d1-query-databaseWU
UWWWMnpx wrangler d1 migrations apply dbnpx wrangler d1 execute"apply:preview": "npx is-ci && npx wrangler d1 migrations apply db --preview"npx 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 &&number[]// 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-pagessetupDevPlatformnextConfig createdAt: integer("created_at").notNull().default(sql`CURRENT_TIMESTAMP`),CREATE TABLE createdAt: integer("created_at", { mode: "timestamp" })
.notNull()
.default(sql`(unixepoch())`),