codemeta-version-sql.tmpl

-- 
-- ${name} version information as SQL view
-- type: software
-- ${if(name)}title: "${name}"${endif}
-- ${if(description)}abstract: "${description}"${endif}
-- ${if(author)}authors:
-- ${for(author)}
--   - family-names: ${it.familyName}
--     given-names: ${it.givenName}
--     orcid: "${it.at__id}"
-- ${endfor}${endif}
-- ${if(contributor)}contributors:
-- ${for(contributor)}
--   - family-names: ${it.familyName}
--     given-names: ${it.givenName}
--     orcid: "${it.at__id}"
-- ${endfor}${endif}
-- ${if(maintainer)}maintainers:
-- ${for(maintainer)}
--   - family-names: ${it.familyName}
--     given-names: ${it.givenName}
--     orcid: "${it.at__id}"
-- ${endfor}${endif}
-- ${if(codeRepository)}repository-code: "${codeRepository}"${endif}
-- ${if(version)}version: ${version}${endif}
-- ${if(license)}license-url: "${license}"${endif}
-- ${if(keywords)}keywords: [ ${for(keywords)}"${it}"${sep}, ${endfor} ]${endif}
-- ${if(datePublished)}date-released: ${datePublished}${endif}

\c ${name}
CREATE OR REPLACE VIEW ${name}.version AS
   SELECT '${name}' AS app_name, '${version}' AS version;