def get(self, base, ref):
passage1 = parse(base)
passage2 = parse(ref)
passage1_words = set()
passage1_lemmas = set()
passage1_domains = set()
passage2_words = set()
passage2_lemmas = set()
passage2_domains = set()
for verse in passage1['verses']:
passage1_words.update(passage1[verse])
for verse in passage2['verses']:
passage2_words.update(passage2[verse])
sql = "select distinct l.value Lemma, s.value Subdomain, d.value as domain from word w join lemma l on w.lemma_id = l.id and w.value = '%s' join wordsindomain wd on l.id = wd.lemma_id join subdomain s on wd.subdomain_id = s.id join domain d on s.domainid = d.id"
for word in passage1_words:
self.cur.execute(sql % word)
results = self.cur.fetchall()
if results:
for result in results:
passage1_lemmas.update([result['lemma']])
passage1_domains.update([result['domain'] + ": " + result['subdomain']])
for word in passage2_words:
self.cur.execute(sql % word)
results = self.cur.fetchall()
if results:
for result in results:
passage2_lemmas.update([result['lemma']])
passage2_domains.update([result['domain'] + ": " + result['subdomain']])
domain_overlap = passage1_domains.intersection(passage2_domains)
word_overlap = passage1_words.intersection(passage2_words)
lemma_overlap = passage1_lemmas.intersection(passage2_lemmas)
self.render('compare.html',passage1=passage1, passage2=passage2, word_overlap=word_overlap, lemma_overlap=lemma_overlap, domain_overlap=domain_overlap)
def get(self):
ref = self.get_cookie('lastref', None)
if not ref:
ref = 'Acts 2:42-47'
ref = urllib.unquote(ref)
passage = parse(ref)
'''for x in range(1,6):
passage['Matthew 1:%s' % x] = []
passage['Matthew 1:%s' % x] = self.db.lrange('Matthew 1:%s' % x, 0, -1)
for x in range(1, 6):
sql = "select text from verse where reference = 'Matthew 1:%s'" % x
self.cur.execute(sql)
passage["Matthew 1:%s" % x] = self.cur.fetchone()[0].split(' ')
'''
#passage = OrderedDict(sorted(passage.items(), key=lambda t: t[0]))
self.render('main.html',passage=passage)
def get(self, ref):
self.set_cookie('lastref', value=urllib.quote(ref))
passage = parse(ref)
self.render('main.html',passage=passage)
