def create_tweet(request):
"""
Create a tuit by user
:param request:
:return:
"""
tweet_instance = Tweet()
tweet_instance.id_user = request.POST.get('id_user', 0)
tweet_instance.content = request.POST.get('content', 0)
tweet_instance.save()
return HttpResponse('Tweet created')
def populate_tweets(_, __):
cols = ['sentiment', 'id', 'date', 'query_string', 'user', 'content']
dataframe = pandas.read_csv(
'./data_processing/data/training_data.16000.csv',
header=None,
names=cols,
encoding="ISO-8859-1",
low_memory=False)
# removes unnecessary columns
dataframe.drop(['date', 'query_string', 'user'], axis=1, inplace=True)
for i in range(0, dataframe['id'].count()):
tweet = Tweet(
id=dataframe.loc[i, 'id'],
content=dataframe.loc[i, 'content'],
created_at=datetime.now(),
updated_at=datetime.now(),
)
tweet.save()
def get_tweets(search_term, tweet_count):
consumer_key = str(os.environ.get('TWITTER_API_CONSUMER_KEY'))
consumer_secret = str(os.environ.get('TWITTER_CONSUMER_SECRET'))
access_token = str(os.environ.get('TWITTER_ACCESS_TOKEN'))
access_token_secret = str(os.environ.get('TWITTER_ACCESS_SECRET'))
auth = tweepy.OAuthHandler(consumer_key, consumer_secret)
auth.set_access_token(access_token, access_token_secret)
api = tweepy.API(auth)
tweets = api.search(search_term,
count=tweet_count,
lang='en',
show_user=True,
tweet_mode='extended')
for tweet in tweets:
try:
formatted_tweet = Tweet(
tweet_id=tweet.id,
date=tweet.created_at,
name=tweet.user.name,
twitter_name=tweet.user.screen_name,
text=tweet.full_text,
url='https://twitter.com/' + tweet.user.screen_name +
'/status/' + str(tweet.id),
sentiment_score=get_sentiment(tweet.full_text))
formatted_tweet.save()
print('Tweet ' + str(tweet.id) + ' saved!')
except IntegrityError:
print('An error occured...')
pass