That doesn't define a D1 database for the `dev` env, fwiw

K

kianOP•4/5/24, 9:48 PM

That shouldn't matter for Pages though

Kkian That doesn't define a D1 database for the `dev` env, fwiw

M

Marcel Overdijk•4/5/24, 9:57 PM

@adjlsncm and if you try something like:

npx wrangler d1 execute audition --command "SELECT * FROM _some_table_;" --local

npx wrangler d1 execute audition --command "SELECT * FROM _some_table_;" --local

npx wrangler d1 execute audition --command "SELECT * FROM _some_table_;" --local

npx wrangler d1 execute audition --command "SELECT * FROM _some_table_;" --local does that work?

J

James•4/5/24, 10:08 PM

Browsers generally make 2 requests when they hit a page - one for the page itself, and then one for

/favicon.ico

/favicon.ico

/favicon.ico

/favicon.ico

J

James•4/5/24, 10:09 PM

checking the URL is generally a good solution

const url = new URL(request.url);
if (url.pathname === '/something') {
   // do your work
}

const url = new URL(request.url);
if (url.pathname === '/something') {
   // do your work
}

const url = new URL(request.url);
if (url.pathname === '/something') {
   // do your work
}

const url = new URL(request.url);
if (url.pathname === '/something') {
   // do your work
}

J

James•4/5/24, 10:09 PM

Or if you're doing something more complex, using a router like https://hono.dev/ or https://itty.dev/itty-router/ is recommended

M

Marcel Overdijk•4/5/24, 10:10 PM

or ceate a

_routes.json

_routes.json

_routes.json

_routes.json like:

{
    "version": 1,
    "include": ["/api/*"],
    "exclude": ["/*.*"]
}

{
    "version": 1,
    "include": ["/api/*"],
    "exclude": ["/*.*"]
}

{
    "version": 1,
    "include": ["/api/*"],
    "exclude": ["/*.*"]
}

{
    "version": 1,
    "include": ["/api/*"],
    "exclude": ["/*.*"]
}

J

James•4/5/24, 10:12 PM

_routes

_routes

_routes

_routes is Pages specific, not for Workers generically, but yes

MMarcel Overdijk Not sure if that is relates, as locally it works

M

Marcel Overdijk•4/5/24, 10:12 PM

I tried many things, but my build cannot be deployed anymore unfortunately...
Is there some more detailed logging available? e.g. in the dashboard?

A

adjlsncm•4/5/24, 10:39 PM

if anybody has any suggestions to fixing it please do tag me

A

adjlsncm•4/5/24, 11:25 PM

okay this is ridiculous but i guess i figured it out

A

adjlsncm•4/5/24, 11:26 PM

the DB binding is in process.env not in some env parameter passed to the request

A

adjlsncm•4/5/24, 11:28 PM

i feel like the docs should make it clear if you're using next-pages anything related to requests and routes in local should access env via the process always even though the docs say otherwise

A

adjlsncm•4/5/24, 11:28 PM

i got stuck on something similar before where it ended up being the docs saying env should be accessed a specific way but it just ended up being process.env always

Aadjlsncm okay this is ridiculous but i guess i figured it out

B

bun•4/5/24, 11:30 PM

@adjlsncm there's also

getRequestContext

getRequestContext

getRequestContext

getRequestContext for next on pages, idk how you haven't stumbled upon it

B

bun•4/5/24, 11:31 PM

I think

getRequestContext

getRequestContext

getRequestContext

getRequestContext is for prod environment specifically, but it also should work on local if im not mistaken

A

adjlsncm•4/5/24, 11:31 PM

sorry but i dont know what that is

A

adjlsncm•4/5/24, 11:31 PM

i will look into it

B

bun•4/5/24, 11:32 PM

it gives

.env

.env

getRequestContext().env

getRequestContext().env

getRequestContext().env

getRequestContext().env and couple of other cloudflare related things, such as city and country of the request origin

A

adjlsncm•4/5/24, 11:34 PM

oh okay

A

adjlsncm•4/5/24, 11:34 PM

thank you ill try that out

B

bun•4/5/24, 11:34 PM

https://arc.net/l/quote/rxcxsouy

Quote from “next-on-pages/packages/next-on-pages at main · cloudfla...

A

adjlsncm•4/6/24, 1:14 AM

i made some changes to my prisma schema, how do i migrate/sync the local D1 DB with these changes?

