Module:Translation

This module handles interactions with the translations database. It exports querying functions for auto-generating Nomenclature and translation pages.

---

local p = {}
local cargo = mw.ext.cargo
local term = require("Module:Term")
local utilsCode = require("Module:UtilsCode")
local utilsLanguage = require("Module:UtilsLanguage")

-- Returns the rows of the specified page.
function p.fetchTranslations(page)
	local languages = utilsLanguage.GetCodeSortOrder()
    local tables = 'Translations'
    local fields = 'term, game'
    for key, value in ipairs(languages) do
    	fields = fields .. ", " .. value
	end
    local queryArgs = {
        where = 'term = "' .. term.fetchTerm("Series", page) .. '"'
    }
    local result = cargo.query( tables, fields, queryArgs )
    
	return p.formatResults(result)
end

-- Returns the rows of the specified page for the specified game
function p.fetchTranslationsByGame(game, page)
	local languages = utilsLanguage.GetCodeSortOrder()
    local tables = 'Translations'
    local fields = 'term, game'
    for key, value in ipairs(languages) do
    	fields = fields .. ", " .. value
	end
    local queryArgs = {
        where = 'term = "' .. term.fetchTerm("Series", page) .. '" AND game = "' .. game .. '"'
    }
    local result = cargo.query( tables, fields, queryArgs )
	
	return p.formatResults(result)
end


function p.formatResults(data)
	local languages = utilsLanguage.GetCodeSortOrder()
	local formattedResults = {}
	for key, value in ipairs(data) do
    	for key2, value2 in ipairs(languages) do
    		if not utilsCode.IsEmpty(value[value2]) then
    	    	table.insert(formattedResults, {term = value["term"], language = value2, translation = value[value2], meaning = value[value2 .. "M"]})
	    	end
		end
	end
	return formattedResults
end

return p