def getEvaluationModuleResult(hash, evaluations_module,
evaluations_result):
db = DB()
rows = DB_Evaluations.getEvaluationModuleResult(
db.cursor, hash, evaluations_module, evaluations_result)
db.DBDisconnect()
return rows
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 getClassificationResultValue(hash, classifications_classification,
classifications_result):
db = DB()
rows = DB_Evaluations.getClassificationResultValue(
db.cursor, hash, classifications_classification,
classifications_result)
db.DBDisconnect()
return rows
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 deleteStudy(study_id):
db = DB()
DB_Studies.deleteStudy(db.cursor, study_id)
db.DBDisconnect()
def insertStudy(study_name, study_description, today, study_se):
db = DB()
DB_Studies.insertStudy(db.cursor, study_name, study_description, today,
study_se)
db.DBDisconnect()
def getStudybyName(study_name):
db = DB()
rows = DB_Studies.getStudybyName(db.cursor, study_name)
db.DBDisconnect()
return rows
def getStudiesScraper():
db = DB()
rows = DB_Studies.getStudiesScraper(db.cursor)
db.DBDisconnect()
return rows
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 getRecentResultByHash(hash):
db = DB()
rows = DB_Results.getRecentResultByHash(db.cursor, hash)
db.DBDisconnect()
return rows
def updateContactProgress(results_contact, results_id):
db = DB()
DB_Results.updateContactProgress(db.cursor, results_contact,
results_id)
db.DBDisconnect()
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 getSource(hash):
db = DB()
rows = DB_Results.getSource(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 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 getStudy(study_id):
db = DB()
rows = DB_Studies.getStudy(db.cursor, study_id)
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 getStudybyNamenotID(study_name, study_id):
db = DB()
rows = DB_Studies.getStudybyNamenotID(db.cursor, study_name, study_id)
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 updateStudy(studies_name, studies_comment, studies_se, studies_id):
db = DB()
DB_Studies.updateStudy(db.cursor, studies_name, studies_comment,
studies_se, studies_id)
db.DBDisconnect()
def countFailedResultsbyStudy(studies_id):
db = DB()
rows = DB_Results.countFailedResultsbyStudy(db.cursor, studies_id)
db.DBDisconnect()
return rows
def deleteunassignedResults():
db = DB()
DB_Studies.deleteunassignedResults(db.cursor)
db.DBDisconnect()
def getResultHashesOnMain(main_hash):
db = DB()
rows = DB_Results.getResultHashesOnMain(db.cursor, main_hash)
db.DBDisconnect()
return rows