Page MenuHomePhabricator

Consider adding ability to convert Gravy IDs back & forth
Closed, ResolvedPublic

Description

I'm seeing that sometimes we have a base62 ID & sometimes a GUID and takes work to see if they are the same. One option would be to add a mysql converstion function & then expose it as an api4 calculated field (slight gotcha - there is more than one field we might want to do it with)

ChatGPT was pretty forthcoming with a how-to(it would involve a stored procedure & a lookup table)

Details

Event Timeline

Just noting that there are 21 payment processor reconciliation IDs which have been assigned to more than one transaction (looking for the phab for that) so would be good to tidy these up

1aJdMRDdZHjXSypOhLsu2A2
1gyaborpZZgDKII79KDYlY2
1Io3JIUONcY11dfHEop3VV2
20xEuvcdJ9J2YMpLwYNEnv2
2bQtoxbLE1EV3zK0Wf0r6x2
2G4ASWqNZDPMwXX6myy42G2
2Q55xDoCUWE7f245CiEW992
3EsoG5LmAO96Gjjhu2hmPI2
3SxyOEyvIwfYDuu0OUA3bV2
43C6qlnkyUTgreAnbzbOIp2
4dRWuuDvgbHCBhsIJXMBHT2
4FBbGmF2iezfQiZyMuPxFp2
5icDq8fqFkPB7cvhzqD41x2
5xECGcmTPvKsaMZXLbsLW72
6FjI24hwFjbHhD7iTvkrcK2
6GbcuoGrIZHxCIOkinGxBf2
6LAuESfefU1uNqwKwJ0r2s2
7kuWls9o9gKhTRHL7qtCQh2
cbWa5eBWAhxGB5hN0igM92
w5Icy5cWkvPDmpLWfCYYe2

Change #1219233 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/SmashPig@master] Add function to reverse gravy UUIDs

https://gerrit.wikimedia.org/r/1219233

Change #1219233 merged by jenkins-bot:

[wikimedia/fundraising/SmashPig@master] Add function to reverse gravy UUIDs

https://gerrit.wikimedia.org/r/1219233

XenoRyet set Final Story Points to 2.