Updating mysqlclient?

[sfayer]

Hi,

I've been trying to use the "mogrify" function on mysql cursors to get the expended version of a parameterised query for logging (DIRACGrid/DIRAC#8620), however it seems that feature was only added in mysqlclient >= 2.2.0.

I see that mysqlclient is pinned at <2.1 (and pulled from the diracgrid channel rather than conda-forge):

DIRACOS2/construct.yaml

Line 57 in 0abe6c8

- mysqlclient >=2.0.3,<2.1

I presume there is some kind of compatibility problem with 2.1 and higher? Is there any chance of being able to upgrade this or should I find a different approach to my logging?

Regards,
Simon

[sfayer]

I've looked at this some more and decided that this isn't necessary for the logging... I'll leave it open for comment anyway just in-case an upgrade is easy...

Regards,
Simon

[chrisburr]

The reason is: DIRACGrid/DIRAC#6978

I'd love to update it if we could.