I'm trying to run multiple migration/sql files on a D1 database. Is there a way I can have access to

I'm trying to run multiple migration/sql files on a D1 database. Is there a way I can have access to the D1 binding from inside a script (so I can read sql files and execute sql into D1)? Without being a "module worker" or "service worker"

Mikyari•8/24/23, 8:23 AM

Is procedure is available to use in D1 for now?

Mikyari•8/24/23, 8:23 AM

I did not see it in docs, but only this article: https://blog.cloudflare.com/whats-new-with-d1/

The Cloudflare Blog

D1: our quest to simplify databases

Get an inside look on the D1 experience today, what the team is currently working on and what’s coming up!

BBen-xD I'm trying to run multiple migration/sql files on a D1 database. Is there a way ...

advanced•8/24/23, 8:59 AM

you can try cfw-bindings-wrangler-bridge or the latest version of miniflare with getBindings api

BBen-xD I'm trying to run multiple migration/sql files on a D1 database. Is there a way ...

chientrm.com•8/24/23, 9:00 AM

https://github.com/chientrm/wrangler-proxy

Ssourabh.sashank Database Id: 08c3458c-812d-48bf-801d-5a87b4649f49 Not opening in dashboard, con...

Max (@rozenmd)•8/24/23, 9:09 AM

looks like an overloaded db using the old backend, would recommend the new backend

Ssourabh.sashank Can't we upgrade the same DB to be using new backend ?

Max (@rozenmd)•8/24/23, 10:35 AM

You'll need to export your database: https://developers.cloudflare.com/d1/learning/backups/#downloading-a-backup-locally
and import it into a new database running on the new backend: https://developers.cloudflare.com/d1/learning/importing-data/#import-an-existing-database

James•8/25/23, 1:06 AM

What does your worker look like? It has to be in modules format to use D1 from that error: https://developers.cloudflare.com/workers/learning/migrate-to-module-workers/

Migrate to ES modules format · Cloudflare Workers docs

This guide will show you how to migrate your Workers from the Service Worker format to the ES modules format.

SStar Bright I migrated it but now I'm getting ```js errors: [ { code: 10021, ...

Matt Silverlock•8/25/23, 7:08 AM

Make sure you’re uploading it as a module Worker.

SStar Bright I migrated it but now I'm getting ```js errors: [ { code: 10021, ...

Matt Silverlock•8/25/23, 7:09 AM

d1-database

chientrm.com•8/25/23, 12:31 PM

No.1 reason why I love D1?
Because I'm an SQL fetish.

rob•8/26/23, 12:19 AM

D1 bindings require module-format workers. [code: 10021]

rob•8/26/23, 12:19 AM

What do i need to do in my wrangler ?

Rrob What do i need to do in my wrangler ?

itsmatteomanf•8/26/23, 12:45 AM

Read the conversation just above

d1-database

rob•8/26/23, 1:04 AM

hey i fixed it! now im having an issue

rob•8/26/23, 1:05 AM

[[d1_databases]]
binding = "clickDB" # i.e. available in your Worker on env.clickDB
database_name = "click-db"
database_id = "XXXXXXXX"

[[d1_databases]]
binding = "clickDB" # i.e. available in your Worker on env.clickDB
database_name = "click-db"
database_id = "XXXXXXXX"

rob•8/26/23, 1:05 AM

I deploy and it says my worker has access to - D1 Databases:
- clickDB: click-db

rob•8/26/23, 1:05 AM

I get this error tho: TypeError: env.clickDB.put is not a function

Rrob I get this error tho: TypeError: env.clickDB.put is not a function

itsmatteomanf•8/26/23, 1:06 AM

Because it's not

itsmatteomanf•8/26/23, 1:06 AM

Read the docs.
https://developers.cloudflare.com/d1/platform/client-api/

D1 client API · Cloudflare D1 docs

As part of our Client API, both static and prepared statements are supported. Best practice is to use prepared statements which are precompiled …

rob•8/26/23, 1:06 AM

rob•8/26/23, 1:06 AM

rob•8/26/23, 1:07 AM

got it

chientrm.com•8/26/23, 8:50 AM

Although I only have 12 users registered,
How would you recommend me to implement Snowflake Ids with multiple D1 databases binded?

chientrm.com•8/26/23, 8:51 AM

Replace Worker IDWorker ID with DatabaseIdDatabaseId?

Cchientrm.com Although I only have 12 users registered, How would you recommend me to implemen...

Matt Silverlock•8/26/23, 11:22 AM

Generate it in your app at insert time? Do you want to use it as the primary key column?

MMatt Silverlock Generate it in your app at insert time? Do you want to use it as the primary key...

chientrm.com•8/26/23, 11:32 AM

yes.

chientrm.com•8/26/23, 11:36 AM

so there are

timestamp

timestamp

, worker_idworker_id and sequence_idsequence_id.
Because sequence_idsequence_id is autoincrement and reset to 0 when it touch the highest value 40964096 (12 bits).

chientrm.com•8/26/23, 11:36 AM

I can't find an sql function implementation for snowflake_id(worker_id)snowflake_id(worker_id)

chientrm.com•8/26/23, 11:38 AM

and idk how to