That's expected, as `description` is optional fields, so I need to insert `null` if no value provide

That's expected, as

description

description

is optional fields, so I need to insert

null

null

if no value provided.

Otherwise D1 throws an error

VVikash That's expected, as `description` is optional fields, so I need to insert `null`...

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

you misunderstand.

the string "0""0" is not "no value"

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

I am using

||

||

on string type fields only

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

"0" == false"0" == false, therefore "0" || null"0" || null is

null

null

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

on Boolean type, I am using like this campaign.is_enabled ? 1 : 0campaign.is_enabled ? 1 : 0

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

You should read up on truthy / falsy

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

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.descriptioncampaign.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 exportwrangler 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 tableno such table error messages because CONSTRAINT FOREIGN KEYSCONSTRAINT 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 ?? nullcampaign.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.