Module:CRTBrandList: Difference between revisions
Rewrite to query pre-computed category semantic properties instead of scanning all CRT pages (via update-page on MediaWiki MCP Server) |
Update to query brands directly from CRT model pages (like AVBrandList) instead of requiring brand category pages - ensures all CRT brands appear (via update-page on MediaWiki MCP Server) Tag: Reverted |
||
| 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 | ||
-- | -- distinct brands from actual CRT model pages. | ||
-- | -- This approach ensures all brands with at least one CRT model appear, | ||
-- even if they don't have a dedicated brand category page. | |||
local p = {} | local p = {} | ||
| Line 18: | Line 19: | ||
local linkType = trim(args.link) | local linkType = trim(args.link) | ||
-- Query | -- Query distinct brands from actual CRT model pages | ||
local queryWikitext = | local queryWikitext = | ||
'{{#ask:\n' .. | '{{#ask:\n' .. | ||
' [[ | ' [[Category:CRT models]]\n' .. | ||
' |? | ' [[Has brand::+]]\n' .. | ||
' |?Has brand\n' .. | |||
' |format=broadtable\n' .. | ' |format=broadtable\n' .. | ||
' |headers=hide\n' .. | ' |headers=hide\n' .. | ||
' |link=none\n' .. | ' |link=none\n' .. | ||
' |mainlabel=-\n' .. | ' |mainlabel=-\n' .. | ||
' |limit= | ' |limit=5000\n' .. | ||
' |searchlabel=\n' .. | ' |searchlabel=\n' .. | ||
'}}' | '}}' | ||
| Line 33: | Line 35: | ||
local queryResult = frame:preprocess(queryWikitext) | local queryResult = frame:preprocess(queryWikitext) | ||
-- Extract brand names from result | -- Extract and deduplicate brand names from result | ||
local seen = {} | |||
local brandsList = {} | local brandsList = {} | ||
| Line 39: | Line 42: | ||
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 ~= '' then | if brand and brand ~= '' and not seen[brand] then | ||
seen[brand] = true | |||
table.insert(brandsList, brand) | table.insert(brandsList, brand) | ||
end | end | ||
Revision as of 20:13, 27 February 2026
Documentation for this module may be created at Module:CRTBrandList/doc
-- Module:CRTBrandList
-- Dynamically generates a list of CRT brand buttons by querying
-- distinct brands from actual CRT model pages.
-- This approach ensures all brands with at least one CRT model appear,
-- even if they don't have a dedicated brand category page.
local p = {}
local function trim(s)
if s == nil then return nil end
s = tostring(s)
s = s:gsub('^%s+', ''):gsub('%s+$', '')
if s == '' then return nil end
return s
end
function p.list(frame)
local args = frame.args
local linkType = trim(args.link)
-- Query distinct brands from actual CRT model pages
local queryWikitext =
'{{#ask:\n' ..
' [[Category:CRT models]]\n' ..
' [[Has brand::+]]\n' ..
' |?Has brand\n' ..
' |format=broadtable\n' ..
' |headers=hide\n' ..
' |link=none\n' ..
' |mainlabel=-\n' ..
' |limit=5000\n' ..
' |searchlabel=\n' ..
'}}'
local queryResult = frame:preprocess(queryWikitext)
-- Extract and deduplicate brand names from result
local seen = {}
local brandsList = {}
if queryResult then
for cellContent in queryResult:gmatch('<td[^>]*>(.-)</td>') do
local brand = trim(cellContent:gsub('<[^>]+>', ''))
if brand and brand ~= '' and not seen[brand] then
seen[brand] = true
table.insert(brandsList, brand)
end
end
end
-- Sort alphabetically
table.sort(brandsList)
if #brandsList == 0 then
return '<p><em>No CRT brands found.</em></p>'
end
-- Build the output: render each brand using Template:Brand entry
local output = {}
for _, brand in ipairs(brandsList) do
local templateCall
if linkType then
templateCall = '{{Brand entry|brand=' .. brand .. '|link=' .. linkType .. '}}'
else
templateCall = '{{Brand entry|brand=' .. brand .. '}}'
end
table.insert(output, frame:preprocess(templateCall))
end
return table.concat(output, '\n')
end
return p