Module:PersonList: Difference between revisions
From MaRDI portal
No edit summary |
No edit summary |
||
(17 intermediate revisions by the same user not shown) | |||
Line 26: | Line 26: | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | ||
} | } | ||
ORDER BY ?itemLabel | # ORDER BY ?itemLabel | ||
LIMIT ]] .. limit .. [[ | LIMIT ]] .. limit .. [[ | ||
OFFSET ]] .. offset .. [[ | OFFSET ]] .. offset .. [[ | ||
Line 43: | Line 43: | ||
if not jsonResults then | if not jsonResults then | ||
return "No records found." | return "No records found. Query: " .. sparqlQuery | ||
end | end | ||
if not jsonResults.results or not jsonResults.results.bindings or #jsonResults.results.bindings == 0 then | if not jsonResults.results or not jsonResults.results.bindings or #jsonResults.results.bindings == 0 then | ||
return "No records found." | return "No records found. Query: " .. sparqlQuery | ||
end | end | ||
Line 58: | Line 58: | ||
local pagination = p.createPaginationLinks(offset, limit, args) | local pagination = p.createPaginationLinks(offset, limit, args) | ||
local info = "Current Offset: " .. offset .. ", Current Limit: " .. limit | |||
return | return info .. resultTable .. pagination | ||
end | end | ||
function p.createPaginationLinks(offset, limit, args) | 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 prevOffset = math.max(offset - limit, 0) | ||
local nextOffset = offset + limit | local nextOffset = offset + limit | ||
-- | -- Constructing the URL with the desired format | ||
local | local prevLinkUrl = baseUrl .. "?limit=" .. limit .. "&offset=" .. prevOffset | ||
local nextLinkUrl = baseUrl .. "?limit=" .. limit .. "&offset=" .. nextOffset | |||
local | -- Creating the link markup for MediaWiki | ||
local prevLink = "[" .. prevLinkUrl .. " Previous]" | |||
local nextLink = "[" .. nextLinkUrl .. " Next]" | |||
return prevLink .. ' | ' .. nextLink | return prevLink .. ' | ' .. nextLink | ||
end | end | ||
-- Return the created html table | -- Return the created html table | ||
return p | return p |
Latest revision as of 15:47, 14 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". }
}
# 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