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
}
