Module:Database reports/Long pages by namespace

Module documentationviewedithistorypurge

This is an example of a parametrized report configuration that can be used to create lists of longest pages in a given namespace. Sample usage can be seen on User:SDZeroBot/sandbox/Longest pages in File namespace.

Usage

{{Database report
| lua_source = Module:Database reports/Long pages by namespace
| lua_function = main
| lua_arg_ns_name = File <!-- Name of the namspace -->
| lua_arg_ns_number = 6 <!-- Namespace number -->
}}
{{Database report end}}

The above documentation is transcluded from Module:Database reports/Long pages by namespace/doc. (edit | history)
Editors can experiment in this module's sandbox (create | mirror) and testcases (create) pages.
Subpages of this module.

local Report = require('Module:Database report')
local Arguments = require('Module:Arguments')

local p = {}

p.main = function(frame)
	local args = Arguments.getArgs(frame)
	local report = Report:new()
	
	report:setSQL([[
		SELECT page_title AS "]] .. args.ns_name .. [[", page_len AS "Bytes" 
		FROM page 
		WHERE page_namespace = ]] .. args.ns_number .. [[
		ORDER BY page_len DESC 
		LIMIT 1000
	]])
	report:useWikilinks(1, args.ns_number)
	report:setInterval(30)

	return report:generate()
end 

return p