def get_project_data(self): query = ''' SELECT p.id, p.title, p.description, p.source_url FROM public.projects p WHERE p.status = 'published' AND p.deleted = 'false' ''' projects = [] for record in self.get_records(query): project = ProjectInfo(record) project.load_sections(self) project.load_sections(self) project.load_tags(self) content = project.extract_text().decode("utf-8" ) projects.append({ 'id':project.id, 'title':project.title.decode("utf-8" ), 'url':project.source_url, 'text':list(word_tokenize_doc(content.lower())), 'content':content, 'tags':project.tags }) return projects
def get_project(self, project_id): query = ''' SELECT p.id, p.title, p.description, p.source_url FROM public.projects p WHERE p.id = %d ''' % project_id record = self.get_records(query)[0] project = ProjectInfo(record) project.load_sections(self) project.load_tags(self) content = project.extract_text().decode("utf-8" ) return { 'id':project.id, 'title':project.title.decode("utf-8" ), 'url':project.source_url, 'text':list(word_tokenize_doc(content.lower())), 'content':content, 'tags':project.tags }