local util_args = require('Module:Args Utility')
local util_cargo = require('Module:Cargo Utility')
local util_map = require('Module:Map Utility')
local util_html = require('Module:HTML Utility')
local util_table = require('Module:Table Utility')
local util_text = require('Module:Text Utility')
local COLUMNS = { 'Liquid', 'Factions' }
local h = {}
local p = {}
function p.main(frame)
	--local args = util_args.merge(true)
	--h.castArgs(args)
	local data = h.makeAndRunQuery(nil)
        h.formatRows(data)
	return h.makeOutput(data)
end
function h.makeAndRunQuery(args)
	return util_cargo.queryAndCast(h.makeQuery(args))
end
function h.makeQuery(args)
	local query = {
		tables = { 'Factions=F' },
		fields = h.getFields(),
		where = '(F._pageNamespace="14" OR F._pageNamespace="0") AND IsVisible="1"',
		orderBy = 'F._pageName ASC',
		oneToMany = {
			fields = { 'CONCAT("[[:", _pageName, "|", PlainName, "]]")=Factions', 'WaterRitualLiquid' },
			groupBy = { 'WaterRitualLiquid' },
		},
	}
	return query
end
function h.getFields()
	return {
		'CONCAT("{{favilink|", WaterRitualLiquid,"}}")=Liquid'
	}
end
function h.formatRows(data)
	util_map.rowsInPlace(data, h.formatOneRow)
end
function h.formatOneRow(row)
	row.Factions = util_table.concat(row.Factions, ' • ')
        
end
function h.makeOutput(data)
	local output = mw.html.create()
	local tbl = output:tag('table')
		:addClass('wikitable')
		:addClass('sortable')
	util_html.printHeader(tbl, COLUMNS)
	util_html.printRowsByList(tbl, data, COLUMNS)
	return output
end
return p