also by API do you mean, `import { createDb } from 'wrangler/d1'`, or an HTTP API?

MMax (@rozenmd)also by API do you mean, `import { createDb } from 'wrangler/d1'`, or an HTTP AP...

M

meow•2/5/23, 2:27 PM

An HTTP API

Mmeow An HTTP API

M

Max (@rozenmd)OP•2/5/23, 2:30 PM

we might ask you more questions later on - I'd be keen to make our HTTP APIs on the same level as wrangler

M

Max (@rozenmd)OP•2/5/23, 2:30 PM

at the moment it's unstable/API can change without warning, but that's what wrangler uses under the hood

MMax (@rozenmd)yes, just don't know when

S

Sameer Ali•2/6/23, 7:46 AM

Right now, to connect with db, we are adding binding to

wrangler.toml

wrangler.toml

, when we create db using

wrangler/d1

wrangler/d1

wrangler/d1

wrangler/d1 will there be option to make connection to db real time?

U

Unsmart•2/6/23, 5:13 PM

It's in public alpha so it's not GA / ready for production but can be used by anyone

C

charl.dev•2/6/23, 7:27 PM

what's the

wrangler dev

wrangler dev

cmd to use the d1 preview db again? When running --local or --persist, it still uses the main db

C

charl.dev•2/6/23, 7:36 PM

but there is the preview_database_id, is that not supported?

Original message was deleted

C

charl.dev•2/6/23, 7:37 PM

when running wrangler dev, everything else like KV points to the preview ids, but d1 points to the prod id

C

charl.dev•2/6/23, 7:38 PM

so was just trying to understand if it could point to the preview d1 id, like --d1=908908..

C

charl.dev•2/6/23, 7:39 PM

2.2.4, ill update and try

C

charl.dev•2/6/23, 7:45 PM

on 2.9.0

wrangler dev

wrangler dev

lists both the database_id and preview_database_id

bit confusing, but ill test if its actually using the preview. Thanks Skye

Ccharl.dev but there is the preview_database_id, is that not supported?

M

Max (@rozenmd)OP•2/7/23, 7:21 AM

i'm working on that

M

Max (@rozenmd)OP•2/7/23, 7:22 AM

you'll be able to run migrations against preview with the

--preview

--preview

--preview

--preview flag

K

kian•2/7/23, 9:30 AM

I’d assume it’s in Miniflare

K

kian•2/7/23, 9:30 AM

pages dev uses that

K

kian•2/7/23, 9:31 AM

Your issue seems to be fixed going based off this code & the commit message https://github.com/cloudflare/miniflare/commit/2d0fbc624bfa46a31f6c47f342a96ce7fdddebd2

GitHub

Implement `D1Database` using D1JS and D1 API (#480) · cloudflare/mi...

Previously, Miniflare had its own implementations of

BetaDatabase

BetaDatabase

BetaDatabase

BetaDatabase
and

Statement

Statement

Statement

Statement. These were subtly different to the implementations
in the D1 Wrangler shim D1JS, causing behaviour mismatches....

K

kian•2/7/23, 9:31 AM

But I doubt Wrangler’s dependency on Miniflare has been bumped since

K

kian•2/7/23, 9:40 AM

Hey! This should've been fixed by #480, and will be released soon. I'd like to include #486 in this, so just waiting until that's approved.

K

kian•2/7/23, 9:40 AM

M

Max (@rozenmd)OP•2/7/23, 12:22 PM

anyone aware of anything that'll generate TypeScript types for d1 tables?

M

Max (@rozenmd)OP•2/7/23, 12:22 PM

like any community projects etc

M

Max (@rozenmd)OP•2/7/23, 12:58 PM

i think we might write a quick util that generates a types definition file based on a current db's state

M

Max (@rozenmd)OP•2/7/23, 12:58 PM

with options to point at local/preview/prod

K

kian•2/7/23, 12:59 PM

M

Max (@rozenmd)OP•2/7/23, 1:00 PM

dunno, I don't use prisma

TTom Sherman there's also https://github.com/rmp135/sql-ts

M

Max (@rozenmd)OP•2/7/23, 1:13 PM

ooh neat

K

kian•2/7/23, 1:21 PM

K

kian•2/7/23, 1:21 PM

K

kian•2/7/23, 1:21 PM

sentenced to 1 week of working on #

workers-rs

M

Max (@rozenmd)OP•2/7/23, 1:22 PM

i might actually have to learn rust to keep working on d1's api and worker

CCSirolli I'm working with d1 in pages. When preparing a statement, is it possible to use ...

M

Max (@rozenmd)OP•2/7/23, 3:14 PM

Does something like this work (move the

%

% into

.bind

.bind

.bind

.bind)?

const { results } = await c.env.DB.prepare(
    'select * from spaces where title like ?'
)
    .bind(`%${title}%`)
    .all();

const { results } = await c.env.DB.prepare(
    'select * from spaces where title like ?'
)
    .bind(`%${title}%`)
    .all();

const { results } = await c.env.DB.prepare(
    'select * from spaces where title like ?'
)
    .bind(`%${title}%`)
    .all();

const { results } = await c.env.DB.prepare(
    'select * from spaces where title like ?'
)
    .bind(`%${title}%`)
    .all();

CCSirolli I figured out a way to just use numbered parameters, and I still get the same er...

M

Max (@rozenmd)OP•2/7/23, 3:53 PM

SELECT UniqueID, ParentID, Contact, Cellphone, Email 
FROM contacts 
WHERE UniqueID LIKE ?1 
  OR ParentID LIKE ?1 
  OR Contact LIKE ?1 
  OR Cellphone LIKE ?1 
  OR Email LIKE ?1 
ORDER BY ?2 
LIMIT ?3, ?4

SELECT UniqueID, ParentID, Contact, Cellphone, Email 
FROM contacts 
WHERE UniqueID LIKE ?1 
  OR ParentID LIKE ?1 
  OR Contact LIKE ?1 
  OR Cellphone LIKE ?1 
  OR Email LIKE ?1 
ORDER BY ?2 
LIMIT ?3, ?4

SELECT UniqueID, ParentID, Contact, Cellphone, Email 
FROM contacts 
WHERE UniqueID LIKE ?1 
  OR ParentID LIKE ?1 
  OR Contact LIKE ?1 
  OR Cellphone LIKE ?1 
  OR Email LIKE ?1 
ORDER BY ?2 
LIMIT ?3, ?4

SELECT UniqueID, ParentID, Contact, Cellphone, Email 
FROM contacts 
WHERE UniqueID LIKE ?1 
  OR ParentID LIKE ?1 
  OR Contact LIKE ?1 
  OR Cellphone LIKE ?1 
  OR Email LIKE ?1 
ORDER BY ?2 
LIMIT ?3, ?4

Did you mean

LIMIT ?3 OFFSET ?4

LIMIT ?3 OFFSET ?4

LIMIT ?3 OFFSET ?4

LIMIT ?3 OFFSET ?4?

M

Max (@rozenmd)OP•2/7/23, 4:09 PM

Oh, I guess it is:

M

Max (@rozenmd)OP•2/7/23, 4:10 PM

is this with

--local

--local

btw?

also by API do you mean, `import { createDb } from 'wrangler/d1'`, or an HTTP API?

Similar Threads

Similar Threads

Similar Threads