Page MenuHomePhabricator
Paste P55685

Extract storagekey for deleted objects
ArchivedPublic

Authored by MatthewVernon on Jan 25 2024, 2:38 PM.
Tags
None
Referenced Files
F41716651: Extract storagekey for deleted objects
Jan 25 2024, 2:38 PM
Subscribers
None
while read -r name ; do
tn=$( echo -n "$name" | sed -e "s/ /_/g; s/'/''/g" )
sql commonswiki -- -N -e "select fa_name, fa_storage_key from filearchive where fa_name = '$tn' limit 1;"
done <logos >logos_hashes

Event Timeline

The sed transform is space to underscore (a standard change for object name -> database entry) and ' to '' which quotes the ' character for mysql use (in a '-quoted string); the equivalent backslash-based approach would have been s/'/\\\'/g which is uglier.