Cloudflare Developers•2y ago

I will, thanks. Any quick way to change string types to null?

_tweak^prone•4/19/24, 9:21 AM

If "description" is just a zero ("0") as text, you will save "null" in the database.

VVikash I will, thanks. Any quick way to change string types to null?

_tweak^prone•4/19/24, 9:23 AM

campaign.description === undefined ? null : campaign.description

campaign.description === undefined ? null : campaign.description

or make a wrapper function

function bindWrap( ...args)

function bindWrap( ...args)

that does it for you

__tweak^prone `campaign.description === undefined ? null : campaign.description` or make a wr...

VikashOP•4/19/24, 9:24 AM

Awesome, thanks.

luna•4/19/24, 9:26 AM

i want to take my remote db and use it locally, is there a wrangler command for this? i couldnt find anything in the docs.

Lluna i want to take my remote db and use it locally, is there a wrangler command for ...

_tweak^prone•4/19/24, 9:36 AM

add --remote and you can use the remote database in your dev env

__tweak^prone add --remote and you can use the remote database in your dev env

luna•4/19/24, 9:51 AM

what if im using next js?

Lluna what if im using next js? 🤔

_tweak^prone•4/19/24, 10:29 AM

here you go

https://community.cloudflare.com/t/nextjs-pages-application-with-d1-bindings/595958

arsengoian•4/19/24, 5:40 PM

Hi everyone. Strings are truncated of any whitespace characters while inserting or updating columns of any type (varchar, binary). Is this intended behaviour? How do I insert a string that ends with a space? I can run the same in an sqlite3 database and the space is preserved.

Hannes•4/19/24, 7:48 PM

Hi, when exporting a D1 Database with

wrangler d1 export

wrangler d1 export

, the SQL file cannot be imported again using

wrangler d1 execute --file ...

wrangler d1 execute --file ...

, because in the sql the tables are being created in the wrong order. That results in logs of

no such table

no such table

error messages because

CONSTRAINT FOREIGN KEYS

CONSTRAINT FOREIGN KEYS

come before the respective

CREATE TABLE

CREATE TABLE

...
Is that a bug?

Ggeelen can you send me the chunk of SQL that shows the statements in the wrong order?

Hannes•4/19/24, 8:58 PM

Sure, thanks for looking into this. I'll send you a DM. Or should I create a GitHub Issue?

__tweak^prone `campaign.description === undefined ? null : campaign.description` or make a wr...

森

森@VerseLink (RW)•4/20/24, 2:34 AM

wouldn't

campaign.description ?? null

campaign.description ?? null

work the same but more concise and easy to read?

yellott•4/20/24, 6:02 AM

Hi there, is there any recommended workflow on D1 migration to reduce/eliminate downtime? Maybe something CF specific, wasn't able to find anything related in the docs.