Module:PersonList: Difference between revisions
From MaRDI portal
No edit summary |
No edit summary |
||
Line 26: | Line 26: | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | ||
} | } | ||
LIMIT ]] .. limit .. [[ | LIMIT ]] .. limit .. [[ | ||
OFFSET ]] .. offset .. [[ | OFFSET ]] .. offset .. [[ | ||
ORDER BY ?propertyLabel | ORDER BY ?propertyLabel | ||
]] | ]] | ||
mw.log( 'query: ' .. sparqlQuery ) | |||
-- Executing the SPARQL query and retrieving results in JSON format | -- Executing the SPARQL query and retrieving results in JSON format |
Revision as of 23:01, 13 December 2023
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". }
}
LIMIT ]] .. limit .. [[
OFFSET ]] .. offset .. [[
ORDER BY ?propertyLabel
]]
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.results or not jsonResults.results.bindings or #jsonResults.results.bindings == 0 then
return "No records found."
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"}
return helper.createHtmlTableWithMergedCols(dataTable, headers, {{1, 2}})
end
-- Return the created html table
return p