def insertResult(query_id, study_id, job_id, upload, ip, hash, main_hash,
contact_hash, search_engine, url, main, contact, today,
timestamp, progress, results_position):
db = DB()
DB_Results.insertResult(db.cursor, query_id, study_id, job_id, upload,
ip, hash, main_hash, contact_hash,
search_engine, url, main, contact, today,
timestamp, progress, results_position)
db.DBDisconnect()
def getResultsIdsByStudyContact(results_studies_id, results_contact):
db = DB()
rows = DB_Results.getResultsIdsByStudyContact(db.cursor,
results_studies_id,
results_contact)
db.DBDisconnect()
return rows
def countClassifiedResultsbyStudySE(studies_id, se):
db = DB()
rows = DB_Results.countClassifiedResultsbyStudySE(
db.cursor, studies_id, se)
db.DBDisconnect()
return rows
def countClassifiedResultsbyQuery(results_queries_id):
db = DB()
rows = DB_Results.countClassifiedResultsbyQuery(
db.cursor, results_queries_id)
db.DBDisconnect()
return rows
def getLastPosition(query_id, study_id, results_se, today):
db = DB()
rows = DB_Results.getLastPosition(db.cursor, query_id, study_id,
results_se, today)
db.DBDisconnect()
return rows
def updateSources(hash, source, urls, comments, today, progress):
db = DB()
DB_Results.updateSources(db.cursor, hash, source, urls, comments,
today, progress)
db.DBDisconnect()
def getLastPosition(query_id, study_id, search_engine, results_position):
db = DB()
rows = DB_Results.getLastPosition(db.cursor, query_id, study_id,
search_engine, results_position)
db.DBDisconnect()
return rows
def getSERP(query_id):
db = DB()
DB_Results.getSERP(db.cursor, query_id)
db.DBDisconnect()
def getSource(hash):
db = DB()
rows = DB_Results.getSource(db.cursor, hash)
db.DBDisconnect()
return rows
def insertContactResult(contact_url, contact_hash, results_id):
db = DB()
DB_Results.insertContactResult(db.cursor, contact_url, contact_hash,
results_id)
db.DBDisconnect()
def getResultById(results_id):
db = DB()
rows = DB_Results.getResultById(db.cursor, results_id)
db.DBDisconnect()
return rows
def getAllResultsIdsByStudy(results_studies_id):
db = DB()
rows = DB_Results.getAllResultsIdsByStudy(db.cursor,
results_studies_id)
db.DBDisconnect()
return rows
def insertSpeed(hash, speed):
db = DB()
DB_Results.insertSpeed(db.cursor, hash, speed)
db.DBDisconnect()
def countFailedResultsbyStudy(studies_id):
db = DB()
rows = DB_Results.countFailedResultsbyStudy(db.cursor, studies_id)
db.DBDisconnect()
return rows
def updateContactProgress(results_contact, results_id):
db = DB()
DB_Results.updateContactProgress(db.cursor, results_contact,
results_id)
db.DBDisconnect()
def getResultHashesOnMain(main_hash):
db = DB()
rows = DB_Results.getResultHashesOnMain(db.cursor, main_hash)
db.DBDisconnect()
return rows
def getRecentResultByHash(hash):
db = DB()
rows = DB_Results.getRecentResultByHash(db.cursor, hash)
db.DBDisconnect()
return rows
def getURL(query_id, study_id, results_url, results_se):
db = DB()
rows = DB_Results.getURL(db.cursor, query_id, study_id, results_url,
results_se)
db.DBDisconnect()
return rows
def getResults():
db = DB()
rows = DB_Results.getResults(db.cursor)
db.DBDisconnect()
return rows
def insertSERP(query_id, serp, serp_scraper, today):
db = DB()
DB_Results.insertSERP(db.cursor, query_id, serp, serp_scraper, today)
db.DBDisconnect()
def getSourcesSpeedNULL():
db = DB()
rows = DB_Results.getSourcesSpeedNULL(db.cursor)
db.DBDisconnect()
return rows
def deleteResultsNoScrapers(queries_id, results_se):
db = DB()
DB_Results.deleteResultsNoScrapers(db.cursor, queries_id, results_se)
db.DBDisconnect()
def insertSource(hash, source, urls, comments, today, progress):
db = DB()
DB_Results.insertSource(db.cursor, hash, source, urls, comments, today,
progress)
db.DBDisconnect()