import sys
import logging
import copy

from urllib2 import URLError
from httplib import HTTPException

from Bio import Entrez

RESULTS_FILE = 'dois-1000-per-line.txt'

LOG_FORMAT = '%(asctime)-15s %(message)s'
logging.basicConfig(level=logging.DEBUG, format=LOG_FORMAT)
log = logging.getLogger(__name__)

def fail(msg, original_exception):
    global log
    log.critical(msg)
    raise original_exception

def warn_skip(msg, pmid):
    global log
    log.warn(msg)
    append_file('skipped_pmids.txt', ',' + pmid)

def warn_problem_ncbi_record(msg, pmid):
    global log
    log.warn(msg)
    append_file('cant_get_doi_pmids.txt', ',' + pmid)

def to_file(filename, s):
    with open(filename, 'wb') as f:
        f.write(str(s))

def append_file(filename, s):
    with open(filename, 'ab') as f:
        f.write(str(s))

def main(argv=None):
    if not argv:
        argv = sys.argv

    resume_at_result_number = 0
    resuming = False

    if len(argv) > 1:
        if argv[1] == '--resume':
            from count_results import count_results
            resume_at_result_number = count_results(RESULTS_FILE)
            resuming = True
    
    Entrez.email = '<EMAIL>'
    
    query = "Wellcome[GRNT]"
    
    log.info('Sending this query to NCBI: {0}'.format(query))
    log.info('Starting from result number: {}'.format(resume_at_result_number))
   
    try:
        handle = Entrez.esearch(db="pubmed", term=query, retmax=100000,
                retstart=resume_at_result_number)
    except URLError as e:
        fail('''NCBI query failed due to an URL Error. Are you connected
        to the internet? (It could be that the EUtils API is down or
        Biopython is generating the wrong URL.)''', e)

    record = Entrez.read(handle, validate=False)
    
    log.info('NCBI holds {} records related to this query.'.format(record['Count']))
    
    results = OAGPrep(RESULTS_FILE, resuming=resuming)
    
    for pmid in record['IdList']:
        try:
            individual_handle = Entrez.efetch(db='pubmed', retmode='xml',
                    id=pmid)
            individual_record = Entrez.read(individual_handle,
                    validate=False)
        except ValueError as e:
            warn_skip(
'''ValueError, Biopython probably couldn\'t parse
something or the returned XML was invalid. Skipping PMID {}.
    Original error {}'''.format(pmid, e),
                pmid)
            continue
        except (URLError, HTTPException) as e:
            warn_skip(
'''Networking error. Skipping PMID {}.
    Original error {}'''.format(pmid, e),
                pmid)
            continue
        except Exception as e:
            warn_skip('''Some other error while fetching individual record for PMID {}. Skipping it.
    Original error: "{}"'''.format(pmid, e),
                pmid)
            continue
    
        if len(individual_record) > 1:
            warn_problem_ncbi_record('PMID {}: NCBI response contains multiple items in the individual record list'.format(pmid), pmid)
    
        if 'PubmedData' not in individual_record[0]:
            warn_problem_ncbi_record('PMID {}: NCBI response did not contain PubmedData key'.format(pmid), pmid)
    
        if 'ArticleIdList' not in individual_record[0]['PubmedData']:
            warn_problem_ncbi_record('PMID {}: NCBI response did not contain the ArticleIdList key in the PubmedData dict'.format(pmid), pmid)
    
        for identifier in individual_record[0]['PubmedData']['ArticleIdList']:
            try:
                if identifier.attributes['IdType'] == 'doi':
                    results.add(identifier)
                    log.info('Did another one! {}'.format(pmid))
            except AttributeError:
                warn_problem_ncbi_record('PMID {}: Can\'t add PMID, no associated DOI.'.format(pmid), pmid)
            except Exception as e:
                warn_skip('''Some other error while recording result from PMID {}.
    Original error: "{}"'''.format(pmid, e),
                    pmid)

class OAGPrep:
    current_row = []
    rows = [current_row]
    count = 0

    def __init__(self, results_filename, resuming=False):
        self.results_filename = results_filename
        self.do_not_overwrite_files = resuming

        if self.do_not_overwrite_files:
            append_file(self.results_filename, "\n")
        else:
            to_file(self.results_filename, '')

    def add(self, identifier):
        self.count = self.count + 1

        # add commas in front of all items, but skip the comma before
        # the first item of every line
        if self.count % 1000 == 1:
            append_file(self.results_filename, identifier)
        else:
            append_file(self.results_filename, ',' + identifier)

        # add a newline after each set of 1000 items
        if self.count % 1000 == 0:
            append_file(self.results_filename, "\n")
        
        #if len(self.current_row) == 1000:
        #    full_row = copy.copy(self.current_row)
        #    self.rows.insert(0, full_row)
        #    self.current_row = []

        #self.current_row.append(identifier)


    def __str__(self):
        # unroll the rows (lists) into a single string for outputting
        return "\n".join([','.join(row) for row in self.rows])
        

if __name__ == '__main__':
    main()


import sys
import logging
import copy

from urllib2 import URLError
from httplib import HTTPException

from Bio import Entrez

RESULTS_FILE = 'dois-1000-per-line.txt'

LOG_FORMAT = '%(asctime)-15s %(message)s'
logging.basicConfig(level=logging.DEBUG, format=LOG_FORMAT)
log = logging.getLogger(__name__)

