mzmcbride / database-reports Goto Github PK

Hi, I'm trying to run scripts on the labs instance but it's looking into the wrong directory.
It should be looking into /dbreps/src/database-reports/reports/general

Right now on labs we're only running new-style reports, basically anything in the reports/ folder. The old legacy reports should be converted to use the new format.

Labs has the same table, but named toolserverdb_p.namespace.

Except when I tried using it in reports/general/blankpages.py, I got:

$ ~/bin/dbreps -r general.blankpages -s commonswiki
Traceback (most recent call last):
  File "/data/project/dbreps/bin/dbreps", line 80, in <module>
    for row in r.get_table_rows(conn):
  File "/data/project/dbreps/.local/lib/python2.7/site-packages/reports/general/blankpages.py", line 51, in get_table_rows
    ''', (self.site, ))
  File "cursor.pyx", line 120, in oursql.Cursor.execute (oursqlx/oursql.c:16822)
  File "cursor.pyx", line 111, in oursql.Cursor.execute (oursqlx/oursql.c:16693)
  File "statement.pyx", line 157, in oursql._Statement.prepare (oursqlx/oursql.c:8458)
  File "statement.pyx", line 127, in oursql._Statement._raise_error (oursqlx/oursql.c:8082)
oursql.PermissionsError: (1142, "SELECT command denied to user 'p50380g50440'@'10.68.16.7' for table 'namespace'", None)

Any ideas @scfc ?

Over the past few months there has been work done to the unused template report requirements.

1. Categories which should be excluded should be:

   WHERE cl_to IN (
   'Wikipedia_substituted_templates',
   'Wikipedia_transclusionless_templates',
   'Deprecated_templates_kept_for_historical_reasons',
   'Inactive project pages',
   'Parameter_shared_content_templates',
   'Administrative service award templates',
   'Computer language user templates',
   'Language user templates',
   'Level-zero userbox templates',
   'Wikipedia administrator statistics',
   'Subtemplates of Template RussiaAdmMunRef',
   'Subtemplates of Template RussiaBasicLawRef',
   'New Pages Feed templates'
   )

2. The line "not page_title.endswith('/doc')" should be removed so unused /doc pages will appear. If a /doc page is unused that is usually a sign that something went wrong (sub page of a deleted page, sub page hasn't moved with main page, not needed, etc.).

https://github.com/search?q=repo%3Amzmcbride%2Fdatabase-reports%20pagelinks&type=code

Last edits on 30 June, https://commons.wikimedia.org/wiki/Special:Contributions/BernsteinBot

Crons need to be set up on toolslabs?