K
Kysely•2mo ago
UV

Dynamic case when expression

I was struggling to figure out how to dynamically build a case expression. At the moment I've just got hardcoded for 6 indexes which doesn't seem like a good approach. 
export async function healParty(userId: string) {
  // Array of the user's party
  const partyBeasts = await getBeastParty(userId);
  const beastIds = partyBeasts.map((beast) => beast.id);
  
  await db
    .updateTable("beast")
    .set((eb) => ({
      currentHp: eb
        .case()
        .when("partyIndex", "=", 0)
        .then(partyBeasts.find((b) => b.partyIndex === 0)?.stats.maxHp)
        .when("partyIndex", "=", 1)
        .then(partyBeasts.find((b) => b.partyIndex === 1)?.stats.maxHp)
        .when("partyIndex", "=", 2)
        .then(partyBeasts.find((b) => b.partyIndex === 2)?.stats.maxHp)
        .when("partyIndex", "=", 3)
        .then(partyBeasts.find((b) => b.partyIndex === 3)?.stats.maxHp)
        .when("partyIndex", "=", 4)
        .then(partyBeasts.find((b) => b.partyIndex === 4)?.stats.maxHp)
        .when("partyIndex", "=", 5)
        .then(partyBeasts.find((b) => b.partyIndex === 5)?.stats.maxHp)
        .else(0)
        .end(),
    }))
    .where("userId", "=", userId)
    .where("id", "in", beastIds)
    .execute();
}
export async function healParty(userId: string) {
  // Array of the user's party
  const partyBeasts = await getBeastParty(userId);
  const beastIds = partyBeasts.map((beast) => beast.id);
  
  await db
    .updateTable("beast")
    .set((eb) => ({
      currentHp: eb
        .case()
        .when("partyIndex", "=", 0)
        .then(partyBeasts.find((b) => b.partyIndex === 0)?.stats.maxHp)
        .when("partyIndex", "=", 1)
        .then(partyBeasts.find((b) => b.partyIndex === 1)?.stats.maxHp)
        .when("partyIndex", "=", 2)
        .then(partyBeasts.find((b) => b.partyIndex === 2)?.stats.maxHp)
        .when("partyIndex", "=", 3)
        .then(partyBeasts.find((b) => b.partyIndex === 3)?.stats.maxHp)
        .when("partyIndex", "=", 4)
        .then(partyBeasts.find((b) => b.partyIndex === 4)?.stats.maxHp)
        .when("partyIndex", "=", 5)
        .then(partyBeasts.find((b) => b.partyIndex === 5)?.stats.maxHp)
        .else(0)
        .end(),
    }))
    .where("userId", "=", userId)
    .where("id", "in", beastIds)
    .execute();
}
Solution:
```ts await db .updateTable("beast") .set((eb) => { let caseBuilder: any = eb.case();...
Jump to solution
3 Replies
yayza_
yayza_•2mo ago
https://kyse.link/#cN4IgpgJglgLg9gJwM4gFyhgTwA5jSKAW20RgAJgAdAOzLIHExqwEBDGSAGhroGUwANmADGMVgCMh3WmQCq2COzASpPMgElqSFmMlhpAXzIAzBHEJlKIANaZtAzFYDcNGmAAeJBOSjUOCY1ZhMDIAEXYJVm0KNXFlJBhUMgAheJgAFRUwF2oDV2ZPUjJff0DglLTMvRiZKAgkxmY2DggAHmoAV0I4hAA+HLoO7QR1erIEhF8AcwGybFZvTE0IDyTO7pZZ4Q6EBCYYAAlsNa6e2cJWdyOTjYQcvOo3Qu8yLFwKqPIAXjJ+IVEsq1Up8qkJ+k8vOQ3iEAHJgADuwISZB+mmGuiEQMqWXBBUhrxwISRMHkig4KLkCiUgOJoLAuJAnBAAEcOixMPhhHAtOR5otiUgKQBtNTAYpjACMnDmCywy1WZAADNKEuwkEkxRcrscyBLFYqyEYDNI6GK6kkAEzSvly6grdxJKXjMQwdUUMha666i0Go0m93msgAZmtsqWdoVVudao1HsuXoAnL7Df6zWMACyhxbyh3BlUut2a+M6iV6w0p0XipIAViztvtSUz0ddsc9OoT1fLxsrgYAbHXww2yLXm4W49rHYrO36aABdHJcnlkOKfUaCn42zACgB0F2wAAp9yuEgBKFG9Zdpbd1E8L7nIoYsUYUqwS5z5Vjw1iwMgQcRqbcOipDg6X3KxjxgKwTwA7QYEPMBxDPL4LyoGQ6CEchhCiMBkg6KABBWBAklYahMApBDtyw7R91vfI6DoYxEDIfdF2RCCyDgYwZX5NIkDPVD6PoqicLwgiWApYTcPwwi1EEuht3hAALJgwJATccysaUrC+TTL0+bd1IjdxoLQuTtxgZTqCPK9VVdXdi1o0yHlksg9hgHZaAEuTtl2fYvUk0TCO3QRqMVE9grtGj-ToAxZgMEz5KUlgwFUx8RggXTtN0tLRgSsgFOUvZVLqTKCEeRk9ISNc8uC9wRA6DgaJyEBjRAaBWH+GB8BIBIpj2FAmVsewOXQEBoXwMQpkZEBqFYQg8FQEAADdFW3C0AA5t3WlqDCAA
Solution
yayza_
yayza_•2mo ago
await db
  .updateTable("beast")
  .set((eb) => {
    let caseBuilder: any = eb.case();

    for (const beast of partyBeasts) {
      caseBuilder = caseBuilder
        .when("partyIndex", "=", beast.partyIndex)
        .then(beast.stats.maxHp);
    }

    return {
      currentHp: caseBuilder.else(0).end(),
    };
  })
  .where("userId", "=", userId)
  .where("id", "in", beastIds)
  .execute();
await db
  .updateTable("beast")
  .set((eb) => {
    let caseBuilder: any = eb.case();

    for (const beast of partyBeasts) {
      caseBuilder = caseBuilder
        .when("partyIndex", "=", beast.partyIndex)
        .then(beast.stats.maxHp);
    }

    return {
      currentHp: caseBuilder.else(0).end(),
    };
  })
  .where("userId", "=", userId)
  .where("id", "in", beastIds)
  .execute();
UV
UVOP•2mo ago
Thanks that worked! so the any is necessary for it to work here?

Did you find this page helpful?