def loadAllObjectPids(db): solr = Solr() solr.loadConfig('solr.cfg','prod') queryParams = { 'q':'*:*', 'fl': 'PID', } # Test small sample # queryParams = { # 'q':'RELS_EXT_isConstituentOf_uri_s:info\:fedora\/mtholyoke\:25060', # 'fl': 'PID', # } response = solr.query(queryParams) allpids = list(map(lambda x: x['PID'], response)) for pid in allpids: try: db.cursor.execute("INSERT INTO md5s_remote VALUES ('%s', NULL, 0)" % pid) except sqlite3.IntegrityError as e: logging.warning(str(e) + ' ' + pid) db.connection.commit()