Aadjlsncm i made some changes to my prisma schema, how do i migrate/sync the local D1 DB w...

B

bun•4/6/24, 2:55 AM

prisma db push

B

bun•4/6/24, 2:55 AM

Or make migrations

B

bun•4/6/24, 2:56 AM

And then wrangler d1 migrations apply

V

Voids•4/6/24, 9:00 AM

how would I have my worker communicate wit my d1 database Im so confused

VVoids how would I have my worker communicate wit my d1 database Im so confused

M

Max (@rozenmd)•4/6/24, 9:05 AM

I'd recommend going through this guide end-to-end https://developers.cloudflare.com/d1/get-started/

Cloudflare Docs

Get started · Cloudflare D1 docs

This guide will instruct you through:

MMax (@rozenmd)I'd recommend going through this guide end-to-end https://developers.cloudflare....

V

Voids•4/6/24, 9:07 AM

ive tried, genuinly but Its so hard for me to understand

M

Max (@rozenmd)•4/6/24, 9:07 AM

that's alright - what part are you stuck on?

MMax (@rozenmd)that's alright - what part are you stuck on?

V

Voids•4/6/24, 9:08 AM

ok so I think this might actually be a worker issue, when I try to submit from my site I get a cors error

V

Voids•4/6/24, 9:09 AM

index.html:1 Access to XMLHttpRequest at 'https://messaging.logodzip18.workers.dev/' from origin 'http://127.0.0.1:3002' has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource.

VVoids index.html:1 Access to XMLHttpRequest at 'https://messaging.logodzip18.workers.d...

M

Max (@rozenmd)•4/6/24, 9:14 AM

ah welcome to CORS: https://developer.mozilla.org/en-US/docs/Web/HTTP/CORS

in short, the browser rejects requests from domain A to domain B, if domain B doesn't send headers authorising those requests

MDN Web Docs

Cross-Origin Resource Sharing (CORS) - HTTP | MDN

Cross-Origin Resource Sharing (CORS) is an HTTP-header based mechanism that allows a server to indicate any origins (domain, scheme, or port) other than its own from which a browser should permit loading resources. CORS also relies on a mechanism by which browsers make a "preflight" request to the server hosting the cross-origin resource, in ord...

M

Max (@rozenmd)•4/6/24, 9:16 AM

you can modify the example here to get your Worker to send cors headers: https://developers.cloudflare.com/workers/examples/cors-header-proxy/

Cloudflare Docs

CORS header proxy · Cloudflare Workers docs

Documentation for Cloudflare Workers, a serverless execution environment that allows you to create entirely new applications or augment existing ones …

V

Voids•4/6/24, 9:17 AM

I did this tho

V

Voids•4/6/24, 9:18 AM

addEventListener('fetch', event => {
  event.respondWith(handleRequest(event.request));
});

async function handleRequest(request) {
  if (request.method === 'POST') {
    // Parse form data from the request
    const formData = await request.formData();
    const user = formData.get('User');
    const quote = formData.get('Quote');
    const date = parseInt(formData.get('date'));
    const visibility = parseInt(formData.get('visibility'));

    // Send data to D1 database
    const response = await fetch('https://quote.logozip18.workers.dev/', {
      method: 'POST',
      headers: {
        'Content-Type': 'application/json',
      
        'Access-Control-Allow-Origin': '*', 
        'Access-Control-Allow-Methods': 'POST',
        'Access-Control-Allow-Headers': 'Content-Type',
      },
      body: JSON.stringify({ user, quote, date, visibility }),
    });

    if (response.ok) {
      return new Response('Data submitted successfully!', { status: 200 });
    } else {
      return new Response('Error submitting data to database', { status: 500 });
    }
  } else {
    return new Response('Method not allowed', { status: 405 });
  }
}

addEventListener('fetch', event => {
  event.respondWith(handleRequest(event.request));
});

async function handleRequest(request) {
  if (request.method === 'POST') {
    // Parse form data from the request
    const formData = await request.formData();
    const user = formData.get('User');
    const quote = formData.get('Quote');
    const date = parseInt(formData.get('date'));
    const visibility = parseInt(formData.get('visibility'));

    // Send data to D1 database
    const response = await fetch('https://quote.logozip18.workers.dev/', {
      method: 'POST',
      headers: {
        'Content-Type': 'application/json',
      
        'Access-Control-Allow-Origin': '*', 
        'Access-Control-Allow-Methods': 'POST',
        'Access-Control-Allow-Headers': 'Content-Type',
      },
      body: JSON.stringify({ user, quote, date, visibility }),
    });

    if (response.ok) {
      return new Response('Data submitted successfully!', { status: 200 });
    } else {
      return new Response('Error submitting data to database', { status: 500 });
    }
  } else {
    return new Response('Method not allowed', { status: 405 });
  }
}

