No d1 reference in NUXT 3 application.

Original message was deleted

《

Hi,
I have been following this documentation, and instead of using a kv binding, I'm attempting to use a d1 binding.
https://developers.cloudflare.com/pages/framework-guides/deploy-a-nuxt-site/
wrangler 3.28.1
Nuxt 3.10.1

The problem is, I do not see the DB reference coming through on the event.context. I feel like I have following the instructions, and what I'm attempting it quite straight forward.

I have a server function
/server/api/demo/record.get.ts

export default defineEventHandler((event) => {
    const db = event.context.DB
    console.log('context ',db);  // undefined 
    console.log('event.context',event.context) // object returned, no DB
    var posts: Post[];
    
        posts = [
            { id: 1, title: 'Post 1', body: 'This is the body of post 1' },
            { id: 2, title: 'Post 2', body: 'This is the body of post 2' },
            { id: 3, title: 'Post 3', body: 'This is the body of post 3' },
        ]
    return posts; // I see the posts returned status code 200
})

export default defineEventHandler((event) => {
    const db = event.context.DB
    console.log('context ',db);  // undefined 
    console.log('event.context',event.context) // object returned, no DB
    var posts: Post[];
    
        posts = [
            { id: 1, title: 'Post 1', body: 'This is the body of post 1' },
            { id: 2, title: 'Post 2', body: 'This is the body of post 2' },
            { id: 3, title: 'Post 3', body: 'This is the body of post 3' },
        ]
    return posts; // I see the posts returned status code 200
})

/wrangler.toml

[[d1_databases]]
binding = "DB" # i.e. available in your Worker on env.DB
database_name = "demo"
database_id = "[guid]"
preview_database_id = "DB"

[[d1_databases]]
binding = "DB" # i.e. available in your Worker on env.DB
database_name = "demo"
database_id = "[guid]"
preview_database_id = "DB"

I have been able to use wrangler to run SQL scripts against the database, the database does exist locally, and in the cloud. So the DB itself seems fine. It is just the problem of the context not wiring up.

I used the create Cloudflare CLI to create the project.
It uses these to commands to run.

/package.json

"pages:dev": "wrangler pages dev --compatibility-date=2024-02-08 --proxy 3000 --d1=demo -- npm run dev",
    "pages:deploy": "npm run build && wrangler pages deploy ./dist"

"pages:dev": "wrangler pages dev --compatibility-date=2024-02-08 --proxy 3000 --d1=demo -- npm run dev",
    "pages:deploy": "npm run build && wrangler pages deploy ./dist"

Am I missing something here?

export default defineEventHandler((event) => { const db = event.context.DB console.log('context ',db); // undefined console.log('event.context',event.context) // object returned, no DB var posts: Post[]; posts = [ { id: 1, title: 'Post 1', body: 'This is the body of post 1' }, { id: 2, title: 'Post 2', body: 'This is the body of post 2' }, { id: 3, title: 'Post 3', body: 'This is the body of post 3' }, ] return posts; // I see the posts returned status code 200 })

No d1 reference in NUXT 3 application.

Similar Threads

Similar Threads

Similar Threads