Using a specific client for addGraphileJobs library function.

[hillac]

Summary

Hi, just wondering if there is a way to add a job using a pre-existing client using the js library rather than the sql interface? I want to add jobs inside my own transactions. I've resorted to making my own addGraphileJob and addGraphileJobs that are otherwise the same as the originals, but the first arg is a pg PoolClient, which is used to make the query. I feel like I must be missing something because transactional job queuing is a huge benefit of using a postgres job queue.

Thanks.

Additional context

[benjie]

There's not currently an official API for that since whenever I've needed it I'm already in an SQL context so I just call the SQL function... But I'm not opposed to adding one. Maybe add it to WorkerUtils e.g. workerUtils.addJobWithClient(client, ...options) though that does require a pool to be available. If you only want it to work with the client then it's going to be a bit tougher as the methods required to produce compiledSharedOptions expect a pool, and those are needed to produce the escapedWorkerSchema/etc. Check out src/helpers.ts

[hillac]

So I'd need to make a new makeAddJobUtils (or something) that doesn't need a pool to instantiate, just schema name? Then addJobWithClient could be exposed from both workerUtils and addJobUtils?

I'm happy if it's just exposed from workerUtils, since I have a pool anyway, but it makes sense you should be able to access it without needing a pool.

[benjie]

Putting addJobWithClient on worker utils makes sense to me, ensures you can still do regular things like migrate whilst still allowing for transactional addJob 👍