Module:CRTBrandList - Revision history

Arclight-MCP-Bot: Revert to original category-based approach - direct queries don't scale well with 2000+ CRT models (via update-page on MediaWiki MCP Server)

2026-02-27T20:22:47Z

Revert to original category-based approach - direct queries don't scale well with 2000+ CRT models (via update-page on MediaWiki MCP Server)

← Older revision		Revision as of 20:22, 27 February 2026
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.		-- pre-computed brand category pages with semantic properties.
	-- ~~This approach ensures~~ all ~~brands with at least one~~ CRT model ~~appear,~~		-- Much faster than scanning all CRT model pages.
	~~-- even if they don't have a dedicated brand category page.~~
	--
	~~-- Uses format=plainlist for efficiency with large datasets (2000+ CRTs)~~.

	local p = {}		local p = {}
Line 21:		Line 18:
	local linkType = trim(args.link)		local linkType = trim(args.link)

	-- Query ~~distinct brands from actual CRT model~~ pages		-- Query brand category pages (fast - only queries category pages, not all CRTs)
	-~~- Using plainlist format with custom separator for efficient parsing~~
	local queryWikitext =		local queryWikitext =
	'{{#ask:\n' ..		'{{#ask:\n' ..
	' [[~~Category:~~CRT ~~models]]\n' ..~~		' [[Is CRT brand category::Yes]]\n' ..
	~~' [[Has~~ brand::+]]\n' ..		' \|?Brand name\n' ..
	' \|?~~Has brand~~\n' ..		' \|format=broadtable\n' ..
	' \|format=~~plainlist\n' ..~~		' \|headers=hide\n' ..
	~~' \|sep=@@SEP@@~~\n' ..
	' \|~~valuesep~~=~~@@VAL@@~~\n' ..
	' \|link=none\n' ..		' \|link=none\n' ..
	' \|mainlabel=-\n' ..		' \|mainlabel=-\n' ..
	' \|limit=~~5000~~\n' ..		' \|limit=500\n' ..
	' \|searchlabel=\n' ..		' \|searchlabel=\n' ..
	'}}'		'}}'
Line 39:		Line 33:
	local queryResult = frame:preprocess(queryWikitext)		local queryResult = frame:preprocess(queryWikitext)

	-- Extract ~~and deduplicate~~ brand names from result		-- Extract brand names from result
	~~local seen = {}~~
	local brandsList = {}		local brandsList = {}

	if queryResult then		if queryResult then
	~~-- Split by our custom separator~~		for cellContent in queryResult:gmatch('<td[^>]*>(.-)</td>') do
	for ~~entry~~ in (queryResult ~~.. '@@SEP@@')~~:gmatch('(.-)~~@@SEP@@~~') do		local brand = trim(cellContent:gsub('<[^>]+>', ''))
	~~-- Each entry might have multiple values separated by @@VAL@@~~		if brand and brand ~= '' then
	~~for~~ brand in (~~entry ..~~ '~~@@VAL@@~~'~~):gmatch(~~'~~(.-)@@VAL@@~~') do		table.insert(brandsList, brand)
	~~brand = trim(brand~~)
	if brand and brand ~= '' ~~and not seen[brand]~~ then
	~~seen[brand] = true~~
	table.insert(brandsList, brand)
	~~end~~
	end		end
	end		end

Arclight-MCP-Bot: Fix: Use format=plainlist instead of broadtable to handle large result sets efficiently - broadtable was causing truncation with 2000+ CRT models (via update-page on MediaWiki MCP Server)

2026-02-27T20:21:41Z

Fix: Use format=plainlist instead of broadtable to handle large result sets efficiently - broadtable was causing truncation with 2000+ CRT models (via update-page on MediaWiki MCP Server)

← Older revision		Revision as of 20:21, 27 February 2026
Line 4:		Line 4:
	-- This approach ensures all brands with at least one CRT model appear,		-- This approach ensures all brands with at least one CRT model appear,
	-- even if they don't have a dedicated brand category page.		-- even if they don't have a dedicated brand category page.
			--
			-- Uses format=plainlist for efficiency with large datasets (2000+ CRTs).

	local p = {}		local p = {}
