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)