Module:RandomCargoRecord

Documentation for this module may be created at Module:RandomCargoRecord/doc

local p = {}
local cargo = mw.ext.cargo

function p.randomCargoRecord(frame)
    local getArgs = require('Module:Arguments').getArgs
    local args = getArgs(frame);
    local tableName = args[1]

    if tableName == nil or tableName == "" then
        hasErrors = true
        return string.format("<code>tableName</code> parameter is required")
    end

	local countFields = 'COUNT(*)=total'
	local countArgs = {
		format = 'list',
		limit = 1
	}
	local countResults = cargo.query(tableName, countFields, countArgs)
	local total = 0
	for r = 1, #countResults do
        local result = countResults[r]
		total = result.total
    end

	if total == nil or total == "" then
        return string.format("<code>total</code> could not be calculated from table %s", tableName)
    end

	local number = require('Module:Random').number
	local queryFields = 'game=game,link=link'
	local randomArgs = {
		[1] = 1,
		[2] = total
	}
	local countOffset = number(randomArgs)

	local args = {
		format = 'table',
		limit = 1,
		offset = countOffset
	}
	local results = cargo.query(tableName, queryFields, args)
    for r = 1, #results do
        local result = results[r]
        return string.format("[[%s]]", result.link)
    end
end

return p