Module:ListPeople - Revision history

Craig.dabelstein at 03:27, 23 July 2025

2025-07-23T03:27:00Z

← Older revision		Revision as of 03:27, 23 July 2025
Line 1:		Line 1:
	local p = {}		local p = {}

	~~local cargo = mw.ext.cargo~~

	function p.get()		function p.get()
			local cargo = mw.ext.cargo
	local peopleSet = {}		local peopleSet = {}

	~~-- Fetch Composer values~~		local function safeQuery(field)
	local ~~composerResults~~ = cargo.query('Compositions', ~~'Composer'~~, {		local success, result = pcall(function()
	groupBy = ~~'Composer'~~,		return cargo.query('Compositions', field, {
	limit = 1000		groupBy = field,
	})		limit = 1000
			})
			end)
			if not success then
			return {}
			end
			return result
			end

	~~-- Fetch Arranger values~~		local function addNames(resultTable, field)
	~~local arrangerResults = cargo.query('Compositions', 'Arranger', {~~
	~~groupBy = 'Arranger',~~
	~~limit = 1000~~
	})

	local function addNames(resultTable)
	for _, row in ipairs(resultTable) do		for _, row in ipairs(resultTable) do
	local ~~fieldValue~~ = row[1] or ''		local names = row[field] or ''
	for name in mw.text.gsplit(~~fieldValue~~, '[,;]') do		for name in mw.text.gsplit(names, '[,;]') do
	name = mw.text.trim(name)		name = mw.text.trim(name)
	if name ~= '' then		if name ~= '' then
Line 30:		Line 30:
	end		end

	addNames(~~composerResults~~)		-- Query and process both Composer and Arranger
	addNames(~~arrangerResults~~)		local composers = safeQuery('Composer')
			addNames(composers, 'Composer')

			local arrangers = safeQuery('Arranger')
			addNames(arrangers, 'Arranger')

	-- ~~Convert to sorted list~~		-- Sort and format
	local ~~peopleList~~ = {}		local list = {}
	for name~~, _~~ in pairs(peopleSet) do		for name in pairs(peopleSet) do
	table.insert(~~peopleList~~, name)		table.insert(list, name)
	end		end
	table.sort(~~peopleList~~)		table.sort(list)

	~~-- Build~~ output		local output = {}
	~~local out~~ = {}		for _, name in ipairs(list) do
	for _, name in ipairs(~~peopleList~~) do		table.insert(output, '* [[' .. name .. ']]')
	table.insert(~~out~~, '* [[' .. name .. ']]')
	end		end

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

	return p		return p

Craig.dabelstein at 03:24, 23 July 2025

2025-07-23T03:24:18Z

← Older revision		Revision as of 03:24, 23 July 2025
Line 18:		Line 18:
	})		})

	local function addNames(~~field~~)		local function addNames(resultTable)
	for _, row in ipairs(~~field~~) do		for _, row in ipairs(resultTable) do
	for name in mw.text.gsplit(~~row[1] or ''~~, '[,;]') do		local fieldValue = row[1] or ''
			for name in mw.text.gsplit(fieldValue, '[,;]') do
	name = mw.text.trim(name)		name = mw.text.trim(name)
	if name ~= '' then		if name ~= '' then

Craig.dabelstein: Created page with "local p = {} local cargo = mw.ext.cargo function p.get() local peopleSet = {} -- Fetch Composer values local composerResults = cargo.query('Compositions', 'Composer', { groupBy = 'Composer', limit = 1000 }) -- Fetch Arranger values local arrangerResults = cargo.query('Compositions', 'Arranger', { groupBy = 'Arranger', limit = 1000 }) local function addNames(field) for _, row in ipairs(field) do..."

2025-07-23T03:21:11Z

Created page with "local p = {} local cargo = mw.ext.cargo function p.get() local peopleSet = {} -- Fetch Composer values local composerResults = cargo.query('Compositions', 'Composer', { groupBy = 'Composer', limit = 1000 }) -- Fetch Arranger values local arrangerResults = cargo.query('Compositions', 'Arranger', { groupBy = 'Arranger', limit = 1000 }) local function addNames(field) for _, row in ipairs(field) do..."

New page

local p = {}

local cargo = mw.ext.cargo

function p.get()
local peopleSet = {}

-- Fetch Composer values
local composerResults = cargo.query('Compositions', 'Composer', {
groupBy = 'Composer',
limit = 1000
})

-- Fetch Arranger values
local arrangerResults = cargo.query('Compositions', 'Arranger', {
groupBy = 'Arranger',
limit = 1000
})

local function addNames(field)
for _, row in ipairs(field) do
for name in mw.text.gsplit(row[1] or '', '[,;]') do
name = mw.text.trim(name)
if name ~= '' then
peopleSet[name] = true
end
end
end
end

addNames(composerResults)
addNames(arrangerResults)

-- Convert to sorted list
local peopleList = {}
for name, _ in pairs(peopleSet) do
table.insert(peopleList, name)
end
table.sort(peopleList)

-- Build output
local out = {}
for _, name in ipairs(peopleList) do
table.insert(out, '* [[' .. name .. ']]')
end

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

return p