Module:CommunityProjectList: Difference between revisions
From MaRDI portal
Created page with "-- 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) -- Retrieve target1 from frame arguments or return error message if not set local target1 = f..." |
No edit summary |
||
Line 9: | Line 9: | ||
local p = {} | local p = {} | ||
-- Function to | -- Function to convert JSON results into a comma-separated string | ||
function p. | function p.convertJsonToCommaSeparatedList(jsonResults) | ||
local resultsString = "" | |||
if jsonResults and jsonResults.results and jsonResults.results.bindings then | |||
local bindings = jsonResults.results.bindings | |||
for i = 0, #bindings do | |||
local binding = bindings[i] | |||
if binding.valueLabel and binding.valueLabel.value then | |||
if resultsString ~= "" then | |||
resultsString = resultsString .. "" | |||
end | |||
local name = binding.valueLabel.value | |||
if string.find(name, "https://") then | |||
name = "Unnamed Publication" | |||
end | |||
local link = binding.value.value | |||
link = link:gsub("entity/Q", "wiki/Publication:") | |||
local nameAndLink = "<li>[" .. link .. " " .. name .. "]</li>" | |||
resultsString = resultsString .. nameAndLink | |||
end | |||
end | |||
end | |||
return "<ul> " .. resultsString .. " </ul>" | |||
end | |||
-- Function to build the list | |||
function p.buildDescribedByList(frame) | |||
-- Retrieve target1 from frame arguments or return error message if not set | -- Retrieve target1 from frame arguments or return error message if not set | ||
Line 18: | Line 50: | ||
end | end | ||
-- Constructing the SPARQL query with dynamic entity target1 | -- Constructing the SPARQL query with dynamic entity target1 | ||
local sparqlQuery = [[ | local sparqlQuery = [[ | ||
Line 31: | Line 56: | ||
PREFIX wd: <https://portal.mardi4nfdi.de/entity/> | PREFIX wd: <https://portal.mardi4nfdi.de/entity/> | ||
SELECT | SELECT DISTINCT ?internal_project_id | ||
WHERE { | |||
?work wdt:P1495 target1: . | |||
WHERE { | |||
OPTIONAL { | OPTIONAL { | ||
?work wdt:P1496 ?internal_project_id . | ?work wdt:P1496 ?internal_project_id . | ||
} | } | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | ||
} | } | ||
]] | ]] | ||
-- mw.log( sparqlQuery ) | |||
-- Executing the SPARQL query and retrieving results in JSON format | -- Executing the SPARQL query and retrieving results in JSON format | ||
local jsonResults = sparql.runQuery(sparqlQuery) | local jsonResults = sparql.runQuery(sparqlQuery) | ||
-- mw.logObject(jsonResults) | -- mw.logObject(jsonResults) | ||
-- Handle error in SPARQL query execution | -- Handle error in SPARQL query execution | ||
Line 91: | Line 83: | ||
return "Could not fetch data." | return "Could not fetch data." | ||
end | end | ||
if helper.countElementsInBindings(jsonResults.results.bindings) == 0 then | if helper.countElementsInBindings(jsonResults.results.bindings) == 0 then | ||
return "No records found." | return "No records found." | ||
end | end | ||
local describedByList = p.convertJsonToCommaSeparatedList(jsonResults) | |||
-- | -- mw.log(describedByList) | ||
return describedByList | |||
end | end | ||
-- Return the created html table | -- Return the created html table | ||
return p | return p |
Revision as of 21:03, 29 April 2024
Documentation for this module may be created at Module:CommunityProjectList/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 convert JSON results into a comma-separated string
function p.convertJsonToCommaSeparatedList(jsonResults)
local resultsString = ""
if jsonResults and jsonResults.results and jsonResults.results.bindings then
local bindings = jsonResults.results.bindings
for i = 0, #bindings do
local binding = bindings[i]
if binding.valueLabel and binding.valueLabel.value then
if resultsString ~= "" then
resultsString = resultsString .. ""
end
local name = binding.valueLabel.value
if string.find(name, "https://") then
name = "Unnamed Publication"
end
local link = binding.value.value
link = link:gsub("entity/Q", "wiki/Publication:")
local nameAndLink = "<li>[" .. link .. " " .. name .. "]</li>"
resultsString = resultsString .. nameAndLink
end
end
end
return "<ul> " .. resultsString .. " </ul>"
end
-- Function to build the list
function p.buildDescribedByList(frame)
-- Retrieve target1 from frame arguments or return error message if not set
local target1 = frame.args[1]
if not target1 or target1 == '' then
return "No records found"
end
-- Constructing the SPARQL query with dynamic entity target1
local sparqlQuery = [[
PREFIX target1: <https://portal.mardi4nfdi.de/entity/]] .. target1 .. [[>
PREFIX wdt: <https://portal.mardi4nfdi.de/prop/direct/>
PREFIX wd: <https://portal.mardi4nfdi.de/entity/>
SELECT DISTINCT ?internal_project_id
WHERE {
?work wdt:P1495 target1: .
OPTIONAL {
?work wdt:P1496 ?internal_project_id .
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
]]
-- mw.log( sparqlQuery )
-- Executing the SPARQL query and retrieving results in JSON format
local jsonResults = sparql.runQuery(sparqlQuery)
-- mw.logObject(jsonResults)
-- 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 "Could not fetch data."
end
if helper.countElementsInBindings(jsonResults.results.bindings) == 0 then
return "No records found."
end
local describedByList = p.convertJsonToCommaSeparatedList(jsonResults)
-- mw.log(describedByList)
return describedByList
end
-- Return the created html table
return p