Line 20:		Line 22:

	-- Query distinct brands from actual CRT model pages		-- Query distinct brands from actual CRT model pages
			-- Using plainlist format with custom separator for efficient parsing
	local queryWikitext =		local queryWikitext =
	'{{#ask:\n' ..		'{{#ask:\n' ..
Line 25:		Line 28:
	' [[Has brand::+]]\n' ..		' [[Has brand::+]]\n' ..
	' \|?Has brand\n' ..		' \|?Has brand\n' ..
	' \|format=~~broadtable~~\n' ..		' \|format=plainlist\n' ..
	' \|~~headers~~=~~hide~~\n' ..		' \|sep=@@SEP@@\n' ..
			' \|valuesep=@@VAL@@\n' ..
	' \|link=none\n' ..		' \|link=none\n' ..
	' \|mainlabel=-\n' ..		' \|mainlabel=-\n' ..
Line 40:		Line 44:

	if queryResult then		if queryResult then
	for ~~cellContent~~ in queryResult:gmatch('~~<td[^>]*>~~(.-)~~</td>~~') do		-- Split by our custom separator
	~~local~~ brand ~~= trim~~(~~cellContent~~:~~gsub~~('~~<[^>]+>', '~~'))		for entry in (queryResult .. '@@SEP@@'):gmatch('(.-)@@SEP@@') do
	if brand and brand ~= '' and not seen[brand] then		-- Each entry might have multiple values separated by @@VAL@@
	seen[brand] = true		for brand in (entry .. '@@VAL@@'):gmatch('(.-)@@VAL@@') do
	table.insert(brandsList, brand)		brand = trim(brand)
			if brand and brand ~= '' and not seen[brand] then
			seen[brand] = true
			table.insert(brandsList, brand)
			end
	end		end
	end		end

Arclight-MCP-Bot: 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)

2026-02-27T20:13:45Z

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)

← Older revision		Revision as of 20:13, 27 February 2026
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
	-- ~~pre-computed brand category~~ pages ~~with semantic properties~~.		-- distinct brands from actual CRT model pages.
	-- ~~Much faster than scanning~~ all 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 ~~brand category~~ pages ~~(fast - only queries category pages, not all CRTs)~~		-- Query distinct brands from actual CRT model pages
	local queryWikitext =		local queryWikitext =
	'{{#ask:\n' ..		'{{#ask:\n' ..
	' [[Is CRT brand ~~category~~::~~Yes~~]]\n' ..		' [[Category:CRT models]]\n' ..
	' \|?~~Brand name~~\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=~~500~~\n' ..		' \|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

Arclight-MCP-Bot: Rewrite to query pre-computed category semantic properties instead of scanning all CRT pages (via update-page on MediaWiki MCP Server)

2026-02-04T21:36:39Z

Rewrite to query pre-computed category semantic properties instead of scanning all CRT pages (via update-page on MediaWiki MCP Server)

@@ Line 1: / Line 1: @@
 -- Module:CRTBrandList
 -- 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.
--- Uses pagination to work around server-side SMW query limits.
+-- Much faster than scanning all CRT model pages.
 local p = {}
@@ Line 12: / Line 12: @@
 	if s == '' then return nil end
 	return s
 end
@@ Line 30: / Line 18: @@
 	local linkType = trim(args.link)
-	local brandsSet = {}
+	-- Query brand category pages (fast - only queries category pages, not all CRTs)
 	local brandsList = {}
-	-- Query in batches to work around server-side limits
+	if queryResult then
-	local batchSize = 500
+		for cellContent in queryResult:gmatch('<td[^>]*>(.-)</td>') do
-	local maxBatches = 20  -- Safety limit: 500 * 20 = 10,000 max pages
+			local brand = trim(cellContent:gsub('<[^>]+>', ''))
+			if brand and brand ~= '' then
-	for batch = 0, maxBatches - 1 do
+				table.insert(brandsList, brand)
 			end
 		end
 	end

Arclight-MCP-Bot: Implement pagination to handle server-side query limits (via update-page on MediaWiki MCP Server)

2026-02-04T21:27:52Z

Implement pagination to handle server-side query limits (via update-page on MediaWiki MCP Server)

