English Wikipedia @ Freddythechick:Database reports/Templates transcluded on the most pages/Configuration

This page is currently inactive and is retained for historical reference.
Either the page is no longer relevant or consensus on its purpose has become unclear. To revive discussion, seek broader input via a forum such as the village pump.
This code is irrelevant as the report is now generated as a by-product of a different bot.

mosttransclusions.py

! /usr/bin/env python
Public domain; bjweeks, MZMcBride; 2008, 2016, 2018

import oursql import wikitools

import settings

report_title = settings.rootpage + 'Templates with the most transclusions'

report_template = u\ Templates with the most transclusions, limited to the first 3,000 entries; data as of ~~~~~.

%s

No.	Template	Uses

wiki = wikitools.Wiki(settings.apiurl) wiki.login(settings.username, settings.password)

conn = oursql.connect(

   host=settings.host,
   db=settings.dbname,
   read_default_file='~/.my.cnf'

) cursor = conn.cursor() cursor.execute( /* mosttransclusions.py SLOW_OK */ SELECT

 tl_title,
 COUNT(*)

FROM templatelinks WHERE tl_namespace = 10 GROUP BY tl_title ORDER BY COUNT(*) DESC LIMIT 3000; )

i = 1 output = [] for row in cursor.fetchall():

   tl_title = row[0].decode('utf-8').replace('_', ' ')
   tl_title = u'%s' % (tl_title, tl_title)
   uses = '{0:,}'.format(int(row[1]))
   table_row = u\

| %d | %s | %s |- % (i, tl_title, uses)

   output.append(table_row)
   i += 1

report = wikitools.Page(wiki, report_title) report_text = report_template % ('\n'.join(output)) report_text = report_text.encode('utf-8') report.edit(report_text, summary=settings.editsumm, bot=1)

cursor.close() conn.close() </syntaxhighlight>

crontab

<syntaxhighlight lang="text"> 0 15 8,22 * * python ~/scripts/database-reports/mosttransclusions.py > /dev/null </syntaxhighlight>