Simon Comments - Answer Overflow

Simon

Explore posts from servers

DDeno TtRPC TTCTheo's Typesafe Cult DTDrizzle Team

•Created by Simon on 2/8/2024 in #help

Alter type enum column ending in replace rather than alter

 Warning  Found data-loss statements:
· You're about to change type column type from enum('deposit','withdrawal','gameEntered','gameReward','inviteeReward') to enum('deposit','withdrawal','gameEntered','gameReward','inviteeReward','inviterReward') with 1973 items

THIS ACTION WILL CAUSE DATA LOSS AND CANNOT BE REVERTED

 Warning  Found data-loss statements:
· You're about to change type column type from enum('deposit','withdrawal','gameEntered','gameReward','inviteeReward') to enum('deposit','withdrawal','gameEntered','gameReward','inviteeReward','inviterReward') with 1973 items

THIS ACTION WILL CAUSE DATA LOSS AND CANNOT BE REVERTED

2 replies

DTDrizzle Team

•Created by Simon on 2/1/2024 in #help

ON DUPLICATE KEY UPDATE with bulk insert?

got it, can use something like this

  const insertResult = await db
    .insert(leaderboard)
    .values(allUsersWithData)
    .onDuplicateKeyUpdate({
      set: {
        invitesCount: sql`VALUES(invitesCount)`,
      },
    })

  const insertResult = await db
    .insert(leaderboard)
    .values(allUsersWithData)
    .onDuplicateKeyUpdate({
      set: {
        invitesCount: sql`VALUES(invitesCount)`,
      },
    })

3 replies

TtRPC

•Created by Simon on 1/16/2024 in #❓-help

v10, passing useQuery options, queryKey mandatory?

hm, anyways it seems to work now, maybe a restart of VS code. I will close as solved

5 replies

TtRPC

•Created by Simon on 1/16/2024 in #❓-help

v10, passing useQuery options, queryKey mandatory?

Oups, my mistake, I meant v11

    "@trpc/client": "11.0.0-next-beta.193",
    "@trpc/next": "11.0.0-next-beta.193",
    "@trpc/react-query": "11.0.0-next-beta.193",
    "@trpc/server": "11.0.0-next-beta.193",

    "@trpc/client": "11.0.0-next-beta.193",
    "@trpc/next": "11.0.0-next-beta.193",
    "@trpc/react-query": "11.0.0-next-beta.193",
    "@trpc/server": "11.0.0-next-beta.193",

5 replies

TTCTheo's Typesafe Cult

•Created by Simon on 1/16/2024 in #questions

serverCallback failing, receiving error on upload

ok so I was debugging in iOS simulator which caused the error. Once I used chrome or safari on my laptop it went away.

3 replies

Gaming

Programming