Cloudflare DevelopersCD
Cloudflare Developers•2y ago
Taylor

Working with D1 Remote DB locally with nextjs

So i'm using Cloudflare D1, I imported data into my remote Cloudflare D1 database, i didn't do this for the --local one and i don't really want to if possible. I want to just locally develop with the remote database. I have my binding setup and i created an API route like this 
import type { NextRequest } from "next/server";
import { getRequestContext } from "@cloudflare/next-on-pages";
import { cases } from "@/schema";
import { CloudflareEnv } from "@/env";
import { db } from "@/db";

export const runtime = "edge";

export async function GET(request: NextRequest, env: CloudflareEnv) {
  const context = getRequestContext();

  const DB = db((context.env as CloudflareEnv).edendb);

  const result = await DB.select({
    CaseID: cases.CaseID,
    CasePriority: cases.CasePriority,
    CaseStatus: cases.CaseStatus,
    Pending: cases.Pending,
    Active: cases.Active,
    Closed: cases.Closed,
    NotReviewed: cases.NotReviewed,
  }).from(cases);

  return new Response(JSON.stringify(result), {
    status: 200,
    headers: {
      "Content-Type": "application/json",
    },
  });
}


I deployed the site with pnpm run deploy

everythings good and when i go to the live url/api/getallcases route,

it works just as expected. But in local development I get a 
✘ [ERROR] Error: D1_ERROR: no such table: Cases



I know this has something to do with the local vs remote database but I can't seem to figure out how to develop against it with Nextjs, could anyone help? I've gotten this error with both pnpm run dev (nextjs server) and pnpm wrangler pages dev
Was this page helpful?