LockProvider for Mongo usingDbTime()

[jaquinod]

Dears team,

I am using ShedLock with MongoDB.
I had seen that it exists a feature to use db time for Postgres, MySQL, MariaDb, MS SQL, Oracle, DB2, HSQL and H2

=> Could you in the future add this feature for mongo please ? making usingDbTime() available :-)

Many thanks in advance,

Best Regards,
Eddy from France

[lukas-krecan]

Hi, thanks for the proposal. The trouble is that AFAIK, Mongo does not support date arithmetics. In SQL, I can say lock_until = now() + 5 minutes, I don't think it's possible to do this in Mongo, or is it? Without that, I can't implement it.

[jaquinod]

Hi Lukas, Thank you for your reply, I can say that in mongo 5 for example it exists $dateAdd to increment a date https://www.mongodb.com/docs/manual/reference/operator/aggregation/dateAdd/ Hope it could help you, Many thanks in advance to keep this feature for mongo in mind for the days you can have a solution :-) ShedLock is a usefull tool for my need in all the cases and for many others users I think:-) " Le jeu. 29 août 2024 à 20:45, Lukáš Křečan ***@***.***> a écrit :

…

Hi, thanks for the proposal. The trouble is that AFAIK, Mongo does not support date arithmetics. In SQL, I can say lock_until = now() + 5 minutes, I don't think it's possible to do this in Mongo, or is it? Without that, I can't implement it. — Reply to this email directly, view it on GitHub <#2116 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACBFU74CUSDHOOSVFHSAPWDZT5T5HAVCNFSM6AAAAABNIJVPSGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDGMJYGYYTEMJXGA> . You are receiving this because you authored the thread.Message ID: ***@***.***>

-- Bien Cordialement, *Eddy JAQUINOD*

[lukas-krecan]

Cool, I will try it

[lukas-krecan]

Hi, I looked into that and there is one thing I don't know how to solve. Here, I need to write $lte(lockUntil, NOW) and I dont know how to send NOW from Java. In Mongo console, you can use Date(), but I don't think it's possible to use from Java. There is currentTimestamp function, but it can only be used to set value of a field. Any ideas how to do that? (I haven't used Mongo in years).

[jaquinod]

Hi Lukas, First of all, thank you for trying to implement my request. Usually, mongo has "$currentDate" for date coming from mongo's server : https://www.mongodb.com/docs/manual/reference/operator/update/currentDate/ Perhaps, this stackoverflow's following links could help you : https://stackoverflow.com/questions/28986034/mongo-insert-currentdate-in-java-driver Sometimes, I had seen that it could exists "$$NOW" as mongo system variable : https://www.mongodb.com/docs/manual/reference/aggregation-variables/#mongodb-variable-variable.NOW => This link is about that variable : https://stackoverflow.com/questions/20620368/is-there-any-equivalent-of-now-in-mongodb Many thanks in advance to you for taking time with me for trying to find a solution Best Regards Eddy from France Le mer. 4 sept. 2024 à 21:12, Lukáš Křečan ***@***.***> a écrit :

…

Hi, I looked into that and there is one thing I don't know how to solve. Here <https://github.com/lukas-krecan/ShedLock/pull/2129/files#diff-c61729a62e6580eea84ea3df5ac67683a3d7fd2540e9092a635d3377e7e3a050R96>, I need to write $lte(lockUntil, NOW) and I dont know how to send NOW from Java. In Mongo console, you can use Date(), but I don't think it's possible to use from Java. There is currentTimestamp function, but it can only be used to set value of a field. Any ideas how to do that? (I haven't used Mongo in years). — Reply to this email directly, view it on GitHub <#2116 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACBFU74DWUP3EN44IRHUKHDZU5LRLAVCNFSM6AAAAABNIJVPSGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDGMRZG44TANBVGY> . You are receiving this because you authored the thread.Message ID: ***@***.***>

-- Bien Cordialement, *Eddy JAQUINOD*