Theo's Typesafe Cult•14mo ago

Prisma middleware infinite loop

Hey 👋 I have a separate table in my db that's responsible for storing logs of actions. I want to simplify the dx by creating a Prisma middleware that will automatically create these logs. This is my current implementation:

prisma.$use(async (params, next) => {
    const { model, action } = params;

    if (model === 'Todo' && (action === 'create')) {
        await prisma.logEntry.create({
            data: {
                type: 'CREATED_TODO',
                user: {
                    connect: {
                        id: params.args.data.userId
                    }
                }
            }
        });
    }

    return next(params);
});

prisma.$use(async (params, next) => {
    const { model, action } = params;

    if (model === 'Todo' && (action === 'create')) {
        await prisma.logEntry.create({
            data: {
                type: 'CREATED_TODO',
                user: {
                    connect: {
                        id: params.args.data.userId
                    }
                }
            }
        });
    }

    return next(params);
});

However, I'd like to improve this to be batching these db calls into one prisma.$transaction():

const result = await prisma.$transaction([
    prisma.todo.create(params.args),
    prisma.logEntry.create({
        data: {
            type: 'CREATED_TODO',
            user: {
                connect: {
                    id: params.args.data.userId
                }
            }
        }
    })
]);

const result = await prisma.$transaction([
    prisma.todo.create(params.args),
    prisma.logEntry.create({
        data: {
            type: 'CREATED_TODO',
            user: {
                connect: {
                    id: params.args.data.userId
                }
            }
        }
    })
]);

However, this causes an infinite loop, because prisma.todo.create() calls the middleawre again. Any suggestions on how to get around this?

0 Replies

No replies yetBe the first to reply to this messageJoin

Gaming

Programming

Prisma middleware infinite loop