Skip to content

Regularly pull journal information from NLM catalog and populate database

Journal information needs to be pulled from two NLM Catalog eutilities service, on a regular basis, to populate the journals table. This should be included ask a /server/ component. Please as @yuci for help setting this up.

Previous ruby service for this purpose: search_nlm_catalog.rb

URLS:

Journal Table columns:

column name ordinal position column default is nullable data type
id 1 uuid_generate_v4() NO uuid
created 2 CURRENT_TIMESTAMP NO timestamp with time zone
updated 3 YES timestamp with time zone
journal_title 4 NO text
meta,publisher_name 5 YES text
meta,issn 6 YES ARRAY
meta,nlmta 7 YES text
meta,pmc_status 8 YES boolean
meta,nlmuniqueid 9 YES text
meta,pubmed_status 10 YES boolean

Journal GraphQL:

type Journal implements Object {
    id: ID!
    created: DateTime!
    updated: DateTime
    journalTitle: String!
    meta: JournalMeta
}

type JournalMeta {
    publisherName: String
}

extend type JournalMeta {
  issn: [Issn]
  nlmta: String
  pmcStatus: Boolean
  pubmedStatus: Boolean
}
Edited by Audrey Hamelers