Zache created this task. Zache added a project: Pywikibot-pagegenerators.py. Restricted Application added subscribers: pywikibot-bugs-list, Aklapper.
TASK DESCRIPTION Superset is SQL query interface to Wikimedia database replica. It has API which allows to run SQL queries over https and it would be nice to have local SQL query access from pywikibot without need of wikimedia cloud accounts. With superset user needs only give OAUTH permission. - https://wikitech.wikimedia.org/wiki/Superset - https://superset.wmcloud.org/ - https://phabricator.wikimedia.org/project/profile/6584/ Howto use 1. add mediawiki test user for meta.wikimedia.org to user-config.py 2. login to meta.wikimedia.org 3. login to superset https://superset.wmcloud.org/login and give OAUTH permissions 4. run code `python pwb.py botti.py -family:commons -lang:commons -supersetquery:"SELECT page_namespace, page_title FROM page LIMIT 10"` run tests ========= python -m unittest -v tests.superset_tests Future work - In future Superset should be able to query ToolsDB public databases also <https://phabricator.wikimedia.org/T367393> TASK DETAIL https://phabricator.wikimedia.org/T367684 WORKBOARD https://phabricator.wikimedia.org/project/board/104/ EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Zache Cc: Aklapper, pywikibot-bugs-list, Zache
_______________________________________________ pywikibot-bugs mailing list -- [email protected] To unsubscribe send an email to [email protected]
