how would I write a jest test that sets values in d1 manualy before running fetch tests?

SStronk how would I write a jest test that sets values in d1 manualy before running fetc...

M

https://developers.cloudflare.com/d1/learning/local-development/#test-programmatically

D1 has fully-featured support for local development, running the same version of D1 as Cloudflare runs globally. Local development uses Wrangler, the …

S

StronkOP•8/13/23, 1:25 AM

Ah so I can use the execsync function to just run the commands through wrangler cli

Llll-QWQ My D1 don't seems to work only with "wrangler dev"

J

Jure•8/13/23, 10:04 AM

I found this tutorial very helpful:
https://sat0shi.dev/posts/drizzle-intro/
Especially to understand how to use D1 for local development and how migrations work.

Type-Safely Access Cloudflare D1 with Drizzle ORM

Looking for a ORM to access Cloudflare D1 in a type-safe manner? Look no further than Drizzle ORM!

CCole Xemi I'm having an issue with wrangler version 3.5.0. With that version my worker can...

J

James•8/13/23, 9:20 PM

I'd recommend filing an issue at https://github.com/cloudflare/workers-sdk with a reproduction

CCole Xemi I'm having an issue with wrangler version 3.5.0. With that version my worker can...

A

Adi•8/14/23, 1:17 AM

What is the binding name of the variable you're using? A few of us had problems with 3.5.0 when it came out.
Maybe check the yet to be released changelog and see if it's suggestions solve your problem - https://github.com/cloudflare/cloudflare-docs/pull/10298/files

Tldr, if your binding name used the prefix -

__D1_BETA__

__D1_BETA__

__D1_BETA__

__D1_BETA__ it won't work anymore

CCole Xemi My binding variable was called `DB`

A

Adi•8/14/23, 1:30 AM

Right, ok then I have no clue haha.
Btw is the issue you made

3756

3756? You likely want to give a bit more detail. A minimal reproduction repository is key.

M

Matt Silverlock•8/14/23, 2:59 PM

FYI: you can now bind D1 databases to Workers and Pages projects directly via the dashboard. More details here: https://developers.cloudflare.com/d1/changelog/#bind-d1-from-the-cloudflare-dashboard

Changelog · Cloudflare D1 docs

You can now bind a D1 database to your Workers directly in the Cloudflare dashboard . To bind D1 from the Cloudflare dashboard, select your Worker …

C

chientrm.com•8/14/23, 6:18 PM

do we have transaction?

B

Behunin•8/14/23, 9:37 PM

I am getting

Error: D1_ERROR: RangeError: Too many parameter values were provided

Error: D1_ERROR: RangeError: Too many parameter values were provided

Error: D1_ERROR: RangeError: Too many parameter values were provided

Error: D1_ERROR: RangeError: Too many parameter values were provided with a query that had 24 values

B

Behunin•8/14/23, 9:37 PM

The docs say the limit is 100

B

Behunin•8/14/23, 9:38 PM

Did I miss something?

K

kika•8/14/23, 11:56 PM

I'm trying to add a column to the database with

alter table

alter table

alter table

alter table and it fails with

Error code 23: Authorization denied

Error code 23: Authorization denied

Error code 23: Authorization denied

Error code 23: Authorization denied. Reading the table works. Tried both through wranger and through the web console. I'm the only admin in the org, there's noone more powerful. Any ideas?

