Well, that answers the syntax of the encoding, but I'm also looking for the semantics, i.e. what the various fields mean, although I can guess at some of it.
I also need to figure out how to parse this in Python. I have much empathy for the anonymous author of this comment https://www.php.net/manual/en/function.serialize.php#107717.
On Dec 4, 2019, at 7:53 PM, Dennis Tobar dennis.tobar@gmail.com wrote:
AFAIK, this kind of information is from serialize[1] and unserialize php functions. See the information from Mediawiki table documentation[2]
[1] https://www.php.net/manual/en/function.serialize.php https://www.php.net/manual/en/function.serialize.php [2] https://www.mediawiki.org/wiki/Manual:Logging_table#log_params https://www.mediawiki.org/wiki/Manual:Logging_table#log_params On Wed, Dec 4, 2019 at 9:50 PM Roy Smith <roy@panix.com mailto:roy@panix.com> wrote: Is there a description somewhere of what the log_params mean in this query?
MariaDB [enwiki_p]> select log_params from logging_logindex where log_namespace = 2 and log_title = 'RoySmith-testing' and log_type = 'block' order by log_timestamp asc; +---------------------------------------------------------------------------------------------------------+ | log_params | +---------------------------------------------------------------------------------------------------------+ | a:3:{s:11:"5::duration";s:9:"5 minutes";s:8:"6::flags";s:11:"noautoblock";s:8:"sitewide";b:1;} | | a:3:{s:11:"5::duration";s:9:"5 minutes";s:8:"6::flags";s:20:"nocreate,noautoblock";s:8:"sitewide";b:1;} | | a:0:{} | +---------------------------------------------------------------------------------------------------------+ 3 rows in set (0.00 sec)
Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org mailto:Cloud@lists.wikimedia.org (formerly labs-l@lists.wikimedia.org mailto:labs-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud https://lists.wikimedia.org/mailman/listinfo/cloud
-- Dennis Tobar Calderón Ingeniero en Informática UTEM _______________________________________________ Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly labs-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud