def analyse_sentiment(id, text, posted_at):
document = types.Document(content=text,
type=enums.Document.Type.PLAIN_TEXT)
# Detect the entities in the text
try:
entities = nl_api_client.analyze_entity_sentiment(
document=document, encoding_type='UTF8').entities
# Build up our entities object to insert into the table
entities_object = []
for e in entities:
entity = Entity(
name=e.name, \
type=e.type, \
wikipedia_url=e.metadata['wikipedia_url'], \
mid=e.metadata['mid'], \
salience=e.salience, \
sentiment_score=e.sentiment.score, \
sentiment_magnitude=e.sentiment.magnitude, \
posted_at=posted_at, \
remote_post_id=id )
entity.mentions = create_entity_mentions(e.mentions)
entities_object.append(entity)
except InvalidArgument as err:
print(err)
return False
# Insert entities and mentions into the database
session.add_all(entities_object)
