Module:CRTBrandList: Difference between revisions

Increase query limit and suppress "further results" link (via update-page on MediaWiki MCP Server)
Revert to original category-based approach - direct queries don't scale well with 2000+ CRT models (via update-page on MediaWiki MCP Server)
Tag: Manual revert
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
-- Module:CRTBrandList
-- Module:CRTBrandList
-- Dynamically generates a list of CRT brand buttons by querying
-- Dynamically generates a list of CRT brand buttons by querying
-- all unique brands from the CRT models category.
-- pre-computed brand category pages with semantic properties.
-- Much faster than scanning all CRT model pages.


local p = {}
local p = {}
Line 17: Line 18:
local linkType = trim(args.link)
local linkType = trim(args.link)
-- Query all CRT models and get their brands
-- Query brand category pages (fast - only queries category pages, not all CRTs)
-- Use high limit and searchlabel= to suppress "further results"
local queryWikitext =
local queryWikitext =
'{{#ask:\n' ..
'{{#ask:\n' ..
' [[Category:CRT models]]\n' ..
' [[Is CRT brand category::Yes]]\n' ..
' |?Has brand\n' ..
' |?Brand name\n' ..
' |format=broadtable\n' ..
' |format=broadtable\n' ..
' |headers=hide\n' ..
' |headers=hide\n' ..
' |link=none\n' ..
' |link=none\n' ..
' |mainlabel=-\n' ..
' |mainlabel=-\n' ..
' |limit=5000\n' ..
' |limit=500\n' ..
' |searchlabel=\n' ..
' |searchlabel=\n' ..
'}}'
'}}'
Line 33: Line 33:
local queryResult = frame:preprocess(queryWikitext)
local queryResult = frame:preprocess(queryWikitext)
-- Extract unique brands from the result
-- Extract brand names from result
local brandsSet = {}
local brandsList = {}
local brandsList = {}
Line 40: Line 39:
for cellContent in queryResult:gmatch('<td[^>]*>(.-)</td>') do
for cellContent in queryResult:gmatch('<td[^>]*>(.-)</td>') do
local brand = trim(cellContent:gsub('<[^>]+>', ''))
local brand = trim(cellContent:gsub('<[^>]+>', ''))
if brand and brand ~= '' and not brandsSet[brand] then
if brand and brand ~= '' then
brandsSet[brand] = true
table.insert(brandsList, brand)
table.insert(brandsList, brand)
end
end
MediaWiki Appliance - Powered by TurnKey Linux