ProjectStructuralData.cs

using Coscine.Database.DataModel;
using Coscine.Database.Models;
using Coscine.Database.Util;
using VDS.RDF;

namespace SQL2Linked.Implementations
{
    public class ProjectStructuralData : StructuralData<Project, ProjectModel>
    {
        public readonly Uri org = new("http://www.w3.org/ns/org#");
        public readonly Uri dcat = new("http://www.w3.org/ns/dcat#");
        public readonly Uri dcterms = new("http://purl.org/dc/terms/");
        public readonly Uri foaf = new("http://xmlns.com/foaf/0.1/");
        public readonly Uri vcard = new("http://www.w3.org/2006/vcard/ns#");
        public readonly Uri rdf = new("http://www.w3.org/1999/02/22-rdf-syntax-ns#");
        public readonly Uri cosc = new("https://purl.org/coscine/");
        private VisibilityModel VisibilityModel = new VisibilityModel();
        private ProjectRoleModel ProjectRoleModel = new ProjectRoleModel();
        private ProjectResourceModel ProjectResourceModel = new ProjectResourceModel();

        // Override to also receive deleted projects
        public override IEnumerable<Project> GetAll()
        {
            return DatabaseConnection.ConnectToDatabase((db) =>
            {
                return
                    (from tableEntry in Model.GetITableFromDatabase(db)
                     select tableEntry).ToList();
            });
        }

        public override IEnumerable<IGraph> ConvertToLinkedData(IEnumerable<Project> entries)
        {
            IEnumerable<Visibility> visibilities = VisibilityModel.GetAll();
            IEnumerable<ProjectRole> projectRoles = ProjectRoleModel.GetAll();
            IEnumerable<ProjectResource> projectResources = ProjectResourceModel.GetAll();

            var graphs = new List<IGraph>();
            var projectUrlHandlePrefix = "https://hdl.handle.net/" + Prefix;
            var projectUrlPrefix = "https://purl.org/coscine/projects";
            var resourceUrlPrefix = "https://purl.org/coscine/resources";

            foreach (var entry in entries)
            {
                var projectGraphName = $"{projectUrlPrefix}/{entry.Id}";
                var projectHandleName = $"{projectUrlHandlePrefix}/{entry.Id}";

                var graph = new Graph();
                graph.BaseUri = new Uri(projectGraphName);

                AssertToGraphUriNode(graph, projectGraphName, rdf + "type", dcat + "Catalog");
                Console.WriteLine($"For project '{entry.DisplayName}' will migrate triple '{projectGraphName} {rdf}type {dcat}Catalog'. ");

                AssertToGraphUriNode(graph, projectGraphName, rdf + "type", org + "OrganizationalCollaboration");
                Console.WriteLine($"For project '{entry.DisplayName}' will migrate triple '{projectGraphName} {rdf}type {org}OrganizationalCollaboration'. ");

                AssertToGraphUriNode(graph, projectGraphName, rdf + "type", vcard + "Group");
                Console.WriteLine($"For project '{entry.DisplayName}' will migrate triple '{projectGraphName} {rdf}type {vcard}Group'. ");

                AssertToGraphLiteralNode(graph, projectGraphName, dcterms + "title", entry.ProjectName);
                Console.WriteLine($"For project '{entry.DisplayName}' will migrate triple '{projectGraphName} {dcterms}title {entry.ProjectName}'. ");

                AssertToGraphLiteralNode(graph, projectGraphName, dcterms + "description", entry.Description);
                Console.WriteLine($"For project '{entry.DisplayName}' will migrate triple '{projectGraphName} {dcterms}description {entry.Description}'. ");

                AssertToGraphLiteralNode(graph, projectGraphName, dcat + "startDate", entry.StartDate.ToString(), new Uri("http://www.w3.org/2001/XMLSchema#dateTime"));
                Console.WriteLine($"For project '{entry.DisplayName}' will migrate triple '{projectGraphName} {dcat}startDate {entry.StartDate}'. ");

                AssertToGraphLiteralNode(graph, projectGraphName, dcat + "endDate", entry.EndDate.ToString(), new Uri("http://www.w3.org/2001/XMLSchema#dateTime"));
                Console.WriteLine($"For project '{entry.DisplayName}' will migrate triple '{projectGraphName} {dcat}endDate {entry.EndDate}'. ");