def add_new_record_to_db(tweet, sentiment, img_hash, proc_txt):
timestamp = prt.convert_twitter_date_to_datetime(tweet['created_at'])
connection = mysql.connect()
with connection.cursor() as cursor:
sql = 'INSERT INTO Original_tweets (' \
'tweet_id, username, text, processed_text, image_url, ' \
'tweet_sentiment, unclear_sentiment, created_ts, image_hash) ' \
'VALUES (%s, %s, %s, %s, %s, %s, 0, %s, %s)'
cursor.execute(sql, (int(tweet['id']),
tweet['user']['screen_name'],
tweet['text'],
proc_txt,
tweet['extended_entities']['media'][0]['media_url'],
sentiment,
timestamp,
img_hash))
connection.commit()
connection.close()
def write_response_to_mysql(tweet):
"""
Saves tweet data to SQL
:param tweet: dictionary
:return: nothing
"""
connection = mysql_connection()
try:
with connection.cursor() as cursor:
id = tweet['id']
tweet_txt = tweet['text']
timestamp = prt.convert_twitter_date_to_datetime(tweet['created_at'])
username = tweet['user']['screen_name']
sql = "INSERT INTO Reply_tweets (tweet_id, username, text, created_ts) VALUES (%s, %s, %s, %s, %s)"
cursor.execute(sql, (id, username, tweet_txt, timestamp))
except:
pass
connection.close()
def add_dupe_to_db(dupe_tweet, match_id, dupe_sentiment, img_hash, proc_txt):
timestamp = prt.convert_twitter_date_to_datetime(dupe_tweet['created_at'])
connection = mysql.connect()
with connection.cursor() as cursor:
sql = 'INSERT INTO Duplicate_images ( ' \
'tweet_id, primary_tweet, username, text, processed_text, ' \
'image_url, tweet_sentiment, created_ts, image_hash, ' \
'unclear_sentiment) ' \
'VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, 0)'
cursor.execute(sql, (int(dupe_tweet['id']),
int(match_id),
dupe_tweet['user']['screen_name'],
dupe_tweet['text'],
proc_txt,
dupe_tweet['extended_entities']['media'][0]['media_url'],
dupe_sentiment,
timestamp,
img_hash))
connection.commit()
connection.close()
