def search():
search_val = request.args.get('search_val')
with sqlite3.connect(db_filepath) as cnx:
max_results = 10
max_search_length = 300
cur = cnx.cursor()
person_orgs = Jsonifier.person_org(
cur.execute(
SearchQueries.person_org_search(search_val,
max_results)).fetchall())
orgs = Jsonifier.id_name(
cur.execute(SearchQueries.org_search(search_val,
max_results)).fetchall(),
'org')
confs = Jsonifier.id_name(
cur.execute(SearchQueries.conf_search(search_val,
max_results)).fetchall(),
'conf')
# Filter and sort by length of each category
orgs = list(filter(lambda r: len(r['text']) < max_search_length, orgs))
confs = list(filter(lambda r: len(r['text']) < max_search_length, confs))
results = []
for res_list, _ in sorted(list(
map(lambda l: (l, len(l)), [person_orgs, orgs, confs])),
key=lambda t: t[1],
reverse=True):
results += res_list
return {'results': results}
def autocomplete_search():
max_results = 30
max_search_length = 300
search_val = request.args.get('search_val')
with sqlite3.connect(db_filepath) as cnx:
cur = cnx.cursor()
persons = Jsonifier.id_name(cur.execute(SearchQueries.person_search(search_val, max_results)).fetchall(), 'person')
orgs = Jsonifier.id_name(cur.execute(SearchQueries.org_search(search_val, max_results)).fetchall(), 'org')
confs = Jsonifier.id_name(cur.execute(SearchQueries.conf_search(search_val, max_results)).fetchall(), 'conf')
results = list(filter(lambda r: len(r['text']) < max_search_length, persons + orgs + confs))
return {
'results': results
}
def home():
with sqlite3.connect(db_filepath) as cnx:
max_results = 30
cur = cnx.cursor()
series = Jsonifier.home_series(cur.execute(SearchQueries.home_series(max_results)).fetchall())
confs = Jsonifier.conf_years(cur.execute(SearchQueries.home_confs(0, 2020, max_results)).fetchall())
person_orgs = Jsonifier.person_org(cur.execute(SearchQueries.home_person_orgs(max_results)).fetchall())
orgs = Jsonifier.id_name(cur.execute(SearchQueries.home_orgs(max_results)).fetchall(), 'org')
return {
'series': series,
'confs': confs,
'persons': person_orgs,
'orgs': orgs
}
def get_person():
person_id = request.args.get('id')
with sqlite3.connect(db_filepath) as cnx:
cur = cnx.cursor()
person_name = cur.execute(SearchQueries.person_name(person_id)).fetchone()
person_score = cur.execute(SearchQueries.person_score(person_id)).fetchone()
person_org = Jsonifier.id_name(cur.execute(SearchQueries.person_org(person_id)).fetchall(), 'org')
person_external_ids = Jsonifier.external_ids(cur.execute(SearchQueries.person_external_ids(person_id)).fetchone())
person_confs = Jsonifier.person_confs(cur.execute(SearchQueries.person_confs(person_id)).fetchall())
return {
'id': person_id,
'name': person_name[0],
'score': round(person_score[0], 2),
'org': person_org[0] if person_org else "", # id_name processes for list
'external_ids': person_external_ids,
'conferences': person_confs
}
def series():
letter = request.args.get('letter')
with sqlite3.connect(db_filepath) as cnx:
cur = cnx.cursor()
series = Jsonifier.home_series(cur.execute(SearchQueries.series_by_letter(letter)))
return {
'series': series
}
def get_org():
org_id = request.args.get('id')
with sqlite3.connect(db_filepath) as cnx:
cur = cnx.cursor()
org_name = cur.execute(SearchQueries.org_name(org_id)).fetchone()
org_score = cur.execute(SearchQueries.org_score(org_id)).fetchone()
org_persons = Jsonifier.id_name(
cur.execute(SearchQueries.org_persons(org_id)).fetchall(),
'person')
return {'name': org_name, 'score': org_score, 'persons': org_persons}
def get_conf():
conf_id = request.args.get('id')
with sqlite3.connect(db_filepath) as cnx:
cur = cnx.cursor()
conf_title = cur.execute(SearchQueries.conf_title(conf_id)).fetchone()
conf_score = cur.execute(SearchQueries.conf_score(conf_id)).fetchone()
conf_topics = cur.execute(SearchQueries.conf_topics(conf_id)).fetchall()
conf_pages = cur.execute(SearchQueries.conf_pages(conf_id)).fetchall()
conf_persons = cur.execute(SearchQueries.conf_persons(conf_id)).fetchall()
conf_series = cur.execute(SearchQueries.conf_series(conf_id)).fetchone()
sister_confs = Jsonifier.id_name(cur.execute(SearchQueries.sister_confs(conf_id)).fetchall(), 'conf')
return {
'id': conf_id,
'title': conf_title,
'score': round(conf_score[0], 2),
'topics': conf_topics,
'pages': conf_pages,
'persons': Jsonifier.conf_persons(conf_persons),
'series': conf_series,
'sister_confs': sister_confs
}
def get_conf():
conf_id = request.args.get('id')
with sqlite3.connect(db_filepath) as cnx:
cur = cnx.cursor()
conf_title = cur.execute(SearchQueries.conf_title(conf_id)).fetchone()
conf_score = cur.execute(SearchQueries.conf_score(conf_id)).fetchone()
conf_topics = cur.execute(
SearchQueries.conf_topics(conf_id)).fetchone()
conf_pages = cur.execute(SearchQueries.conf_pages(conf_id)).fetchall()
conf_persons = cur.execute(
SearchQueries.conf_persons(conf_id)).fetchall()
return {
'id': conf_id,
'title': conf_title,
'score': conf_score,
'topics': eval(conf_topics[0]),
'pages': conf_pages,
'persons': Jsonifier.conf_persons(conf_persons)
}