@@ Line 2: / Line 2: @@
 -- Dynamically generates a list of CRT brand buttons by querying
 -- all unique brands from the CRT models category.
 local p = {}
@@ Line 11: / Line 12: @@
 	if s == '' then return nil end
 	return s
 end
@@ Line 17: / Line 30: @@
 	local linkType = trim(args.link)
 	local brandsSet = {}
 	local brandsList = {}
-	if queryResult then
+	-- Query in batches to work around server-side limits
-		for cellContent in queryResult:gmatch('<td[^>]*>(.-)</td>') do
+	local batchSize = 500
-			local brand = trim(cellContent:gsub('<[^>]+>', ''))
+	local maxBatches = 20  -- Safety limit: 500 * 20 = 10,000 max pages
-			if brand and brand ~= '' and not brandsSet[brand] then
-				brandsSet[brand] = true
+	for batch = 0, maxBatches - 1 do
-				table.insert(brandsList, brand)
+		local offset = batch * batchSize
 			end
 		end
 	end

Arclight-MCP-Bot: Increase query limit and suppress "further results" link (via update-page on MediaWiki MCP Server)

2026-02-04T21:23:04Z

Increase query limit and suppress "further results" link (via update-page on MediaWiki MCP Server)

← Older revision		Revision as of 21:23, 4 February 2026
Line 18:		Line 18:

	-- Query all CRT models and get their brands		-- Query all CRT models and get their brands
			-- Use high limit and searchlabel= to suppress "further results"
	local queryWikitext =		local queryWikitext =
	'{{#ask:\n' ..		'{{#ask:\n' ..
Line 26:		Line 27:
	' \|link=none\n' ..		' \|link=none\n' ..
	' \|mainlabel=-\n' ..		' \|mainlabel=-\n' ..
	' \|limit=~~500~~\n' ..		' \|limit=5000\n' ..
			' \|searchlabel=\n' ..
	'}}'		'}}'

Arclight-MCP-Bot: Fix link parameter handling - only include if specified (via update-page on MediaWiki MCP Server)

2026-02-04T21:21:41Z

Fix link parameter handling - only include if specified (via update-page on MediaWiki MCP Server)

← Older revision		Revision as of 21:21, 4 February 2026
Line 15:		Line 15:
	function p.list(frame)		function p.list(frame)
	local args = frame.args		local args = frame.args
	local linkType = args.link ~~or 'advanced'~~		local linkType = trim(args.link)

	-- Query all CRT models and get their brands		-- Query all CRT models and get their brands
Line 55:		Line 55:
	local output = {}		local output = {}
	for _, brand in ipairs(brandsList) do		for _, brand in ipairs(brandsList) do
	local templateCall = '{{Brand entry\|brand=' .. brand .. '\|link=' .. linkType .. '}}'		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))		table.insert(output, frame:preprocess(templateCall))
	end		end

Arclight-MCP-Bot: Create module to dynamically generate CRT brand list from semantic query (via create-page on MediaWiki MCP Server)

2026-02-04T21:20:38Z

Create module to dynamically generate CRT brand list from semantic query (via create-page on MediaWiki MCP Server)

New page

-- Module:CRTBrandList
-- Dynamically generates a list of CRT brand buttons by querying
-- all unique brands from the CRT models category.

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 = args.link or 'advanced'

-- Query all CRT models and get their brands
local queryWikitext =
'{{#ask:\n' ..
' [[Category:CRT models]]\n' ..
' |?Has brand\n' ..
' |format=broadtable\n' ..
' |headers=hide\n' ..
' |link=none\n' ..
' |mainlabel=-\n' ..
' |limit=500\n' ..
'}}'

local queryResult = frame:preprocess(queryWikitext)

-- Extract unique brands from the result
local brandsSet = {}
local brandsList = {}

if queryResult then
for cellContent in queryResult:gmatch('<td[^>]*>(.-)</td>') do
local brand = trim(cellContent:gsub('<[^>]+>', ''))
if brand and brand ~= '' and not brandsSet[brand] then
brandsSet[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 = '{{Brand entry|brand=' .. brand .. '|link=' .. linkType .. '}}'
table.insert(output, frame:preprocess(templateCall))
end

return table.concat(output, '\n')
end

return p