L
googleUser.email and use that in your INSERT.
���Lbatch(), but your second INSERT should do a nested SELECT to figure out the user ID that was added in the first insert.nanoid() into a local variable before you create your statements, and use that in both queries. Isn't that nanoid what you want in the second insert or is it an autoincrement key?���L
.get().then((res) => res?.id!) part needs the query to actually run I imagine. I am not familiar with this framework you are using for constructing your queries.
JJ
O
�L��
DL
.wrangler
If things break, you can clean up and reset by deleting those files.D
D199187a5c9948d6a9eaef3ee19490fb5eec30c2012c4b4101aaeb362f07f1d3e.sqliteD
Cwrangler d1 execute —local <query> https://developers.cloudflare.com/workers/wrangler/commands/#execute
DDDD
MMMM
B
ZMM
D
K
L
sql.exec() interface.
AA
Dwrangler pages deploy --branch $BITBUCKET_BRANCH to deploy a preview environment and wrangler d1 migrations apply --remote --env preview to apply the migrations to the preview db. that's awesome and pretty easy. however, all the preview envs share the same database, so how should I handle two PRs making db changes? or another very common use case: I start my PR with a single db change, but after PR reviews, I want to add/remove changes from the migration.rm -rf ./.wrangler/state/v3/d1 and re-apply the migrations from main
A
P
P
PPPD
JA
googleUser.emailbatch()nanoid()await sharedDB.batch([
sharedDB.insert(usersTable).values({
publicId: nanoid(),
name: googleUser.name,
email: googleUser.email
}).onConflictDoNothing()
.returning(),
sharedDB.insert(oauthAccountsTable).values({
providerId: "google",
providerUserId: googleUser.sub,
userId: await sharedDB.select({ id: usersTable.id }).from(usersTable).where(eq(usersTable.email, googleUser.email)).get().then((res) => res?.id!),
})
]).get().then((res) => res?.id!)199187a5c9948d6a9eaef3ee19490fb5eec30c2012c4b4101aaeb362f07f1d3e.sqlitewrangler d1 execute —local <query>sql.exec()wrangler pages deploy --branch $BITBUCKET_BRANCHwrangler d1 migrations apply --remote --env previewrm -rf ./.wrangler/state/v3/d1