IceAge2OnDVD
IceAge2OnDVD
Explore posts from servers
TtRPCTTCTheo's Typesafe CultDTDrizzle Team
PostsComments
DTDrizzle Team
Created by IceAge2OnDVD on 7/5/2023 in #help
Transaction rollback error catching
I'm using drizzle with TRPC and want my api to give detailed reasons for a rollback. However tx.rollback() throws a TransactionRollbackError, which means the TRPC error is never thrown (i think). This means the client sees an error with message "Rollback", which isn't super descriptive. 
await db.transaction(async (tx) => {
  ...some logic
  if (logicFails) {
    tx.rollback();
    throw new TRPCError({ code: "CONFLICT", message: "Detailed reason..." });
  }
});
await db.transaction(async (tx) => {
  ...some logic
  if (logicFails) {
    tx.rollback();
    throw new TRPCError({ code: "CONFLICT", message: "Detailed reason..." });
  }
});
Is it safe to catch the drizzle error inside of the transaction and throw a TRPC one instead? Im guessing so but just wanted to check. 
await db.transaction(async (tx) => {
  ...some logic
  if (logicFails) {
    try {
      tx.rollback();
    } catch (e) { };
    throw new TRPCError({ code: "CONFLICT", message: "Detailed reason..." });
  }
});
await db.transaction(async (tx) => {
  ...some logic
  if (logicFails) {
    try {
      tx.rollback();
    } catch (e) { };
    throw new TRPCError({ code: "CONFLICT", message: "Detailed reason..." });
  }
});
4 replies