Unable to setup prisma accelerate with cloudflare workers
index.tsindex.tsimport { PrismaClient } from '@prisma/client/edge';
import { withAccelerate } from '@prisma/extension-accelerate';
export default {
async fetch(request, env, ctx): Promise<Response> {
const prisma = new PrismaClient().$extends(withAccelerate());
console.log(env);
const user = await prisma.user.findMany({
where: {
email: {
contains: 'alice@prisma.io',
},
},
cacheStrategy: { swr: 60, ttl: 60 },
});
console.log(user);
return new Response('Hello World!');
},
} satisfies ExportedHandler<Env>;import { PrismaClient } from '@prisma/client/edge';
import { withAccelerate } from '@prisma/extension-accelerate';
export default {
async fetch(request, env, ctx): Promise<Response> {
const prisma = new PrismaClient().$extends(withAccelerate());
console.log(env);
const user = await prisma.user.findMany({
where: {
email: {
contains: 'alice@prisma.io',
},
},
cacheStrategy: { swr: 60, ttl: 60 },
});
console.log(user);
return new Response('Hello World!');
},
} satisfies ExportedHandler<Env>;.env.envDATABASE_URL="prisma accelerate api key"
DIRECT_URL="database uri string"
wrangler.tomlwrangler.tomlname = "app2"
main = "src/index.ts"
compatibility_date = "2024-07-01"
compatibility_flags = ["nodejs_compat"]
[vars]
DATABASE_URL = "prisma accelerate api key"name = "app2"
main = "src/index.ts"
compatibility_date = "2024-07-01"
compatibility_flags = ["nodejs_compat"]
[vars]
DATABASE_URL = "prisma accelerate api key"schema.prismaschema.prismagenerator client {
provider = "prisma-client-js"
}
datasource db {
provider = "postgresql"
url = env("DATABASE_URL")
directUrl = env("DIRECT_URL")
}
model User {
id Int @id @default(autoincrement())
email String @unique
name String?
}generator client {
provider = "prisma-client-js"
}
datasource db {
provider = "postgresql"
url = env("DATABASE_URL")
directUrl = env("DIRECT_URL")
}
model User {
id Int @id @default(autoincrement())
email String @unique
name String?
}I am getting following error when I hit the server
Invalid `prisma.user.findMany()` invocation: error: Environment variable not found: DATABASE_URL. In Cloudflare module Workers, environment variables are available only in the Worker's `env` parameter of `fetch`. To solve this, provide the connection string directly: https://pris.ly/d/cloudflare-datasource-urlInvalid `prisma.user.findMany()` invocation: error: Environment variable not found: DATABASE_URL. In Cloudflare module Workers, environment variables are available only in the Worker's `env` parameter of `fetch`. To solve this, provide the connection string directly: https://pris.ly/d/cloudflare-datasource-urlWhat is going wrong here?