BBehunin I am getting `Error: D1_ERROR: RangeError: Too many parameter values were provid...

M

Matt Silverlock•8/15/23, 12:34 AM

Are you using the new backend? Refer to https://developers.cloudflare.com/d1/changelog/#new-default-storage-subsystem for how to check

Changelog · Cloudflare D1 docs

You can now bind a D1 database to your Workers directly in the Cloudflare dashboard . To bind D1 from the Cloudflare dashboard, select your Worker …

Kkika I'm trying to add a column to the database with `alter table` and it fails with ...

M

Matt Silverlock•8/15/23, 12:34 AM

What specific

ALTER TABLE

ALTER TABLE

ALTER TABLE

ALTER TABLE statement are you trying to run? (Post the query)

Kkika I'm trying to add a column to the database with `alter table` and it fails with ...

M

Matt Silverlock•8/15/23, 12:41 AM

For clarity, all of this works per our tests: https://github.com/cloudflare/workerd/blob/26f0498e303eead759ab4ca9f8767841618eace7/src/workerd/api/sql-test.js#L630-L660

GitHub

workerd/src/workerd/api/sql-test.js at 26f0498e303eead759ab4ca9f876...

The JavaScript / Wasm runtime that powers Cloudflare Workers - cloudflare/workerd

MMatt Silverlock What specific `ALTER TABLE` statement are you trying to run? (Post the query)

K

kika•8/15/23, 12:42 AM

alter table emailsignups add column source TEXT CHECK(source IN ('A','B'));

alter table emailsignups add column source TEXT CHECK(source IN ('A','B'));

alter table emailsignups add column source TEXT CHECK(source IN ('A','B'));

alter table emailsignups add column source TEXT CHECK(source IN ('A','B'));

K

kika•8/15/23, 12:42 AM

it works with

--local

--local

K

kika•8/15/23, 12:43 AM

assuming the local sqlite engine is the same as "remote"

K

kika•8/15/23, 12:43 AM

very recent, lemme check

K

kika•8/15/23, 12:44 AM

wrangler usually tells me that it's up for update

K

kika•8/15/23, 12:44 AM

3.5.0

K

kika•8/15/23, 12:45 AM

whooops

K

kika•8/15/23, 12:45 AM

so quazi-enums are verboten?

K

kika•8/15/23, 12:46 AM

appreciate it

Ggeelen i happened to be exactly inside that test right now so easy for me to dig

M

Matt Silverlock•8/15/23, 12:50 AM

Probably need to authorize that + allow the associated

PRAGMA ignore_check_constraints

PRAGMA ignore_check_constraints

PRAGMA ignore_check_constraints

PRAGMA ignore_check_constraints

? https://www.sqlite.org/pragma.html#pragma_ignore_check_constraints
- https://www.sqlite.org/lang_createtable.html#check_constraints

S

StronkOP•8/15/23, 7:39 AM

whats the best way to deal with inserting an entry that may have a value or may need to take the default value

S

StronkOP•8/15/23, 7:43 AM

sure, so I have this table:

CREATE TABLE lines (
    lineNum INT IDENTITY(1,1) NOT NULL UNIQUE,
    lineCreator INT NOT NULL,
    lineImage TEXT NOT NULL DEFAULT 'https://maps.lineonline.app/line_default.png',
    lineName VARCHAR(100) NOT NULL,
    lineDescription TEXT,
    lineType VARCHAR(100) NOT NULL,
    permanent BOOLEAN NOT NULL,
    lineEndTime DATETIME NOT NULL,
    lineStartTime DATETIME NOT NULL,
    lineInPersonBuffer INT NOT NULL DEFAULT 5,
    -- -1 = auto based on average time per person and adjusted by number of misses
    lineNumberOfRetries INT NOT NULL DEFAULT 3,
    lineTimeoutOfRetryEligibilityMins INT NOT NULL DEFAULT 61,

    PRIMARY KEY (lineNum)
);

CREATE TABLE lines (
    lineNum INT IDENTITY(1,1) NOT NULL UNIQUE,
    lineCreator INT NOT NULL,
    lineImage TEXT NOT NULL DEFAULT 'https://maps.lineonline.app/line_default.png',
    lineName VARCHAR(100) NOT NULL,
    lineDescription TEXT,
    lineType VARCHAR(100) NOT NULL,
    permanent BOOLEAN NOT NULL,
    lineEndTime DATETIME NOT NULL,
    lineStartTime DATETIME NOT NULL,
    lineInPersonBuffer INT NOT NULL DEFAULT 5,
    -- -1 = auto based on average time per person and adjusted by number of misses
    lineNumberOfRetries INT NOT NULL DEFAULT 3,
    lineTimeoutOfRetryEligibilityMins INT NOT NULL DEFAULT 61,

    PRIMARY KEY (lineNum)
);

CREATE TABLE lines (
    lineNum INT IDENTITY(1,1) NOT NULL UNIQUE,
    lineCreator INT NOT NULL,
    lineImage TEXT NOT NULL DEFAULT 'https://maps.lineonline.app/line_default.png',
    lineName VARCHAR(100) NOT NULL,
    lineDescription TEXT,
    lineType VARCHAR(100) NOT NULL,
    permanent BOOLEAN NOT NULL,
    lineEndTime DATETIME NOT NULL,
    lineStartTime DATETIME NOT NULL,
    lineInPersonBuffer INT NOT NULL DEFAULT 5,
    -- -1 = auto based on average time per person and adjusted by number of misses
    lineNumberOfRetries INT NOT NULL DEFAULT 3,
    lineTimeoutOfRetryEligibilityMins INT NOT NULL DEFAULT 61,

    PRIMARY KEY (lineNum)
);

CREATE TABLE lines (
    lineNum INT IDENTITY(1,1) NOT NULL UNIQUE,
    lineCreator INT NOT NULL,
    lineImage TEXT NOT NULL DEFAULT 'https://maps.lineonline.app/line_default.png',
    lineName VARCHAR(100) NOT NULL,
    lineDescription TEXT,
    lineType VARCHAR(100) NOT NULL,
    permanent BOOLEAN NOT NULL,
    lineEndTime DATETIME NOT NULL,
    lineStartTime DATETIME NOT NULL,
    lineInPersonBuffer INT NOT NULL DEFAULT 5,
    -- -1 = auto based on average time per person and adjusted by number of misses
    lineNumberOfRetries INT NOT NULL DEFAULT 3,
    lineTimeoutOfRetryEligibilityMins INT NOT NULL DEFAULT 61,

    PRIMARY KEY (lineNum)
);

S

StronkOP•8/15/23, 7:43 AM

and I may or may not want to provide for example lineNumberOfRetries

S

StronkOP•8/15/23, 7:44 AM

this is determined by the json a client application sends

S

StronkOP•8/15/23, 7:44 AM

for example I can check if I have a field with

insFields.hasOwnProperty('lineImage')

insFields.hasOwnProperty('lineImage')

insFields.hasOwnProperty('lineImage')

insFields.hasOwnProperty('lineImage')

how would I write a jest test that sets values in d1 manualy before running fetch tests?

Similar Threads

Similar Threads

Similar Threads