Module:Tabular data - Revision history

MusikBot II: Protected "Module:Tabular data": High-risk template or module: 385 transclusions (more info) ([Edit=Require autoconfirmed or confirmed access] (indefinite))

2021-09-30T22:58:04Z

Protected "Module:Tabular data": High-risk template or module: 385 transclusions (more info) ([Edit=Require autoconfirmed or confirmed access] (indefinite))

← Previous revision	Revision as of 22:58, 30 September 2021
(No difference)

Mxn: Factored out _wikitable for reuse in other modules

2020-09-19T19:35:08Z

Factored out _wikitable for reuse in other modules

← Previous revision		Revision as of 19:35, 19 September 2020
Line 135:		Line 135:
	end		end

		⚫	function p._wikitable(args)
⚫	--- Returns a tabular data page as a wikitext table.
		⚫	local pageName = args[1]
⚫	--- Usage: {{#invoke:Tabular data \| wikitable \| Table name }}
⚫	function p.~~wikitable~~(~~frame~~)
⚫	local pageName = ~~frame.~~args[1]
	local data = mw.ext.data.get(pageName)		local data = mw.ext.data.get(pageName)

Line 217:		Line 215:

	return htmlTable		return htmlTable
			end

		⚫	--- Returns a tabular data page as a wikitext table.
		⚫	--- Usage: {{#invoke:Tabular data \| wikitable \| Table name }}
			function p.wikitable(frame)
			return p._wikitable(frame.args)
	end		end

Mxn: Allow passing in reusable data

2020-06-01T08:06:36Z

Allow passing in reusable data

← Previous revision		Revision as of 08:06, 1 June 2020
Line 89:		Line 89:

	function p._lookup(args)		function p._lookup(args)
	local data = mw.ext.data.get(args[1])		local data = args.data or mw.ext.data.get(args[1])
	local searchValue = args.search_value		local searchValue = args.search_value
	local searchPattern = args.search_pattern		local searchPattern = args.search_pattern

Mxn: Make lookup callable from other modules

2020-06-01T08:02:08Z

Make lookup callable from other modules

@@ Line 88: / Line 88: @@
 end
 	local searchColumnIdx
@@ Line 111: / Line 105: @@
 	assert(searchColumnIdx, mw.ustring.format("Search column “%s” not found.", searchColumnName))
-	local occurrence = tonumber(frame.args.occurrence) or 1
+	local occurrence = tonumber(args.occurrence) or 1
 	local numMatchingRecords = 0
@@ Line 122: / Line 116: @@
 			numMatchingRecords = numMatchingRecords + 1
 			if numMatchingRecords == math.abs(occurrence) then
-				local args = mw.clone(frame.args)
+				local args = mw.clone(args)
 				args.data = data
 				args.output_row = i
@@ Line 129: / Line 123: @@
 		end
 	end
 end

Mxn: Reuse tabular data in lookup

2020-06-01T08:00:06Z

Reuse tabular data in lookup

← Previous revision		Revision as of 08:00, 1 June 2020
Line 123:		Line 123:
	if numMatchingRecords == math.abs(occurrence) then		if numMatchingRecords == math.abs(occurrence) then
	local args = mw.clone(frame.args)		local args = mw.clone(frame.args)
			args.data = data
	args.output_row = i		args.output_row = i
	return p._cell(args)		return p._cell(args)

Mxn: Allow passing in reusable data

2020-06-01T07:48:06Z

Allow passing in reusable data

← Previous revision		Revision as of 07:48, 1 June 2020
Line 20:		Line 20:

	function p._cell(args)		function p._cell(args)
	local data = mw.ext.data.get(args[1])		local data = args.data or mw.ext.data.get(args[1])
	local rowIdx = tonumber(args.output_row)		local rowIdx = tonumber(args.output_row)
	local outputFormat = args.output_format		local outputFormat = args.output_format

Mxn at 01:08, 26 May 2020

2020-05-26T01:08:28Z

← Previous revision		Revision as of 01:08, 26 May 2020
Line 114:		Line 114:

	local numMatchingRecords = 0		local numMatchingRecords = 0
	for i = ~~1, #data.data,~~ (occurrence < 0 and -1 or 1) do		for i = (occurrence < 0 and #data.data or 1),
			(occurrence < 0 and 1 or #data.data),
			(occurrence < 0 and -1 or 1) do
	local record = data.data[i]		local record = data.data[i]
	if (searchValue and record[searchColumnIdx] == searchValue) or		if (searchValue and record[searchColumnIdx] == searchValue) or

Mxn at 01:06, 26 May 2020

2020-05-26T01:06:15Z

← Previous revision		Revision as of 01:06, 26 May 2020
Line 111:		Line 111:
	assert(searchColumnIdx, mw.ustring.format("Search column “%s” not found.", searchColumnName))		assert(searchColumnIdx, mw.ustring.format("Search column “%s” not found.", searchColumnName))

	local occurrence = frame.args.occurrence or 1		local occurrence = tonumber(frame.args.occurrence) or 1

	local numMatchingRecords = 0		local numMatchingRecords = 0

Mxn at 01:01, 26 May 2020

2020-05-26T01:01:12Z

← Previous revision		Revision as of 01:01, 26 May 2020
Line 119:		Line 119:
	(searchPattern and mw.ustring.match(tostring(record[searchColumnIdx]), searchPattern)) then		(searchPattern and mw.ustring.match(tostring(record[searchColumnIdx]), searchPattern)) then
	numMatchingRecords = numMatchingRecords + 1		numMatchingRecords = numMatchingRecords + 1
	if numMatchingRecords == abs(occurrence) then		if numMatchingRecords == math.abs(occurrence) then
	local args = mw.clone(frame.args)		local args = mw.clone(frame.args)
	args.output_row = i		args.output_row = i

Mxn: Lookup arbitrary match based on pattern

2020-05-26T01:00:51Z

Lookup arbitrary match based on pattern

← Previous revision		Revision as of 01:00, 26 May 2020
Line 93:		Line 93:
	--- that the search key must match exactly. (On the other hand, this means the		--- that the search key must match exactly. (On the other hand, this means the
	--- table does not need to be sorted.)		--- table does not need to be sorted.)
	--- Usage: {{#invoke: Tabular data \| lookup \| Table name \| search_value = Value to find in column \| search_column = Name of column to search in \| output_column = Name of column to output \| output_column2 = Name of another column to output \| … \| output_format = String format to output the values in }}		--- Usage: {{#invoke: Tabular data \| lookup \| Table name \| search_value = Value to find in column \| search_pattern = Pattern to find in column \| search_column = Name of column to search in \| occurrence = 1-based index of the matching row to output \| output_column = Name of column to output \| output_column2 = Name of another column to output \| … \| output_format = String format to output the values in }}
	function p.lookup(frame)		function p.lookup(frame)
	local data = mw.ext.data.get(frame.args[1])		local data = mw.ext.data.get(frame.args[1])
	local searchValue = frame.args.search_value		local searchValue = frame.args.search_value
			local searchPattern = frame.args.search_pattern
	local searchColumnName = frame.args.search_column		local searchColumnName = frame.args.search_column

Line 110:		Line 111:
	assert(searchColumnIdx, mw.ustring.format("Search column “%s” not found.", searchColumnName))		assert(searchColumnIdx, mw.ustring.format("Search column “%s” not found.", searchColumnName))

			local occurrence = frame.args.occurrence or 1
	local matchingRecord

⚫	~~for i,~~ record in ~~ipairs(~~data.data~~) do~~
			local numMatchingRecords = 0
⚫	if record[searchColumnIdx] == searchValue ~~then~~
			for i = 1, #data.data, (occurrence < 0 and -1 or 1) do
⚫	local args = mw.clone(frame.args)
		⚫	local record = data.data[i]
⚫	args.output_row = i
		⚫	if (searchValue and record[searchColumnIdx] == searchValue) or
⚫	return p._cell(args)
			(searchPattern and mw.ustring.match(tostring(record[searchColumnIdx]), searchPattern)) then
			numMatchingRecords = numMatchingRecords + 1
			if numMatchingRecords == abs(occurrence) then
		⚫	local args = mw.clone(frame.args)
		⚫	args.output_row = i
		⚫	return p._cell(args)
			end
	end		end
	end		end