addEventListener('fetch', event => {
  event.respondWith(handleRequest(event.request));
});

async function handleRequest(request) {
  if (request.method === 'POST') {
    // Parse form data from the request
    const formData = await request.formData();
    const user = formData.get('User');
    const quote = formData.get('Quote');
    const date = parseInt(formData.get('date'));
    const visibility = parseInt(formData.get('visibility'));

    // Send data to D1 database
    const response = await fetch('https://quote.logozip18.workers.dev/', {
      method: 'POST',
      headers: {
        'Content-Type': 'application/json',
      
        'Access-Control-Allow-Origin': '*', 
        'Access-Control-Allow-Methods': 'POST',
        'Access-Control-Allow-Headers': 'Content-Type',
      },
      body: JSON.stringify({ user, quote, date, visibility }),
    });

    if (response.ok) {
      return new Response('Data submitted successfully!', { status: 200 });
    } else {
      return new Response('Error submitting data to database', { status: 500 });
    }
  } else {
    return new Response('Method not allowed', { status: 405 });
  }
}

addEventListener('fetch', event => {
  event.respondWith(handleRequest(event.request));
});

async function handleRequest(request) {
  if (request.method === 'POST') {
    // Parse form data from the request
    const formData = await request.formData();
    const user = formData.get('User');
    const quote = formData.get('Quote');
    const date = parseInt(formData.get('date'));
    const visibility = parseInt(formData.get('visibility'));

    // Send data to D1 database
    const response = await fetch('https://quote.logozip18.workers.dev/', {
      method: 'POST',
      headers: {
        'Content-Type': 'application/json',
      
        'Access-Control-Allow-Origin': '*', 
        'Access-Control-Allow-Methods': 'POST',
        'Access-Control-Allow-Headers': 'Content-Type',
      },
      body: JSON.stringify({ user, quote, date, visibility }),
    });

    if (response.ok) {
      return new Response('Data submitted successfully!', { status: 200 });
    } else {
      return new Response('Error submitting data to database', { status: 500 });
    }
  } else {
    return new Response('Method not allowed', { status: 405 });
  }
}

VVoids ```js addEventListener('fetch', event => { event.respondWith(handleRequest(eve...

M

Max (@rozenmd)•4/6/24, 9:23 AM

its not your D1 request thats failing - it's the request to this Worker

M

Mozzy•4/6/24, 2:12 PM

Just posting for visibility https://x.com/TablePlus/status/1776612840285286655

TablePlus (@TablePlus) on X

Hey @CloudflareDev @Cloudflare you're using the https protocol for the D1, however the result for rows is a key-value.

Which is not good, for example, D1 API failed to display this result:

select 1 as a, 2 as a;

Because key-value does not support two column with the same name.

Twitter

•

4/6/24, 2:08 PM

J

Jadugar_Jaggu•4/6/24, 2:56 PM

I am trying to import a sql db to D1 which I exported from cpanel ( phpmyadmin) . I am getting this error

near "SET": syntax error at offset 196 [code: 7500]

near "SET": syntax error at offset 196 [code: 7500]

near "SET": syntax error at offset 196 [code: 7500]

near "SET": syntax error at offset 196 [code: 7500]

I used command

wrangler d1 execute 10Database --file=database.sql

wrangler d1 execute 10Database --file=database.sql

wrangler d1 execute 10Database --file=database.sql

wrangler d1 execute 10Database --file=database.sql

JJadugar_Jaggu I am trying to import a sql db to D1 which I exported from cpanel ( phpmyadmin) ...

A

arch•4/6/24, 2:56 PM

What was the database you exported from? I'm assuming MySQL/Mariadb?

Aarch What was the database you exported from? I'm assuming MySQL/Mariadb?

J

Jadugar_Jaggu•4/6/24, 2:57 PM

MySql Database

That doesn't define a D1 database for the `dev` env, fwiw

Similar Threads

Similar Threads

Similar Threads