D1 should consider `undefined` as `null` I think, otherwise we have to use `value || null` for each

D1 should consider

undefined

undefined

null

null

I think, otherwise we have to use

value || null

value || null

for each field. For example, the description throw an error when

undefined

undefined

 await env.DB.prepare(
    `UPDATE Campaigns SET name = ?, description = ? WHERE campaign_id = ?`
  )
    .bind(
      campaign.name,
      campaign.description || null,
      campaign.campaign_id
    )
    .run();

 await env.DB.prepare(
    `UPDATE Campaigns SET name = ?, description = ? WHERE campaign_id = ?`
  )
    .bind(
      campaign.name,
      campaign.description || null,
      campaign.campaign_id
    )
    .run();

 await env.DB.prepare(
    `UPDATE Campaigns SET name = ?, description = ? WHERE campaign_id = ?`
  )
    .bind(
      campaign.name,
      campaign.description || null,
      campaign.campaign_id
    )
    .run();

 await env.DB.prepare(
    `UPDATE Campaigns SET name = ?, description = ? WHERE campaign_id = ?`
  )
    .bind(
      campaign.name,
      campaign.description || null,
      campaign.campaign_id
    )
    .run();

VVikash D1 should consider `undefined` as `null` I think, otherwise we have to use `val...

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

that would seem a bit dangerous - its a specific assumption that

undefined

undefined

would have any relation to

null

null

. You would need to handle these specifically yourself.

Also please note,

||

||

operator works on falsy/truthy.

null

null

NaN

NaN

""

""

and

undefined

undefined

would all end as

null

null

in your example above.

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

In other words, if the description is

""

""

"0"

"0"

your SQL would save them as
```
null
```
```
null
```
.

__tweak^prone that would seem a bit dangerous - its a specific assumption that `undefined` wou...

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

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

null

null

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

on Boolean type, I am using like this

campaign.is_enabled ? 1 : 0

campaign.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.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.