Page MenuHomePhabricator

Expose more properties to the user_properties_anon table on Wiki Replicas
Open, Needs TriagePublic

Description

USE huwiki_p;
SELECT DISTINCT(up_property) FROM user_properties_anon;

skin
language
variant
[lots of gadget-* settings]

That's pretty limited. I've been looking for ORES prefs specifically (rcOresDamagingPref, ores-damaging-flag-rc, oresRCHideNonDamaging, oresDamagingPref, oresHighlight, oresWatchlistHideNonDamaging) but in general most boolean / enum options should be safe to show here.

Event Timeline

Tgr created this task.Jun 20 2019, 9:08 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJun 20 2019, 9:08 AM
JJMC89 edited projects, added Data-Services; removed Toolforge.Jun 20 2019, 2:42 PM
bd808 added a subscriber: bd808.Jul 1 2019, 3:48 AM

The properties exposed are controlled by modules/profile/files/labs/db/views/maintain-meta_p.py.

Someone from Security-Team needs to sign off on which properties can/cannot be exposed per the current review process for adding new data to the Wiki Replicas.

bd808 renamed this task from Add more properties to the user_properties_anon table on Toolforge to Expose more properties to the user_properties_anon table on Wiki Replicas.Jul 1 2019, 3:48 AM
bd808 moved this task from Backlog to Wiki replicas on the Data-Services board.