Модуль:StrLen - История изменений

PatukMI в 12:26, 7 сентября 2021

2021-09-07T12:26:44Z

2021-09-07T12:23:35Z

2021-09-07T12:22:05Z

← Предыдущая		Версия 12:22, 7 сентября 2021
Строка 26:		Строка 26:
	function p.Main( frame )		function p.Main( frame )
	local tables = 'DS_name'		local tables = 'DS_name'
	local fields = 'Name=~~Paper_name~~, Link=~~Paper_link~~'		local fields = 'Name=name1, Link=link1'
	-- optional parameters are grouped in one table		-- optional parameters are grouped in one table
	-- you can omit any or all of them, except join if you use more than one table		-- you can omit any or all of them, except join if you use more than one table
Строка 45:		Строка 45:
	local result = results[r]		local result = results[r]
	-- Do something with the result table, e.g. result.alias1		-- Do something with the result table, e.g. result.alias1
	return result.~~Paper_name~~, result.~~Paper_link~~		return result.name1, result.link1
	end		end

2021-09-07T12:16:23Z

← Предыдущая		Версия 12:16, 7 сентября 2021
Строка 45:		Строка 45:
	local result = results[r]		local result = results[r]
	-- Do something with the result table, e.g. result.alias1		-- Do something with the result table, e.g. result.alias1
	return result.Paper_name		return result.Paper_name, result.Paper_link
	end		end

	return results		--return results

	end		end

	return p		return p

2021-09-07T12:14:22Z

← Предыдущая		Версия 12:14, 7 сентября 2021
Строка 26:		Строка 26:
	function p.Main( frame )		function p.Main( frame )
	local tables = 'DS_name'		local tables = 'DS_name'
	local fields = '~~name~~=Paper_name, ~~link~~=Paper_link'		local fields = 'Name=Paper_name, Link=Paper_link'
	-- optional parameters are grouped in one table		-- optional parameters are grouped in one table
	-- you can omit any or all of them, except join if you use more than one table		-- you can omit any or all of them, except join if you use more than one table

2021-09-07T12:07:26Z

2021-09-07T12:06:02Z

← Предыдущая		Версия 12:06, 7 сентября 2021
Строка 45:		Строка 45:
	local result = results[r]		local result = results[r]
	-- Do something with the result table, e.g. result.alias1		-- Do something with the result table, e.g. result.alias1
	return result		return result.Paper_name
	end		end

2021-09-07T11:05:53Z

← Предыдущая		Версия 11:05, 7 сентября 2021
Строка 41:		Строка 41:
	--]]		--]]
	local results = cargo.query( tables, fields, args )		local results = cargo.query( tables, fields, args )
	~~--[[~~
	for r = 1, #results do		for r = 1, #results do
	local result = results[r]		local result = results[r]
	-- Do something with the result table, e.g. result.alias1		-- Do something with the result table, e.g. result.alias1
			return result
	end		end
	~~--]]~~
	return result		return result

2021-09-07T11:01:26Z

2021-09-07T10:56:25Z

← Предыдущая		Версия 10:56, 7 сентября 2021
Строка 21:		Строка 21:
	end		end
	--]]		--]]

			local cargo = mw.ext.cargo

			function p.Main( frame )
			local tables = 'DS_name'
			local fields = 'name=Paper_name, link=Paper_link'
			-- optional parameters are grouped in one table
			-- you can omit any or all of them, except join if you use more than one table
			local args = {}
			--[[
			where = 'table1.fieldE="some value", etc.',
			join = 'table1.fieldA = table2.fieldB,table2.fieldC=table3.fieldD, etc.',
			groupBy = 'table1.fieldG',
			having = 'table1.fieldG="some value", etc.',
			orderBy = 'table2.fieldF, etc.',
			limit = some number,
			offset = some number,
			}
			--]]
			local results = cargo.query( tables, fields, args )
			--[[
			for r = 1, #results do
			local result = results[r]
			-- Do something with the result table, e.g. result.alias1
			end
			--]]
			end

	return p		return p