def fail(msg, original_exception):
    global log
    log.critical(msg)
    raise original_exception

def warn_skip(msg, pmid):
    global log
    log.warn(msg)
    append_file('skipped_pmids.txt', ',' + pmid)

def warn_problem_ncbi_record(msg, pmid):
    global log
    log.warn(msg)
    append_file('cant_get_doi_pmids.txt', ',' + pmid)

def to_file(filename, s):
    with open(filename, 'wb') as f:
        f.write(str(s))

def append_file(filename, s):
    with open(filename, 'ab') as f:
        f.write(str(s))

def main(argv=None):
    if not argv:
        argv = sys.argv

    resume_at_result_number = 0
    resuming = False

    if len(argv) > 1:
        if argv[1] == '--resume':
            from count_results import count_results
            resume_at_result_number = count_results(RESULTS_FILE)
            resuming = True
    
    Entrez.email = '<EMAIL>'
    
    query = "Wellcome[GRNT]"
    
    log.info('Sending this query to NCBI: {0}'.format(query))
    log.info('Starting from result number: {}'.format(resume_at_result_number))
   
    try:
        handle = Entrez.esearch(db="pubmed", term=query, retmax=100000,
                retstart=resume_at_result_number)
    except URLError as e:
        fail('''NCBI query failed due to an URL Error. Are you connected
        to the internet? (It could be that the EUtils API is down or
        Biopython is generating the wrong URL.)''', e)

    record = Entrez.read(handle, validate=False)
    
    log.info('NCBI holds {} records related to this query.'.format(record['Count']))
    
    results = OAGPrep(RESULTS_FILE, resuming=resuming)
    
    for pmid in record['IdList']:
        try:
            individual_handle = Entrez.efetch(db='pubmed', retmode='xml',
                    id=pmid)
            individual_record = Entrez.read(individual_handle,
                    validate=False)
        except ValueError as e:
            warn_skip(
'''ValueError, Biopython probably couldn\'t parse
something or the returned XML was invalid. Skipping PMID {}.
    Original error {}'''.format(pmid, e),
                pmid)
            continue
        except (URLError, HTTPException) as e:
            warn_skip(
'''Networking error. Skipping PMID {}.
    Original error {}'''.format(pmid, e),
                pmid)
            continue
        except Exception as e:
            warn_skip('''Some other error while fetching individual record for PMID {}. Skipping it.
    Original error: "{}"'''.format(pmid, e),
                pmid)
            continue
    
        if len(individual_record) > 1:
            warn_problem_ncbi_record('PMID {}: NCBI response contains multiple items in the individual record list'.format(pmid), pmid)
    
        if 'PubmedData' not in individual_record[0]:
            warn_problem_ncbi_record('PMID {}: NCBI response did not contain PubmedData key'.format(pmid), pmid)
    
        if 'ArticleIdList' not in individual_record[0]['PubmedData']:
            warn_problem_ncbi_record('PMID {}: NCBI response did not contain the ArticleIdList key in the PubmedData dict'.format(pmid), pmid)
    
        for identifier in individual_record[0]['PubmedData']['ArticleIdList']:
            try:
                if identifier.attributes['IdType'] == 'doi':
                    results.add(identifier)
                    log.info('Did another one! {}'.format(pmid))
            except AttributeError:
                warn_problem_ncbi_record('PMID {}: Can\'t add PMID, no associated DOI.'.format(pmid), pmid)
            except Exception as e:
                warn_skip('''Some other error while recording result from PMID {}.
    Original error: "{}"'''.format(pmid, e),
                    pmid)

class OAGPrep:
    current_row = []
    rows = [current_row]
    count = 0

    def __init__(self, results_filename, resuming=False):
        self.results_filename = results_filename
        self.do_not_overwrite_files = resuming

        if self.do_not_overwrite_files:
            append_file(self.results_filename, "\n")
        else:
            to_file(self.results_filename, '')

    def add(self, identifier):
        self.count = self.count + 1

        # add commas in front of all items, but skip the comma before
        # the first item of every line
        if self.count % 1000 == 1:
            append_file(self.results_filename, identifier)
        else:
            append_file(self.results_filename, ',' + identifier)

        # add a newline after each set of 1000 items
        if self.count % 1000 == 0:
            append_file(self.results_filename, "\n")
        
        #if len(self.current_row) == 1000:
        #    full_row = copy.copy(self.current_row)
        #    self.rows.insert(0, full_row)
        #    self.current_row = []

        #self.current_row.append(identifier)


    def __str__(self):
        # unroll the rows (lists) into a single string for outputting
        return "\n".join([','.join(row) for row in self.rows])
        

if __name__ == '__main__':
    main()


NCBI query failed due to an URL Error. Are you connected         to the internet? (It could be that the EUtils API is down or         Biopython is generating the wrong URL.) ValueError, Biopython probably couldn\'t parse something or the returned XML was invalid. Skipping PMID {}.     Original error {} Networking error. Skipping PMID {}.     Original error {} Some other error while fetching individual record for PMID {}. Skipping it.     Original error: "{}" Some other error while recording result from PMID {}.     Original error: "{}" # add commas in front of all items, but skip the comma before # the first item of every line # add a newline after each set of 1000 items #if len(self.current_row) == 1000: #    full_row = copy.copy(self.current_row) #    self.rows.insert(0, full_row) #    self.current_row = [] #self.current_row.append(identifier) # unroll the rows (lists) into a single string for outputting