Module:PersonList

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

-- Required module containing helper methods
local helper = require('Module:HelperMethods')

-- Required modules for SPARQL queries and HTML table generation
local sparql = require('SPARQL')
local mwHtml = require('mw.html')

-- Main table to hold all functions
local p = {}

-- Function to build a HTML table from SPARQL query results
function p.buildTableFromSparql(frame)
	
	local args = frame.args
    local offset = tonumber(args.offset) or 0
    local limit = tonumber(args.limit) or 10 
	
    -- Constructing the SPARQL query with dynamic entity target1
    local sparqlQuery = [[
PREFIX wdt: <https://portal.mardi4nfdi.de/prop/direct/>
PREFIX wd: <https://portal.mardi4nfdi.de/entity/>

SELECT ?item ?itemLabel
WHERE {
  ?item wdt:P31 wd:Q57162.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
#  ORDER BY ?itemLabel
 LIMIT ]] .. limit .. [[
 OFFSET ]] .. offset .. [[
    ]]
    
    mw.log( 'query: ' .. sparqlQuery )

	-- Executing the SPARQL query and retrieving results in JSON format
	local jsonResults = sparql.runQuery(sparqlQuery)

	-- Handle error in SPARQL query execution
	if jsonResults and jsonResults.error then
    	mw.log("Error in SPARQL query: " .. tostring(jsonResults.error))
    	return nil
	end
	
	if not jsonResults then
        return "No records found. Query: " .. sparqlQuery
    end
	
	if not jsonResults.results or not jsonResults.results.bindings or #jsonResults.results.bindings == 0 then
        return "No records found. Query: " .. sparqlQuery
    end

	-- Convert the JSON results into a Lua table
	local dataTable = helper.convertJsonToTable(jsonResults)

	-- Create and return a HTML table from the data
    local headers = {"Property", "Value"}
    local resultTable = helper.createHtmlTableWithMergedCols(dataTable, headers, {{1, 2}})

	local pagination = p.createPaginationLinks(offset, limit, args)
	
	local info = "Current Offset: " .. offset .. ", Current Limit: " .. limit

    return info .. resultTable .. pagination
   
end

function p.createPaginationLinks(offset, limit, args)
    local pageName = 'PersonList' -- Adjust if needed
    local baseUrl =  tostring(mw.uri.fullUrl(pageName))

    local prevOffset = math.max(offset - limit, 0)
    local nextOffset = offset + limit

    -- Constructing the URL with the desired format
    local prevLinkUrl = baseUrl .. "?limit=" .. limit .. "&offset=" .. prevOffset
    local nextLinkUrl = baseUrl .. "?limit=" .. limit .. "&offset=" .. nextOffset

    -- Creating the link markup for MediaWiki
    local prevLink = "[" .. prevLinkUrl .. " Previous]"
    local nextLink = "[" .. nextLinkUrl .. " Next]"

    return prevLink .. ' | ' .. nextLink
end







-- Return the created html table
return p