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:
- ESearch: https://eutils.ncbi.nlm.nih.gov/entrez/eutils/esearch.fcgi
- EFetch: https://eutils.ncbi.nlm.nih.gov/entrez/eutils/efetch.fcgi
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